-- OK, but this is not a showstopper here. Right? Your right - just a thought -- What settings do I need to give "/var/log" (currently root) so the pgbouncer process can write to it? Why are these special permissions needed 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 /var/log. As root create a directory /var/log/pgbouncer, change owner to pgbouncer. Set your parameter for pgbouncer.log to /var/log/pgbouncer. Then test by creating a file in /var/log/pgbouncer as user pgbouncer If the user exists in the postgres then I'm not sure why it fails. Wolf -----Original Message----- From: Phoenix Kiula [mailto:phoenix.kiula@xxxxxxxxx] Sent: Friday, October 05, 2012 9:37 AM To: Wolf Schwurack Cc: raghu ram; pgbouncer-general@xxxxxxxxxxxxx; PG-General Mailing List Subject: Re: [Pgbouncer-general] Again, problem with pgbouncer On Thu, Oct 4, 2012 at 2:50 AM, Wolf Schwurack <wolf@xxxxxxx> 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 another > directory the would not get deleted after a reboot. OK, but this is not a showstopper here. Right? > /var/log/pgbouncer.log: > what is the permission on /var/log? If you don't have write permission on the directory then you cannot write to the file. Permissions: /var/run/pgbouncer -- 70058074 drwxr-xr-x 2 pgbouncer postgres 4.0K Oct 2 06:17 pgbouncer/ /var/log -- 145686529 drwxr-xr-x 17 root root 4.0K Oct 5 04:29 log/ Please note that whatever the settings, they were working before a server reboot. What settings do I need to give "/var/log" (currently root) so the pgbouncer process can write to it? Why are these special permissions needed-- I mean Apache, MysQL, Nginx etc...all of them can write to the logs in this log folder. > Psql: ERROR: No such user: > You have to create the user in postgres, check you users > > postgres=# /du > Yes, this user exists in the postgres database. List of roles Role name | Attributes | Member of -----------------+-----------------------------------+----------- postgres | Superuser, Create role, Create DB | {} rvadmin | | {} MYSITE | | {} MYSITE_MYSITE | Superuser, Create DB | {} And the authfile also has permissions for "pgbouncer:postgres". What else? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
