Re: Can anyone help setting up pgbouncer? - Mailing list pgsql-general

From Nick
Subject Re: Can anyone help setting up pgbouncer?
Date
Msg-id 65b00549-2955-4f65-b6bc-ae9164eeb9a0@w19g2000pre.googlegroups.com
Whole thread Raw
In response to Can anyone help setting up pgbouncer?  (Nick <nboutelier@gmail.com>)
Responses Re: Can anyone help setting up pgbouncer?  (Rikard Bosnjakovic <rikard.bosnjakovic@gmail.com>)
List pgsql-general
Here's my output. Is it a permission error writing to etc?

$ strace -f -e open pgbouncer -v pgbouncer.ini
open("/etc/ld.so.cache", O_RDONLY)      = 3
open("/usr/local/lib/libevent-1.4.so.2", O_RDONLY) = 3
open("/lib/libcrypt.so.1", O_RDONLY)    = 3
open("/lib/libc.so.6", O_RDONLY)        = 3
open("/lib/libnsl.so.1", O_RDONLY)      = 3
open("/lib/librt.so.1", O_RDONLY)       = 3
open("/lib/libresolv.so.2", O_RDONLY)   = 3
open("/lib/libpthread.so.0", O_RDONLY)  = 3
open("pgbouncer.ini", O_RDONLY|O_LARGEFILE) = 3
open("/etc/localtime", O_RDONLY)        = 3
2009-11-17 03:10:28.852 24132 ERROR unconfigured_file: No such file or
directory
2009-11-17 03:10:28.852 24132 LOG File descriptor limit: 1024 (H:
1024), max_client_conn: 100, max fds possible: 110
2009-11-17 03:10:28.859 24132 LOG listening on unix:/tmp/.s.PGSQL.6432
2009-11-17 03:10:29.193 24132 ERROR unconfigured_file: No such file or
directory
2009-11-17 03:10:29.528 24132 ERROR unconfigured_file: No such file or
directory
2009-11-17 03:10:29.863 24132 ERROR unconfigured_file: No such file or
directory


On Nov 14, 12:02 am, rikard.bosnjako...@gmail.com (Rikard Bosnjakovic)
wrote:
> On Sat, Nov 14, 2009 at 00:17, Nick <nboutel...@gmail.com> wrote:
> > Thanks Richard, I updated my users.txt file to include quotes (it
> > didn't) which fixed the broken auth file error, but now im getting
> > this...
>
> > 1518 ERROR unconfigured_file: No such file or directory
>
> [...]
>
> If you are on a system with strace, try this:
>
> $ strace -f -e open pgbouncer -v pgbouncer.ini
>
> This way, you will see what file pgbouncer tries to open (and fails on).
>
> --
> - Rikard
>
> --
> Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general


pgsql-general by date:

Previous
From: Adam Rich
Date:
Subject: Re: calling a function over several rows
Next
From: Rikard Bosnjakovic
Date:
Subject: Re: Can anyone help setting up pgbouncer?