Re: [ADMIN] I can't get postgres started.

2010-09-30 Thread Devrim GÜNDÜZ
On Thu, 2010-09-30 at 21:10 -0700, Tena Sakai wrote: > I recently built postgres 8.4.4 from source and tested it. > It seemed to work fine then, but I cannot seem to run psql > today. I built it to run on port 6543. Do I need to specify the > port number when I start it? Did you change the port

[ADMIN] I can't get postgres started.

2010-09-30 Thread Tena Sakai
Hi everybody, Sorry, I previously didn’t put subject line. I recently built postgres 8.4.4 from source and tested it. It seemed to work fine then, but I cannot seem to run psql today. I built it to run on port 6543. Do I need to specify the port number when I start it? Here’s the session dialo

[ADMIN]

2010-09-30 Thread Tena Sakai
Hi everybody, I recently built postgres 8.4.4 from source and tested it. It seemed to work fine then, but I cannot seem to run psql today. I built it to run on port 6543. Do I need to specify the port number when I start it? Here’s the session dialog: bash-3.2$ pg_ctl stop -D /usr/local/pgsq

Re: [ADMIN] could not connect to server: Connection refused (0x0000274D/10061)

2010-09-30 Thread Greg Smith
Anuj Pankaj wrote: I installed Postgres 8.1.4 on Linux and postgres server is running and I successfully created database on local machine. I modified listen_addresses = '*' in Postgresql.conf and however If I try to access postgres through pgAdmin III. I am sticking with an exception.

Re: [ADMIN] pg_dumpall blocking other sessions

2010-09-30 Thread Guillaume Lelarge
Le 30/09/2010 17:50, Terry Schmitt a écrit : > [...] > I had a situation where a session was getting blocked while per > performing a pg_dumpall. > > I could see the pg_dumpall session executing a COPY command on a table > in one schema. > Another user session was attempting to truncate a differen

[ADMIN] pg_dumpall blocking other sessions

2010-09-30 Thread Terry Schmitt
Hi All, I had a situation where a session was getting blocked while per performing a pg_dumpall. I could see the pg_dumpall session executing a COPY command on a table in one schema. Another user session was attempting to truncate a different table in a different schema, but in the same database.

[ADMIN] PGPOOL-II

2010-09-30 Thread Victor Hugo
Hi ! I am compiling the pgpool-II and the following error below happens: configure: error: libpq is not installed or libpq is old I ran the following command : ./configure --prefix=/opt/PostgreSQL/pgpoolII --with-pgsql=/opt/PostgreSQL/8.4 --with-pgsql-libdir=/opt/PostgreSQL/8.4/lib --with-pgsql-i

Re: [ADMIN] could not connect to server: Connection refused (0x0000274D/10061)

2010-09-30 Thread Igor Neyman
From: Anuj Pankaj [mailto:an...@cybage.com] Sent: Wednesday, September 29, 2010 8:57 AM To: pgsql-admin@postgresql.org Subject: could not connect to server: Connection refused (0x274D/10061) Hi,