Re: Can anyone help setting up pgbouncer?

From: Nick <nboutelier(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Can anyone help setting up pgbouncer?
Date: 2009-11-17 08:13:57
Message-ID: 65b00549-2955-4f65-b6bc-ae9164eeb9a0@w19g2000pre.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)bosnjako(dot)(dot)(dot)(at)gmail(dot)com (Rikard Bosnjakovic)
wrote:
> On Sat, Nov 14, 2009 at 00:17, Nick <nboutel(dot)(dot)(dot)(at)gmail(dot)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(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rikard Bosnjakovic 2009-11-17 09:36:05 Re: Can anyone help setting up pgbouncer?
Previous Message Adam Rich 2009-11-17 06:35:01 Re: calling a function over several rows