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
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
, 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/
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
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
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
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
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
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
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
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
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
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
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
Hi,
Do you have "MYSITE_MYSITE" user at your database.
Please login to the database directly (I mean, without any pgbouncer and
check once.
select* from pg_user where usename ~~* 'MYSITE_MYSITE'; And also please
check your's pgbouncer.ini admin users list also.
Best Regards,
Dinesh
manojadinesh
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/pgbouncer/ directory. If
pgbouncer directory does not have "postgre
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/pgbouncer/ directory. If
>>> pgbouncer directory does not have "postgres" user permissions,please assign
>>> it and then start the pgb
On Tue, Oct 2, 2012 at 12:59 AM, Phoenix Kiula wrote:
>> Could you please check permission of /var/run/pgbouncer/ directory. If
>> pgbouncer directory does not have "postgres" user permissions,please assign
>> it and then start the pgbouncer.
>
>
> The /var/run/pgbouncer/ directory has
>
>chow
> Could you please check permission of /var/run/pgbouncer/ directory. If
> pgbouncer directory does not have "postgres" user permissions,please assign
> it and then start the pgbouncer.
The /var/run/pgbouncer/ directory has
chown -R postgres:postgres ..
The port number everywhere is already
On Mon, Oct 1, 2012 at 3:56 PM, Phoenix Kiula wrote:
> Hi,
>
> - PG 9.0.10
> - Pgbouncer version 1.4.2
>
> Not long ago, during the last server reboot for us, we had fixed the
> really painful (and largely mysterious) process of setting up
> pgbouncer.
>
> File permissions and other mysteries
Hi,
- PG 9.0.10
- Pgbouncer version 1.4.2
Not long ago, during the last server reboot for us, we had fixed the
really painful (and largely mysterious) process of setting up
pgbouncer.
File permissions and other mysteries were solved with help from Raghavendra:
http://permalink.gmane.org/gman
21 matches
Mail list logo
