unfortunately i cannot try the restart with -R either but i ll check the
source code.
thank you all
--
View this message in context:
http://postgresql.nabble.com/pgbouncer-increase-pool-size-reload-does-not-work-tp5942273p5942711.html
Sent from the PostgreSQL - general mailing list archive at
On Thu, 2 Feb 2017 16:12:06 -0800
Adrian Klaver wrote:
> On 02/02/2017 03:27 AM, alexanderfelipewo wrote:
> > hello!
> >
> > i have a question for pgbouncer in case someone has faced this and there is
> > a solution available.
> >
> > i have a db with pgbouncer where the pool_size is set to 50 (i
On 02/02/2017 03:27 AM, alexanderfelipewo wrote:
hello!
i have a question for pgbouncer in case someone has faced this and there is
a solution available.
i have a db with pgbouncer where the pool_size is set to 50 (i ve noticed
this using both session/transaction modes). Sometimes there are wai
On Thu, 2 Feb 2017 04:27:45 -0700 (MST)
alexanderfelipewo wrote:
> hello!
>
> i have a question for pgbouncer in case someone has faced this and there is
> a solution available.
>
> i have a db with pgbouncer where the pool_size is set to 50 (i ve noticed
> this using both session/transaction m
On 30/11/15 22:50, Steve Crawford wrote:
> Do you have any clients connected that are idle in transaction?
No, the backend database is a streaming replica. Also, as I said, the
backend process is in "idle" state not "idle in transaction".
backend_start| 2015-11-30 18:58:30.639962+00
xact_star
Do you have any clients connected that are idle in transaction?
Cheers,
Steve
On Mon, Nov 30, 2015 at 1:46 PM, Torsten Förtsch
wrote:
> Hi,
>
> I am not sure if this is the right place to ask this question. If not,
> please point me to it.
>
> I am trying out the new pgbouncer (latest git). "SH
Cursory observations below...
On Mon, Jul 6, 2015 at 11:04 AM, Ali Aktar wrote:
> Hi Guys;
>
> Can I please get some assistance:
>
> I have postgres server running on the localhost:
> -bash-4.2$ telnet localhost 5432
> Trying ::1...
> Connected to localhost.
> Escape character is '^]'.
>
> -bash
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ali Aktar
Sent: Monday, July 06, 2015 11:04 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] PgBouncer error - psql: could not connect to server: No such
file or directory Is the server runni
Hi,
I'd like to add to my former mail that currently I have got pgbouncer
running and I can connect to the underlying postgres database servers, but
how can I access the pgbouncer database when I'm not running a postgres
server on the VM where the pgbouncer is installed? In all the forums and
docum
Hi,
thanks, you're right. My description wasn't very concrete. Our current set
up is a single pgbouncer instance running on a VM in the same network like
the webapplications. The database servers are in another firewall protected
network. So the pgbouncer is now running on a standalone VM. I was
w
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I'd like to use pgbouncer as connection pooler in our productive
> environment, which consists of six master db server plus 6 slaves and many
> webserver and services. For example, I'd like to use it as a central point
> from where I can redir
I have played around with it a bit more, it seems adding the pre-start
section works:
pre-start script
if [ -d /var/run/postgresql ]; then
chmod 2775 /var/run/postgresql
else
install -d -m 2775 -o postgres -g postgres /var/run/postgresql
fi
end script
Thanks Adrian!
On 07/28/2014 09:33 PM, Tobias Fielitz wrote:
Hi,
I am trying to start pgbouncer via upstart script. The upstart logs
(/var/log/upstart/pgbouncer.log) tell me:
/var/run/postgresql/pgbouncer.pid: No such file or directory [2]
but when starting pgbouncer from the console with:
> sudo service pg
-general@postgresql.org
Subject: Re: [GENERAL] Pgbouncer help
On 08/27/2013 10:40 AM, Jeff Janes wrote:
> On Tue, Aug 27, 2013 at 1:34 AM, Yelai, Ramkumar IN BLR STS
> wrote:
>> HI
>>
>>
>>
>> In our current project, we are opening several postgresql connection.
&g
---
From: Jeff Janes [mailto:jeff.ja...@gmail.com]
Sent: Tuesday, August 27, 2013 11:10 PM
To: Yelai, Ramkumar IN BLR STS
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pgbouncer help
On Tue, Aug 27, 2013 at 1:34 AM, Yelai, Ramkumar IN BLR STS
wrote:
> HI
>
>
>
> In our current project
On 08/27/2013 10:40 AM, Jeff Janes wrote:
On Tue, Aug 27, 2013 at 1:34 AM, Yelai, Ramkumar IN BLR STS
wrote:
HI
In our current project, we are opening several postgresql connection. Few
connections are frequently used and few are occasionally used. Hence we plan
to adapt connection pool meth
On Tue, Aug 27, 2013 at 1:34 AM, Yelai, Ramkumar IN BLR STS
wrote:
> HI
>
>
>
> In our current project, we are opening several postgresql connection. Few
> connections are frequently used and few are occasionally used. Hence we plan
> to adapt connection pool method to avoid more connection to ope
On Mon, Feb 18, 2013 at 3:59 PM, komunca wrote:
> Just to say it in another way: Is there a way to dynamically add database to
> PgBouncer
Yes it is possible to do. You need to add the following to the
[databases] section in your pgbouncer config file.
* = host=localhost
>From the pgbouncer doc
On Thu, Feb 14, 2013 at 9:09 AM, François Beausoleil
wrote:
> I believe the important user is the one pgbouncer uses to connect to the real
> PostgreSQL server. That user + dbname is what creates a new pool. The
> client's name (the one the app connects as) is irrelevant since I hard-code
> wha
On Tue, Aug 28, 2012 at 8:33 AM, prashantbharucha
wrote:
> Hi Craig
>
> I got connection to pgbouncer,but how do i pass actual database parameter
> to connect .
>
> I attached my perl script and getting error : prepared statement
> "dbdpg_p27841_1"
That doesn't look like a complete error message
Hi Craig
I got connection to pgbouncer,but how do i pass actual database parameter
to connect .
I attached my perl script and getting error : prepared statement
"dbdpg_p27841_1"
Thanks
my $PGDBNAME = 'test';
my $PGDBSERVER = '172.16.40.19';
my $PGDBUSER = 'postgres';
my $PGDBPASSWD = 'post
Prashant --
I haven't tried this -- we don't use DBI currently -- but wouldn't it get
treated as any other connection if you point the DBI connection to the
pgbouncer host / port / database ? pgbouncer should redirect the query
according the rules in its .ini file.
HTH,
Greg Williamson
>_
On 08/27/2012 09:51 AM, Prashant Bharucha wrote:
Hello ,
Could you please tell me some one ,how to do connection PGBouncer using
Perl DBI module ?
Exactly the same way you connect to PostgreSQL normally: specify a
hostname, port and database name. Instead of specifying those for the
PostgreSQ
On Sat, Apr 14, 2012 at 6:35 PM, Clodoaldo Neto <
clodoaldo.pinto.n...@gmail.com> wrote:
> Em 14 de abril de 2012 09:39, raghu ram escreveu:
>
>>
>>
>> On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto <
>> clodoaldo.pinto.n...@gmail.com> wrote:
>>
>>> Em 12 de abril de 2012 14:12, Phoenix Kiula
>>
Em 14 de abril de 2012 09:39, raghu ram escreveu:
>
>
> On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto <
> clodoaldo.pinto.n...@gmail.com> wrote:
>
>> Em 12 de abril de 2012 14:12, Phoenix Kiula
>> escreveu:
>>
>>> I had pgbouncer working somehow, but we have switched servers recently
>>> and n
On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto <
clodoaldo.pinto.n...@gmail.com> wrote:
> Em 12 de abril de 2012 14:12, Phoenix Kiula escreveu:
>
>> I had pgbouncer working somehow, but we have switched servers recently
>> and now I cannot for the life of me figure out again how to set it up.
>>
Em 12 de abril de 2012 14:12, Phoenix Kiula escreveu:
> I had pgbouncer working somehow, but we have switched servers recently
> and now I cannot for the life of me figure out again how to set it up.
>
> Online guides say things like "create a user ID". Well, where? Inside
> PG the database? Or i
On Fri, Apr 13, 2012 at 2:59 PM, Raghavendra
wrote:
.
>> Add it in pgbouncer.auth file as per your .ini file parameter.
>>
>> auth_file = /var/lib/pgsql/pgbouncer.txt
>>
>
> Seems you already did this. I believe you are connecting as postgres user
> not from root, if yes, then check .
>
> On Fri, Apr 13, 2012 at 11:00 AM, Phoenix Kiula
> wrote:
>
>> On Fri, Apr 13, 2012 at 2:41 AM, Scott Marlowe
>> wrote:
>> > On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula <
>> phoenix.ki...@gmail.com> wrote:
>> >>
>> >> WARNING: password file "/root/.pgpass" has group or world access;
>> >
On Fri, Apr 13, 2012 at 11:00 AM, Phoenix Kiula wrote:
> On Fri, Apr 13, 2012 at 2:41 AM, Scott Marlowe
> wrote:
> > On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula
> wrote:
> >>
> >> WARNING: password file "/root/.pgpass" has group or world access;
> >> permissions should be u=rw (0600) or
On Fri, Apr 13, 2012 at 2:41 AM, Scott Marlowe wrote:
> On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula
> wrote:
>>
>> WARNING: password file "/root/.pgpass" has group or world access;
>> permissions should be u=rw (0600) or less
>> psql: ERROR: No such user: MYSITE_pgbouncer
>
> Pretty s
On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula wrote:
>
> WARNING: password file "/root/.pgpass" has group or world access;
> permissions should be u=rw (0600) or less
> psql: ERROR: No such user: MYSITE_pgbouncer
Pretty sure the error is just the perms on that file. Set them to
0600 and
Hi.
John-san, thanks!
to Edison-san.
It is necessary to perform it in an administrator's mode.
Please see,
http://winpg.jp/~saito/pgbouncer/try_64bit/regsvr32_pgevent.png
http://winpg.jp/~saito/pgbouncer/try_64bit/running_pgbouncer.png
Regards,
Hiroshi Saito
(2012/01/23 10:09), John R Pierce
On 01/22/12 4:55 PM, Edison So wrote:
I downloaded the 64-bit version and extracted it. Unfortunately. it
seems that the pbbouncer.exe file is needed to be rebulit (ie.
recompiled) according to the following statements from the README file:
those statements you reference may well be from the
Thank you for the reply.
I downloaded the 64-bit version and extracted it. Unfortunately. it seems
that the pbbouncer.exe file is needed to be rebulit (ie. recompiled)
according to the following statements from the README file:
-
Building for WIN32
http://winpg.jp/~saito/pgbouncer/
On Fri, Jan 20, 2012 at 11:01 PM, Edison So wrote:
> Hello,
>
> Can anyone please tell me where I can find the PGbouncer executable and
> tutorial for Windows 2008? I found one but need to recompile on Windows. I
> also need intuitive instructions to configure i
Mario Ignacio Rodríguez Cortés writes:
> Well, i have a question if you know about this, i have a webserver in a
> server and i have a database server, the question is: where should I
> install the pgbouncer? in webserver, in database server or is the same?
> whats your experience.
I always insta
On Thu, Jun 3, 2010 at 4:03 PM, Merlin Moncure wrote:
> I'm interested in this too...does anyone else have experience in this matter?
>
I've pondered this many times. My questions are what failure mode are
you looking to avoid, especially if you're using pgbouncer for load
balance in addition to
On Thu, Jun 3, 2010 at 12:40 PM, Mario Ignacio Rodríguez Cortés
wrote:
> hello all:
>
> Well, i have a question if you know about this, i have a webserver in a
> server and i have a database server, the question is: where should I
> install the pgbouncer? in webserver, in database server or is the
On 06/03/2010 10:05 AM, Mario Rodriguez wrote:
Well, i have a question if you know about this, i have a webserver in a
server and i have a database server, the question is: where should I
install the pgbouncer? in webserver, in database server or is the same?
what's your experience.
I haven't ha
40 matches
Mail list logo
