Re: [ADMIN] Yet Another Socket .s.PGSQL.5432 Problem

2007-08-17 Thread Peter Eisentraut
Am Donnerstag, 16. August 2007 23:41 schrieb Hilton Perantunes: Alvaro, it works like a charm =). Thank you all. Bad, bad Debian.. no cookies for you (and I'll read the error messages more carefully next time)! The problem is quite likely some variant on the following: You had your

Re: [ADMIN] Yet Another Socket .s.PGSQL.5432 Problem

2007-08-17 Thread Hilton Perantunes
Exactly what happened, Peter. Something was preventing me of successfully install 8.2.4 through apt-get, so I did it by hand. I'll read the documentation about LD_LIBRARY_PATH. Thank you. Hilton Perantunes On 8/17/07, Peter Eisentraut [EMAIL PROTECTED] wrote: Am Donnerstag, 16. August 2007

Re: [ADMIN] Yet Another Socket .s.PGSQL.5432 Problem

2007-08-16 Thread Hilton Perantunes
Tom, really... the socket lies in /tmp/. The socket file has 0777 postgres:postgres. /tmp/ has 0777 root:root. The socket file is removed when I stop the database. On 8/15/07, Tom Lane [EMAIL PROTECTED] wrote: Hilton Perantunes [EMAIL PROTECTED] writes: When I stop the database, the

Re: [ADMIN] Yet Another Socket .s.PGSQL.5432 Problem

2007-08-16 Thread Alvaro Herrera
Hilton Perantunes escribió: Tom, really... the socket lies in /tmp/. The socket file has 0777 postgres:postgres. /tmp/ has 0777 root:root. psql is complaining about /var/run/postgresql (the Debian packaging of libpq does that). Try setting PGHOST to /tmp, like in PGHOST=/tmp psql -- Alvaro

Re: [ADMIN] Yet Another Socket .s.PGSQL.5432 Problem

2007-08-16 Thread Hilton Perantunes
Alvaro, it works like a charm =). Thank you all. Bad, bad Debian.. no cookies for you (and I'll read the error messages more carefully next time)! Abraços.. Hilton Perantunes On 8/16/07, Alvaro Herrera [EMAIL PROTECTED] wrote: Hilton Perantunes escribió: Tom, really... the socket lies in

[ADMIN] Yet Another Socket .s.PGSQL.5432 Problem

2007-08-15 Thread Hilton Perantunes
Hi folks! That's another sob sob.. I can't connect to socket blah blah .. .s.PGSQL.5432 asking for help. But this is somewhat bizarre, and i'm not used to the 8.2's postgresql.conf file. I'm running a PostgreSQL 8.4.2 powered by Debian Sarge (very)Unstable. My PHP application successfully

Re: [ADMIN] Yet Another Socket .s.PGSQL.5432 Problem

2007-08-15 Thread Julio Cesar Sánchez González
El mié, 15-08-2007 a las 17:13 -0300, Hilton Perantunes escribió: Hi folks! That's another sob sob.. I can't connect to socket blah blah .. .s.PGSQL.5432 asking for help. But this is somewhat bizarre, and i'm not used to the 8.2's postgresql.conf file. I'm running a PostgreSQL 8.4.2

Re: [ADMIN] Yet Another Socket .s.PGSQL.5432 Problem

2007-08-15 Thread Hilton Perantunes
Thanks for answering, Julio. When I stop the database, the socket file is automatically removed. That's the way it happened before... but now, oddly enough, I restarted the database at will several times, my app is still running, pgadmin too... and no socket file is created. o.0 (and I still

Re: [ADMIN] Yet Another Socket .s.PGSQL.5432 Problem

2007-08-15 Thread Tom Lane
Hilton Perantunes [EMAIL PROTECTED] writes: When I stop the database, the socket file is automatically removed. That's the way it happened before... but now, oddly enough, I restarted the database at will several times, my app is still running, pgadmin too... and no socket file is created. o.0