Re: [ADMIN] PG engine takeover or switch over

2007-08-16 Thread Hannes Dorbath
On 15.08.2007 21:30, Medi Montaseri wrote: I am looking for some suggestions to optimize the following problem/solution. Given two nodes A and B (two computers) in a active-passive mode where A is running PG engine, and B is simply standing by, and a common storage (twin tailed) ( or from pg_

Re: [ADMIN] PG engine takeover or switch over

2007-08-16 Thread Chander Ganesan
Hannes Dorbath wrote: On 15.08.2007 21:30, Medi Montaseri wrote: I am looking for some suggestions to optimize the following problem/solution. Given two nodes A and B (two computers) in a active-passive mode where A is running PG engine, and B is simply standing by, and a common storage (t

Re: [ADMIN] PG engine takeover or switch over

2007-08-16 Thread Medi Montaseri
Thank you both for your input...this is indeed the type of analysis I was looking for. Now I have to read and understand them more carefully. At this point I wanted to thank you both and hopefully I can trouble you both with some follow ups in the future. Cheers Medi On 8/16/07, Chander Ganesan <

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