Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

2012-10-08 Thread Marko Kreen
On Sat, Oct 6, 2012 at 5:24 AM, Adrian Klaver wrote: > One thing I see above: > http://pgbouncer.projects.postgresql.org/doc/config.html > ""\*" acts as fallback database" > > Notice the backslash. The backslash is asciidoc/docbook accident, it should be plain * there. -- marko -- Sent via p

Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

2012-10-08 Thread Marko Kreen
On Tue, Oct 2, 2012 at 12:27 PM, Phoenix Kiula wrote: > I get this error: > >psql: ERROR: No such user: MYSITE_MYSITE > > And yet, the authfile has this: > > "MYSITE_MYSITE" "" > "MYSITE_MYSITE" "" > "postgres" "" > "MYSITE_pgbouncer" "" Because of data sanitizing I cannot se

Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

2012-10-07 Thread Wolf Schwurack
, October 05, 2012 8:01 PM To: Wolf Schwurack Cc: raghu ram; pgbouncer-gene...@pgfoundry.org; PG-General Mailing List Subject: Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer On Sat, Oct 6, 2012 at 12:01 AM, Wolf Schwurack wrote: > You need to have a pgbouner directory in /var/

Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

2012-10-06 Thread Johnny Tan
Since it started happening after reboot, I wonder if it's selinux related. If you previously did "setenforce 0", that wouldn't persist across reboot. On Oct 5, 2012 10:01 PM, "Phoenix Kiula" wrote: > On Sat, Oct 6, 2012 at 12:01 AM, Wolf Schwurack wrote: > > > You need to have a pgbouner d

Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

2012-10-05 Thread Shashank Tripathi
On Sat, Oct 6, 2012 at 10:07 AM, Adrian Klaver wrote: > On 10/05/2012 07:00 PM, Phoenix Kiula wrote: >> >> On Sat, Oct 6, 2012 at 12:01 AM, Wolf Schwurack wrote: >> >>> >>> You need to have a pgbouner directory in /var/log and have the owner >>> pgbouncer. This is easy to test try creating a

Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

2012-10-05 Thread Adrian Klaver
On 10/05/2012 07:30 PM, Phoenix Kiula wrote: On Sat, Oct 6, 2012 at 10:24 AM, Adrian Klaver wrote: One thing I see above: http://pgbouncer.projects.postgresql.org/doc/config.html ""\*" acts as fallback database" Notice the backslash. Ok, but: (1) The exact same INI file was working so fa

Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

2012-10-05 Thread Phoenix Kiula
On Sat, Oct 6, 2012 at 10:24 AM, Adrian Klaver wrote: > > One thing I see above: > http://pgbouncer.projects.postgresql.org/doc/config.html > ""\*" acts as fallback database" > > Notice the backslash. > Ok, but: (1) The exact same INI file was working so far. (2) Why do I need a fallback datab

Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

2012-10-05 Thread Adrian Klaver
On 10/05/2012 07:23 PM, Phoenix Kiula wrote: On Sat, Oct 6, 2012 at 10:07 AM, Adrian Klaver wrote: ...snip... What are the contents of your pgbouncer.ini file? Thanks Adrian. I mentioned the full ini file details above in the thread, but here they are again. (Please do not comment abou

Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

2012-10-05 Thread Phoenix Kiula
On Sat, Oct 6, 2012 at 10:07 AM, Adrian Klaver wrote: ...snip... > What are the contents of your pgbouncer.ini file? >> Thanks Adrian. I mentioned the full ini file details above in the thread, but here they are again. (Please do not comment about port numbers. This is a public list so I cha

Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

2012-10-05 Thread Adrian Klaver
On 10/05/2012 07:00 PM, Phoenix Kiula wrote: On Sat, Oct 6, 2012 at 12:01 AM, Wolf Schwurack wrote: You need to have a pgbouner directory in /var/log and have the owner pgbouncer. This is easy to test try creating a file in /var/log as the user pgbouncer. It should fail because pgbouncer

Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

2012-10-05 Thread Phoenix Kiula
On Sat, Oct 6, 2012 at 12:01 AM, Wolf Schwurack wrote: > You need to have a pgbouner directory in /var/log and have the owner > pgbouncer. This is easy to test try creating a file in /var/log as the user > pgbouncer. It should fail because pgbouncer does not have writer permissions > to /v

Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

2012-10-05 Thread Wolf Schwurack
urack Cc: raghu ram; pgbouncer-gene...@pgfoundry.org; PG-General Mailing List Subject: Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer On Thu, Oct 4, 2012 at 2:50 AM, Wolf Schwurack wrote: > I use pgpool but some of the problem you listed are same as I had with > pgpool

Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

2012-10-05 Thread Phoenix Kiula
On Thu, Oct 4, 2012 at 2:50 AM, Wolf Schwurack wrote: > I use pgpool but some of the problem you listed are same as I had with pgpool Thanks Wolf, for the thoughts. > I would not run pgbouner in /var/run/pbbouner. Every time you reboot the > directory will get deleted. I set my parameter to an

Re: [Pgbouncer-general] [GENERAL] Again, problem with pgbouncer

2012-10-03 Thread Wolf Schwurack
NERAL] Again, problem with pgbouncer On Tue, Oct 2, 2012 at 5:27 PM, Phoenix Kiula wrote: > On Tue, Oct 2, 2012 at 11:29 AM, Phoenix Kiula > wrote: >> On Tue, Oct 2, 2012 at 12:59 AM, Phoenix Kiula >> wrote: >>>> Could you please check permission of /var/run/pgbou