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

2007-08-20 Thread Dimitri Fontaine
Le vendredi 17 août 2007, Hilton Perantunes a écrit : > Exactly what happened, Peter. Something was preventing me of successfully > install 8.2.4 through apt-get, so I did it by hand. Maybe you're using debian stable, in which case you'd have to use some backport of PostgreSQL to get 8.2.4. Or si

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 20

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 distr

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 li

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 -- Alvar

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,

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 creat

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 can'

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