PostgreSQL is a community developed, open source, relational database, made available under a BSD-like license. The PostgreSQL documentation is expansive and incredibly useful.

learn more… | top users | synonyms

5
votes
1answer
2k views

Connection to postgresql inside Virtualbox via portforwarding fails

I have a postgresql server inside a virtualbox created by vagrant. I have also set up a portforwarding from 5432 inside the box to 15432 on the host system via the Vagrant file. When connecting via ...
2
votes
1answer
65 views

Why does `psql --file` misinterpret tilde?

Earlier I used pg_dump to create a database backup in my home directory called book_dump.sql. I want to restore the backup to an empty database called book. To restore the backup, I tried this ...
0
votes
0answers
88 views

How to increase IO for operation “SELECT”?

I use windows server 2008r2 with role Hyper-V. The guest system is Ubuntu 12.04 LTC (64 bit). It is situated on the dynamic virtual hard disk /dev/sda. There is postgresql-9.1 (amd64) on the Ubuntu ...
0
votes
1answer
578 views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
2
votes
2answers
703 views

Running a test database on RAM disk

Is it possible to create and start a Postgresql server as an unprivileged user with data directory owned by the same user? I want to run tests and create a test database for it, the data files being ...
0
votes
1answer
344 views

Installing Unity Asset Server on Debian has problems with postgresql

