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
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 waiting
sessions b/c more than 50 want to execute sth
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
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). "SHOW SERVERS" is
telling me 2 connections in "active" state. Both show
connect_time=2015-11-30 18:58:30. Request_time is 19:01:35 and 20:56:36.
Both u
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
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-4.2$ psql -U postgres
psql (9.4.4)
Type "help" for help.
postgres=# \list
Hi All,
I wanted to compile pgbouncer in Visual studio 2013-64bit.
I have not found any help in forums. Also, pgbouncer source file mentioned
that, it is not tested in Visual studio.
Please let me know, is it possible to compile in VS2013 and works fine?
With best regards,
Ramkumar Yelai
Si
Guys can anyone please explain or point me to a link where i can understand
this output for pgbouncer. What does each column of this table mean?
pgbouncer=# show mem;
name | size | used | free | memtotal
--+--+--+--+--
user_cache | 184 | 12 | 77
Guys
I have an issue going on with PGBOUNCER which is slowing down the site
PGBOUNCER VERSION: pgbouncer-1.5.4-2.el6 (Hosted on separate machine) (16 cpu)
98GB RAM
DATABASE VERION: postgresql 9.3
When the total client connections to pgbouncer are close to 1000, site
applicatio
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
Hi,
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 redirect client connections easily without changing the
code o
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
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 pgbouncer start
it works fine and the pidfile i
-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
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 open. We plan to use
"Pgbouncer". Most of the pgbouncer example shows how to
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
Is it possible to use PgBouncer in this scenario:
User comes to my WA, and opens new account. In that case I create a new
database for that user.
I noticed that in PgBouncer config file I have to set a database line, so
I'm confused Is there any way to deal with this problem?
Just to say it in
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
Hello all,
>From reading the PGbouncer configuration man page, PGbouncer creates a new
>pool on every DB + user pair. If I have two types of queries, long-lived batch
>reporting and fast PK lookups, then I should favor two pools. Both pools can
>hit the same database server.
I can configure pg
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
Greg Williamson
>
> From: Prashant Bharucha
>To: pgsql-general@postgresql.org
>Sent: Sunday, August 26, 2012 6:51 PM
>Subject: [GENERAL] PGBouncer Connection Using Perl DBI
>
>
>Hello ,
>
>Could you please tell me some one ,how to do
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
Hello ,
Could you please tell me some one ,how to do connection PGBouncer using Perl
DBI module ?
Thanks
Prashant
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
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 in my CentOS system?
Here's my "/etc/pgbouncer.ini":
[datab
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
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 it too.
Thanks in advance.
--
Edison
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
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 same?
whats your experience.
Thanks.
ISC: Mario Ignacio Rodríguez Cortés.
--
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
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 same?
what's your experience.
Thanks.
ISC: Mario Ignacio Rodríguez Cortés.
I have pgbouncer running fine, but was wondering: I don't see any way to get
a report of the max # of connections actually used at once? I'm pretty sure
that I currently never come close to maxing out my pool, but for planning
purposes I'd like know what the actual peak is. Did I miss something eas
57 matches
Mail list logo
