Re: [GENERAL] [Pgbouncer-general] PGBouncer help (how to get it working)

2012-04-14 Thread Clodoaldo Neto
Em 12 de abril de 2012 14:12, Phoenix Kiula phoenix.ki...@gmail.comescreveu: I had pgbouncer working somehow, but we have switched servers recently and now I cannot for the life of me figure out again how to set it up. Online guides say things like create a user ID. Well, where? Inside PG

Re: [GENERAL] [Pgbouncer-general] PGBouncer help (how to get it working)

2012-04-14 Thread raghu ram
On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto clodoaldo.pinto.n...@gmail.com wrote: Em 12 de abril de 2012 14:12, Phoenix Kiula phoenix.ki...@gmail.comescreveu: I had pgbouncer working somehow, but we have switched servers recently and now I cannot for the life of me figure out again how

Re: [GENERAL] [Pgbouncer-general] PGBouncer help (how to get it working)

2012-04-14 Thread Clodoaldo Neto
Em 14 de abril de 2012 09:39, raghu ram raghuchenn...@gmail.com escreveu: On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto clodoaldo.pinto.n...@gmail.com wrote: Em 12 de abril de 2012 14:12, Phoenix Kiula phoenix.ki...@gmail.comescreveu: I had pgbouncer working somehow, but we have

Re: [GENERAL] [Pgbouncer-general] PGBouncer help (how to get it working)

2012-04-14 Thread raghu ram
On Sat, Apr 14, 2012 at 6:35 PM, Clodoaldo Neto clodoaldo.pinto.n...@gmail.com wrote: Em 14 de abril de 2012 09:39, raghu ram raghuchenn...@gmail.comescreveu: On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto clodoaldo.pinto.n...@gmail.com wrote: Em 12 de abril de 2012 14:12, Phoenix

Re: [GENERAL] PGBouncer help (how to get it working)

2012-04-13 Thread Raghavendra
On Fri, Apr 13, 2012 at 11:00 AM, Phoenix Kiula phoenix.ki...@gmail.comwrote: On Fri, Apr 13, 2012 at 2:41 AM, Scott Marlowe scott.marl...@gmail.com wrote: On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula phoenix.ki...@gmail.com wrote: WARNING: password file /root/.pgpass has group

Re: [GENERAL] PGBouncer help (how to get it working)

2012-04-13 Thread Phoenix Kiula
On Fri, Apr 13, 2012 at 2:59 PM, Raghavendra raghavendra@enterprisedb.com wrote: . Add it in pgbouncer.auth file as per your .ini file parameter.    auth_file = /var/lib/pgsql/pgbouncer.txt Seems you already did this. I believe you are connecting as postgres user not from

[GENERAL] PGBouncer help (how to get it working)

2012-04-12 Thread Phoenix Kiula
I had pgbouncer working somehow, but we have switched servers recently and now I cannot for the life of me figure out again how to set it up. Online guides say things like create a user ID. Well, where? Inside PG the database? Or in my CentOS system? Here's my /etc/pgbouncer.ini:

Re: [GENERAL] PGBouncer help (how to get it working)

2012-04-12 Thread Scott Marlowe
On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula phoenix.ki...@gmail.com wrote:   WARNING: password file /root/.pgpass has group or world access;   permissions should be u=rw (0600) or less   psql: ERROR:  No such user: MYSITE_pgbouncer Pretty sure the error is just the perms on that file.

Re: [GENERAL] PGBouncer help (how to get it working)

2012-04-12 Thread Phoenix Kiula
On Fri, Apr 13, 2012 at 2:41 AM, Scott Marlowe scott.marl...@gmail.com wrote: On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula phoenix.ki...@gmail.com wrote:   WARNING: password file /root/.pgpass has group or world access;   permissions should be u=rw (0600) or less   psql: ERROR:  No such

Re: [GENERAL] PGBouncer help (how to get it working)

2012-04-12 Thread Raghavendra
On Fri, Apr 13, 2012 at 11:00 AM, Phoenix Kiula phoenix.ki...@gmail.comwrote: On Fri, Apr 13, 2012 at 2:41 AM, Scott Marlowe scott.marl...@gmail.com wrote: On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula phoenix.ki...@gmail.com wrote: WARNING: password file /root/.pgpass has group or