PostgreSQL is a community developed, open source, relational database, made available under a BSD-like license. The PostgreSQL documentation is expansive and incredibly useful.
9
votes
2answers
7k views
How do I connect to a PostgreSQL server using LibreOffice Base?
I'm running into errors when I try to connect to a PostgreSQL server on the local machine using LibreOffice Base 3.5:
The following syntax (localhost:5432=<database name>; database name ...
7
votes
2answers
8k views
postgres ident authentication failed
I'm trying to set up django on a fresh Ubuntu VM. I'm following the tutorials along until I get to this:
psycopg2.OperationalError: FATAL: Ident authentication failed for user "postgres"
The ...
7
votes
4answers
376 views
I'm managing SQLite, MySQL and PostgreSQL databases and want a tool for this locally
I develop web applications on Mac OSX in SQLite, MySQL and PostgreSQL and these are then put on the webserver. I want to be able to take the brunt out of looking at the terminal locally when dealing ...
5
votes
1answer
2k views
PostgreSQL homebrew installation lacks config files
So I successfully installed PostgreSQL 9.1 on MacOSX Lion. Unlike people say, I didn't have to change the PATH and no other version of PostgreSQL was installed on the system ($ psql --version
shows ...
4
votes
2answers
4k views
Prevent Postgresql from running at startup
At some point in the past, I had installed posgresql and I can't get rid of it:
$ ps -A|egrep postg 232 ??
287 ?? 0:00.02 postgres: logger process ...
4
votes
1answer
4k views
How do I fix “Library not loaded: libssl.1.0.0.dylib” with PostgreSQL?
After deleting Macports, I've had some strange behaviour. When I try to run PostgreSQL via CLI, I get:
pawel:~ pawel$ psql
dyld: Library not loaded: /opt/local/lib/libssl.1.0.0.dylib
Referenced ...
4
votes
1answer
58 views
Is password required for restricted database servers [closed]
I have a dedicated Database server which is have PostgreSQL 9.1.
This server has firewall. Only 10.0.0.3 is allowed to connect and access to this server via Firewall. All other requests from other ...
3
votes
1answer
3k views
How can I create a database in PostgreSQL on Windows 7?
I use Windows 7 on my own home computer. I have installed PostgreSQL and now I would like to create an database.
I tried with createdb mydatabase but I got this error message:
createdb: could not ...
3
votes
3answers
55 views
heredoc prompts not passed in
I'm trying to automate the creation of a PostgreSQL user with a bash script.
I'm specifying the initial password as prompted by the "createuser" command, and I'd like to do it in bash, which I think ...
3
votes
1answer
966 views
How can I use UTF-8 on Linux from Windows 7 via PuTTY?
I use PuTTY on Windows 7 to access a Linux machine with Ubuntu 10.10. I think that Windows 7 is using Latin-1. But I need to use UTF-8 on the Linux machine and in a PostgreSQL database.
How can I do ...
3
votes
2answers
3k views
Incremental Backup for PostgreSQL 8.3
I'm looking for a way to make good incremental backups for a large (more than 100 GB) PostgreSQL 8.3 DB. I'm currently using pg_dump which isn't incremental and very slow in backup and restore, ...
3
votes
1answer
1k views
Postgresql has broken apt-get on Ubuntu
On ubuntu 12.04, whenever I try to install a package using apt-get I'm greeted by:
The following packages have unmet dependencies:
postgresql-9.1 : Depends: postgresql-client-9.1 but it is not going ...
3
votes
1answer
4k views
How to make PostgreSQL start at boot time in Ubuntu?
Every time I boot my computer, I need to start Posgtres manually via
sudo /etc/init.d/postgresql-8.4 start
It was an easy task to make it start automatically with Init in place: just add a symlink ...
3
votes
2answers
2k views
Install libpq-dev on Mac OS?
Does anyone know how I can install libpq-dev on Mac OS 10.6? It's a pre-requisite for something else I want to install.
There doesn't seem to be a macport for it, so how can I install it on a Mac?
3
votes
1answer
786 views
ubuntu: root password
Well, I don't know exactly how it happened. But, thing is if I issue a command which I need root priviliges an error message comes that says <user> does not have an entry in sudoers file
I ...
3
votes
1answer
96 views
Ubuntu postgresql missing man pages, PGDATA, and critical commands
I installed postgresql as well as postgresql-doc, nevertheless it seems that ubuntu either does not put commands in my path, or if it does put them in my path, it removes the man pages for the ...
2
votes
1answer
118 views
Too Much Swapping, even though RAM is ~75% Empty
I have a VPS with 9GB RAM, 300GB HDD, 3 GB Swap, 7 Cores.
The OS is CentOS 5.7 Final.
I have postgres9.0 running on my machine, with proper tuning done (at least by book/wiki of PostgreSQL).
What ...
2
votes
2answers
430 views
PostgreSQL - syntax error
What is wrong with the following statement?
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO foo;
I get this error
ERROR: syntax error at or near "ALL"
LINE 2: ON ALL TABLES ...
2
votes
2answers
115 views
SSH without password doesn't work with user postgres
I've tried manually adding the pub key to authorized_keys and authorized_keys2. I've also double checked the permissions on .ssh (700) and authorized_keys (644). I can login without password on the ...
2
votes
2answers
413 views
Help installing postgres in ubuntu
I'm trying to install postgresql in the latest ubunutu, and I'm following these instructions. When I sudo -u postgres psql postgres I get this error: could not change directory to "/home/james"
I'd ...
2
votes
1answer
159 views
Emacs M-x sql-postgres encryption
Is it possible to encrypt the connection established with M-x sql-postgres in Emacs? If so, how?
2
votes
1answer
616 views
Kaspersky blocks PostgreSQL 8.4.1 installation
I was just installing PostgreSQL 4.1 with Drupal and other tools. While the Setup was installing phpWiki.exe, Kaspersky blocked the Setup and quarantined two files:
phpWiki.exe, and
StackBuilder.exe
...
2
votes
1answer
72 views
PostGreSQL Authentication Failure with “trust” option
I'm trying to setup a PostGIS db using PostGreSQL 9.1 on Ubuntu 12.04. I've set up the database, created a user account "jay" with no password, added spatial functionality following section 2.5 here, ...
2
votes
1answer
340 views
Cannot start Postgres daemon after installing with Yum
I was trying to install Postgres 9.1.4 on Fedora 17 using Yum. If I do:
sudo yum install postgres-libs
sudo yum install postgres
sudo yum install postgis
All the installs appear to complete ...
2
votes
1answer
342 views
make pgrouting problem
I try to make pgrouting. What am I doing wrong?
anton@anton-P4I45Gx-PE:~/src/pgrouting$ cmake -DWITH_TSP=ON -DWITH_DD=ON .
-- POSTGRESQL_EXECUTABLE is POSTGRESQL_EXECUTABLE-NOTFOUND
-- Found ...
2
votes
1answer
224 views
Services running multiple times?
I've installed a postgres db on my debian squeeze. There's a /etc/init.d/postresql to control the database. When I type pstree -c, I get two traces with postgresql. After /etc/init.d/postgresl stop I ...
2
votes
3answers
1k views
Superuser rights on postgres
How do I get superuser rights on postgres. I am among sudoers in Linux, but I don't have rights to create users in postgres. How can I gain superuser rights in postgres?
This is my pg_hba.conf:
# ...
2
votes
0answers
14 views
Could not open log file “pg_log/postgresql-Sun.log”: No such file or directory
After installing postgresql on fedora 17 using the yum package manager. When I try to start it I get the error message.
[vagrant@example ~]$ sudo /sbin/service postgresql status
Redirecting to ...
2
votes
1answer
44 views
PostgresSQL created a user account on OSX
Hello I installed PostgresSQL on my macbook but when I restarted my macbook later I saw that instead of the usual User account and the Guest account I now have also a Postgres user in my startup page ...
2
votes
1answer
318 views
(-bash: initdb: command not found) When installing postgres mac
I get the following error (-bash: initdb: command not found) in the terminal when trying to install postgres on my mountain lion mac osx?
Also, does any one have a good resource for installing ...
2
votes
0answers
186 views
How to copy and paste content from PostGIS psql console in Windows 7?
I just get started with POSTGIS and I am digging through Mannig's POSTGIS in Action. I am using Windows 7, POSTGIS 1.5 and Postgresql 9.
Sadly, I am not able to copy and paste anything from my text ...
2
votes
1answer
193 views
Windows based Apache/PHP/Perl/database stacks
Does anyone know if XAMPP's Perl also provides Tk support? Does anyone know of a similar stack which provides PostresSQL in addition to/instead of MySQL? I'd like this to run on Win 7 and XP.
Edit: ...
1
vote
2answers
579 views
Free Database Browser for PostgreSQL?
Does anyone know of a free PostgreSQLdatabase browser that I can use besides RazorSQL since It has a 30 day trial? It would be great to have something similar to the SQlite Database Browser, light ...
1
vote
1answer
288 views
Searching a whole postgres db for a string
In phpmyadmin, I can easily search for text in the tables in my databases using the search tab. Was wondering if I can do the same with the postgres installed locally on my computer. I have looked at ...
1
vote
3answers
988 views
PostgreSQL Admin Tool for mac os X
I'm looking for desktop admin tool similar to phpPgAdmin for POstgreSQL in Mac os X . Any recomendation?
1
vote
1answer
541 views
How do I give MacPorts privileges?
I tried to install PostgreSQL server development libraries using MacPorts and got the following:
Warning: MacPorts running without privileges. You may be unable to complete certain actions (e.g. ...
1
vote
3answers
25 views
Difference between `/sbin/service postgresql-9.1 start` and `/etc/init.d/postgresql-9.1 start`
I have seen two ways to start a postgresql server:
/sbin/service postgresql-9.1 start
/etc/init.d/postgresql-9.1 start
Could anyone explain the difference between these two? Or there's no ...
1
vote
1answer
85 views
How can I build an old application for 64bit?
I am trying to build postgresql 7.4.6 on a 64bit machine for 64bit. I'm not sure whether this code is 64bit compatible. Is there a way to check?
If it is 64bit compatible, do I need to do anything ...
1
vote
1answer
602 views
Shared memory in chroot environment
I'm playing with Ubuntu 11.10 launched in a chroot environment under Android 3.2.1. Most of the software works fine except PostgreSQL. When installed or initdb launched it's saying:
FATAL: could ...
1
vote
1answer
321 views
Prevent PostgreSQL to start when Mac OS X boots
I installed PostgreSQL 8.4.4 in Mac OS X. I am pretty happy and I don't want to uninstall it since I do occasional development on it.
But I would definitely like to prevent OS X to run it every time ...
1
vote
2answers
488 views
How can I install Postgres GUI in Fedora 10?
On my server I have Postgres 8.4, but there is no GUI included, so I need to install one. Is that possible? How is it done?
1
vote
1answer
2k views
XAMPP with PostgreSQL
I'm looking for a package like XAMPP, but instead of MySQL it would use PostgreSQL. I've done some searching and haven't turned up anything other than doing a full server setup of both.
1
vote
1answer
114 views
Postgresql is not avaible in Libreoffice Base
I want to edit a postgresql base using libreoffice-base.
When I launch the database wizard of Libreoffice-base, I am blocked at the first step: I can select an existing base, but the only ones ...
1
vote
1answer
166 views
User permissions for creating PostgreSQL DB
I'm working on Ubuntu. Following is one of my commands.
$ psql -U kuser -d postgres
Then this connects to the database. But from postgres terminal when i try
postgres=> CREATE DATABASE kdb;
...
1
vote
1answer
240 views
Are PostgreSQL's database files binary compatible between Windows, Linux and Mac OS X?
Assuming 64-bit OS editions on each and only one copy of PostgreSQL running at a time, can I host my PostgreSQL database files in Dropbox and expect binary compatibility on all three platforms?
I've ...
1
vote
2answers
63 views
How to I change the path when I log in as a new user in ubuntu?
I am running ubuntu on a flash drive. The default log in is "ubuntu". I installed Postgresql and created a new user called "postgres". However, when I switch to postgres with "su postgres", the ...
1
vote
1answer
558 views
Using PostgreSQL on Mac OS X Lion
I just got a new Mac with Lion installed on it. I then installed Xcode (4.1 through the App Store). Next, I installed Homebrew and I was about to do brew install postgresql like I had done on Snow ...
1
vote
1answer
769 views
How do I install the Postgres command-line client (psql) on OS X using MacPorts?
I'm trying to install the Posgtres command-line client (typically psql on Linux). I've got postgres installed through MacPorts (postgresql90 and postgresql90-server) but still don't see the client ...
1
vote
1answer
767 views
How do I restore a Postgres database from file backups
I use Time Machine on my Mac to backup my system. I have just managed to clobber my Postgres database and would like to restore it using my Time Machine backups. The latest changes don't matter, so I ...
1
vote
1answer
279 views
change the UI lang when using postgresql psql.exe
I have a PostgreSQL 8.4 database, installed with Japanese as the main language. I am connecting from an English Windows 7 client using psql.exe. Is there any way to change the UI of the messages shown ...