I used to have Debian Lenny (non-VPS, dedicated hosting) and Unity Asset Server (Unity3D's version control) was running smoothly. But recently I moved to Debian Squeeze (running on VPS) and I can't ...
0
votes
1answer
1k views

How come the shell for my Mac can't find the postgresql command?

I just installed PostGreSQL on my Mac. I'm sure of that since I can open up the pqsl shell just fine via clicking on However, when I try calling postgres -D /usr/local/pgsql/data in terminal to ...
0
votes
1answer
134 views

Postgres DB table recovery

I was using PG Admin and modifying a table in my DB. I was actually adding two fields. Once done, I hit the OK button and PG Admin hung up. I think this is the first time. Now I cannot open that ...
0
votes
1answer
771 views

Postfix: change recipient_delimiter with virtual_mailboxes

I have an email setup using Postfix, Dovecot, PostgreSQL. I am trying to change the recipient_delimiter to be - (dash) instead of + (plus) but the address are being rejected. In order to get the + ...
0
votes
1answer
33 views

Some tricky configurations in postgreSQL

I'm trying to set up some security configurations over my server, but I've checked file postgresql.conf and I just managed to change the IP it listens to. What I am looking to do is the following: ...
6
votes
1answer
2k views

Calling the psql command without selecting any database

The syntax of the psql command line client is psql [option...] [dbname [username]] I am passing the command ALTER DATABASE x RENAME to y to this command: echo `ALTER DATABASE x RENAME to y` | psql ...
3
votes
3answers
234 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 ...
1
vote
0answers
402 views

Ubuntu login screen doesn't show up after installing postgresql

I just installed Ubuntu 12.04 on my new machine and everything works fine. However, when I install postgresql and shut down the computer, when I log back in, there's no graphical login screen. The ...
3
votes
2answers
770 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 ...
0
votes
3answers
182 views

Postgres configuration

I'm installing PosgreSQL 9.0 over FreeBSD 8.1. In MySQL I have to change the root SQL user's password, here how can I do? And how can I add other SQL users? Thanks.
1
vote
2answers
2k views

PhpPgAdmin: Edit contents

How can I edit the contents of a table in phpPgAdmin without using SQL? Or is there an alternative tool that allows me to edit datasets?
0
votes
1answer
42 views

Model for Cooperation in a class? [closed]

Assume you have six classes of students with low level of computer skills. They use Gmail inboxes to store old exam questions, notes and tips. Dropbox and Google Drive too, since Gmail inboxes get ...
0
votes
1answer
1k views

How to configure bi-directional replication on a single table in symmetricDS?

I have installed and configured the database replication software from http://www.symmetricds.org/ on the client and the server. I have followed the directions to setup the example replication, and ...
0
votes
1answer
735 views

Exception while configuring symmetricDS with postgresql on Linux

SymmetricDS is a java tool which can replicate databases and tables across an intermittent internet connection. I am having trouble configuring it to work with postgresql. I am doing this piece of ...
1
vote
0answers
638 views

Failing to setup postgres on raspberry pi

I installed postgresql on my raspberry pi. then, i try to access it and I get: pi@raspbmc:~$ psql psql: FATAL: role "pi" does not exist pi@raspbmc:~$ psql -U postgres psql: FATAL: Peer ...
1
vote
1answer
1k views

How display result of multi select in PgAdmin III?

select 1 as a,4 as b, 5 as c; select 1 as a,3 as b; Result display only of `select 1 as a,3 as b; How display result of multi select in PgAdmin III?`
1
vote
0answers
145 views

PostgresSQL giving blank screen on installation on Windows 64 bit

I downloaded postgresql-9.2.4-1-windows-x64. When I ran the exe it just gave me a blank screen. I tried "run as admin" but still the same result. I even uninstalled my anti-virus (Security ...
0
votes
3answers
99 views

Linux equivalent to Windows error code 3010?

I am fairly new to error codes and was trying to figure out an equivalent error code to Window's error code 3010 which states that an installation succeeded but requires a reboot. I tried looking ...
0
votes
1answer
165 views

Why does PgAdmin III give warning that PgAdmin.exe has disappeared from C drive?

So I'm currently working with PostgreSQL, PostGIS, p-mapper, and QuantumGIS to build a web-mapping system. And earlier this morning, I opened PgAdmin III just to check on my database, no editing, no ...
-1
votes
1answer
72 views

COmmunication between windows host and centos guest through vbox [closed]

I am trying to access the db which is there on my windows 7 machine through centos mounted on oracle virtual box. I am using python as the language, using Django. I have made the following changes ...
0
votes
2answers
529 views

Postgresql on linux ami

I'm a newbie to aws and postgresql I've launch an instance with quick wizard of linux ami 2013.03.01 It says that the instance include a repository access to postgresql - I thought that means that ...
0
votes
2answers
774 views

redirect output from rpm -Uvh postgresql91-*.rpm

I have a bash script to install postgresql part of the script contains this command rpm -Uvh postgresql91-*.rpm i need to direct ALL the output generated by this rpm command into a log file FROM ...
0
votes
2answers
2k views

How to manually install PostgreSql on Redhat

I have to install PostgreSql onto Redhat. I cannot use YUM. I have downloaded these rpm's postgresql91-9.1.9-1PGDG.rhel5.x86_64.rpm postgresql91-contrib-9.1.9-1PGDG.rhel5.x86_64.rpm ...
0
votes
1answer
598 views

How do I install PostgreSQL 9.1.4 on RHEL 5?

I specifically need version 9.1.4 --- unfortunately there are no ifs, ands, or buts. It's not my decision. I have downloaded the .run file available from PostgreSQL's SourceForge listing, but I can't ...
2
votes
0answers
355 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 ...
1
vote
1answer
2k views

PostgreSQL 9.2.4 (Windows 7) - Service won't start, “could not load pg_hba.conf”

I am trying to get Postgres 9.2.4 to run as a service on Windows 7. After installing postgres, the service was running fine. However, after setting postgres up as a server for another program, the ...
0
votes
1answer
207 views

Difference between `/var/lib/pgsql/9.1/data/pg_hba.conf` and `/var/lib/pgsql/pg_hba.conf`

From http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html, it says: A default pg_hba.conf file is installed when the data directory is initialized by initdb. I would assume when ...
1
vote
3answers
427 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
0answers
449 views

installing redis server on an ec2 instance where postgres is installed

I have an ec2 microinstance. I have installed only my postgressql database server over there. I want to try redis for celery backend and also for some realtime value storing. I am expecting as of ...
0
votes
1answer
1k views

Data Source not found in Excel (Data/From other sources/From MS Query) connecting to PostgreSQL

I set up an ODBC connection to a datamart with c:\windows\SysWOW64\odbcad32.exe. I set up my Data Sources in the System DSN tab using the PostgreSQL ANSI driver. When I go into Excel bring in the ...
2
votes
1answer
719 views

apt-get fails at everything in Ubuntu due to postgresql error - how to fix?

I've got a server with zoneminder, mysql, ffserver and some ffmpeg instances running on it, but for some reason everything seems to be tied to PostgreSQL. I noticed an error when loading the ...
0
votes
1answer
550 views

Access PostgreSQL on Mac without switching users

I've got a Mac running OS X Lion (10.7.5), with PostgreSQL 9.2.4 installed. I've initialized a database cluster and started a server, all as the postgres user. When I try to access certain ...
7
votes
4answers
551 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 ...
0
votes
0answers
140 views

Network goes “Request Timed Out” when I run a query

I use postgreSQL 9.2 as the database and Java 6 as the programming language. There is no problem when I run my program on the server computer. But when I run my program from a remote client, ...
1
vote
1answer
957 views

PostgreSQL installed from source, no pg_config alias

So I installed pgsql 9.0.10 on Ubuntu 12.10 from source (./configure, make, make install). It all went well, created /usr/local/pgsql/ and everything that it should contain, but I have encountered one ...
0
votes
1answer
522 views

where do I put my `pg_hba.conf` file in EnterpriseDB for OS X

I have a pg_hba.conf.sample file, but no pg_hba.conf file. I want to make one and put it in the right place. Where do I put pg_hba.conf?
0
votes
1answer
246 views

Upgrading PostgreSQL via Homebrew

I'm attempting to update PostgreSQL from my system's version (9.1.5) to the latest release (9.2.3). I've followed the directions on this railscast and am encountering issues. After installing psql ...
15
votes
2answers
14k 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?
2
votes
1answer
3k 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, ...
0
votes
1answer
494 views

rsync fails under daemon but succeeds when run from terminal

I have script [1] that is executed by Postgres daemon (WAL archiver) and fails with exit code 12; see [2]. But if I execute the same script on a terminal/ssh session, it succeeds; see [3]. User ...
0
votes
1answer
320 views

How to change output pattern in shell?

I run the psql command from a Linux shell. The resulting output looks like a table: Name Age ----------------- John 24 But I would like to get the result with commas like ...
3
votes
1answer
488 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 ...
0
votes
1answer
1k views

How to install PostgreSQL 9.2 on CentOS 5?

PostgreSQL 9.2 isn't available on CentOS (the latest version is 8.1), so in order to get it, one has to add a postgre repository with the command rpm -ivh ...
2
votes
1answer
73 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 ...
1
vote
1answer
460 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 ...