Re: Installed. Now what?

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: pgbouncer-general(at)pgfoundry(dot)org, PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Installed. Now what?
Date: 2011-11-19 08:20:07
Message-ID: CAFWfU=sW8fP8RDOqeNWJ4egyHXe5TeBaBpnMEG5+ai=y-4EcqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 1. Do I need to set up the "/etc/pgbouncer.ini.rpmnew" as
> "/etc/pgbouncer.ini" and then change settings in it? What do I change?
> How? The FAQ is super geeky and unhelpful. As is the sparse info on
> the PG Wiki on pgbouncer. How can I tune pgbouner settings?

Just a quick update. By googling for an hour, I basically set up a
working ini file. It looks like this:

[pgbouncer]
logfile = /var/log/pgbouncer.log
pidfile = /var/run/pgbouncer/pgbouncer.pid
; ip address or * which means all ip-s
listen_addr = 127.0.0.1
listen_port = 6543
auth_type = trust
auth_file = /var/lib/pgsql/pgbouncer.txt

admin_users = postgres
stats_users = stats, root
pool_mode = session
server_reset_query = DISCARD ALL

;;; Connection limits
; total number of clients that can connect
max_client_conn = 100
default_pool_size = 20

So now pgbouncer basically starts. Both processes are running (psql
and pgbouncer) --

service postgres start
service pgbouncer start

When the two "services" are started like the above, are they working
together? The manual says psql should be restarted with the pgbouncer
port number, for these to be working together. But what if my server
does not have a "psql" process, but a service of postgres?

From within my PHP code, if I add the port number of pgbouncer in my
"pg_connect()" function, it does not work.

Thanks for any insight.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ashish Gupta 2011-11-19 09:44:37 Postgres 9.0.4 replication issue: FATAL: requested WAL segment 0000000100000B110000000D has already been removed
Previous Message Phoenix Kiula 2011-11-19 07:20:46 Installed. Now what?