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

1
vote
1answer
62 views

database statistics and reporting with or without parsing of built in logs

I prefer a generic statistical utility / plugin / application, but don't limit myself as specific might do well too. I want to see a way by which I can see query statistics for ALL queries. e.g ...
0
votes
1answer
2k views

NOQUEUE: reject: Relay access denied

I recently setup a mail server following the instructions on linode.com (https://library.linode.com/email/postfix/postfix2.9.6-dovecot2.0.19-mysql) except I am using postgreSQL instead of mySQL. ...
0
votes
1answer
47 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
241 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
22 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: ...
5
votes
1answer
184 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 ...
0
votes
0answers
26 views

Attach a new EBS volume to an existing EC2 db server instance

I had a micro instance of EC2, wherein I put my PostgreSQL database server. The EC2 instance came with the default Block Store. As of now, I want to attach a new Block Store to the existing EC2 ...
1
vote
0answers
235 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 ...
0
votes
1answer
37 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
61 views

Copying File From One User To Another

So I have this file stored in my account. It's postgres dump. To be able to use postgres it seems that I have to execute the following command. sudo su - postgres Once I do this I am now working as ...
1
vote
1answer
243 views

Need Tool to Extract ER Diagram fom PostgreSQL 9,1

Guys I need to compare 2 different databases running in PostgreSQL. I would like to use some tool to extract the diagram in a automatic way, Ive tried pgadmin3 and pgdesigner but they seem ...
0
votes
1answer
349 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
404 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 ...
0
votes
1answer
2k views

Setting up postgresql server connection with pgadmin3 fails with Exception

I have installed postgresql database on Fedora 17. When I create a new server connection through pgadmin3, I get this Error in a popup window: postgresql The server doesn't accept the current ...
0
votes
0answers
320 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
0answers
70 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
0answers
148 views

pgpass file never gets recognized by the 64-bit postgreSQL ODBC driver.

I have been spending quite a while trying to get the amd64 version of the postgreSQL ODBC driver to establish a connection with a pgpass file. Every time I try to open a connection using SSLMODE = ...
0
votes
1answer
406 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?`
0
votes
1answer
708 views

How to keep connection alive in pgAdmin

In pgAdmin, if I'm connecting to a host and leave it idle for a few minutes, the connection drops, and I have to reconnect again. On many occasions pgAdmin also hangs when I try to reconnect, so I ...
0
votes
3answers
83 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
86 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
40 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
232 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
178 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
425 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
305 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 ...
0
votes
1answer
560 views

How to recompile the PHP with --with-pgsql

I have installed the postgresql, php and apache to Amazon Linux AMI. Now I want to use the phpPgAdmin, it prompts "Your PHP installation does not support PostgreSQL. You need to recompile PHP using ...
2
votes
0answers
155 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
2answers
1k views

pgAdmin list of keyboard shortcuts

I've been using pgAdmin for several days and so far I like it. However, I can't find a list of keyboard shortcuts documented anywhere, either on the pgAdmin site, in the help, or in the options menu. ...
0
votes
1answer
155 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
220 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
944 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 ...
5
votes
3answers
6k views

Install postgresql 9.3 on ubuntu 12.04

I am attempting to install PG 9.3 on Ubuntu 12.04 ---- Begin output of apt-get -q -y install postgresql-client-9.3=9.3~beta1-1.pgdg12.4+2 ---- STDOUT: Reading package lists... Building dependency ...
0
votes
1answer
619 views

PostgreSQL Windows installation failure

I was trying to install PostgreSQL 9.2 in Windows 7. When I launched the installer, it failed and showed the error message: Unable to write inside TEMP environment variable path I did a lot of ...
0
votes
1answer
1k views

Oracle11g localhost:1158/em not connect

In my Windows 7 professional edition, I installed Oracle Database Express Edition 11g Release 2 which is downloaded from Oracle.com. The SID is 'orcl', username is 'system'. When I attempt connect to ...
1
vote
0answers
245 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
588 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 ...
1
vote
1answer
441 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
285 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 ...
0
votes
0answers
91 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, ...
0
votes
2answers
6k views

Default password for postgreSQL

What is the default password for the "postgres" user when I install postgreSQL on Windows? I googled for "postgres default password" but it doesn't return any immediate result.
1
vote
1answer
409 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
166 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
138 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 ...
0
votes
1answer
988 views

Debian PostgreSQL doesn't appear to be working

I've just set up a server running Debian 6.0 64-bit. I've installed PostgreSQL through aptitude, and now i try to access PostgreSQL without any luck. I am trying to access psql as the user postgres, ...
2
votes
1answer
1k 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
265 views

Watch folder and import into database

I am trying to set up a system that whenever a new file is created in a folder it will automatically read the content and push it in a database. These files will mainly be .txt files but I might have ...
0
votes
1answer
76 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 ...
0
votes
1answer
184 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 ...
0
votes
1answer
1k views

Homebrew postgres won't start after uninstall, reinstall and reboot

I uninstalled and reinstalled postgresql via homebrew. It worked fine until I restarted my computer. Now I'm trying to run my tests and they're blowing up. I'm looking at the current processes and I ...