Postgres Pro
Downloads
Home   >   mailing lists

Re: Installed. Now what? - Mailing list pgsql-general

From Amitabh Kant
Subject Re: Installed. Now what?
Date
Msg-id CAPTAQBLn9_67VL1GqKVaYt5LMzdAsRx-7-VyZoMJVoorufpTxw@mail.gmail.com
Whole thread Raw
In response to Re: Installed. Now what?  (Phoenix Kiula <phoenix.kiula@gmail.com>)
Responses Re: Installed. Now what?  (Phoenix Kiula <phoenix.kiula@gmail.com>)
Re: Installed. Now what?  (Tomas Vondra <tv@fuzzy.cz>)
List pgsql-general
Tree view
On Sun, Nov 20, 2011 at 4:14 AM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
On Sun, Nov 20, 2011 at 3:35 AM, Adrian Klaver <adrian.klaver@gmail.com> wrote:<snip>

[databases]
MYDB  = host=127.0.0.1 dbname=MYDB user=MYUSER client_encoding=utf8 port=5432

;; Configuation section
[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 = 1500
default_pool_size = 50


I am assuming the difference in the port numbers between your config file and php code is a typing error. 

Does the auth file (/var/lib/pgsql/pgbouncer.txt) contain valid login credentials to your database? If I remember correctly, it should have the username and password to your database.

Amitabh
 

pgsql-general by date:

Previous
From: Phoenix Kiula
Date:
Subject: Re: Logging not working
Next
From: Phoenix Kiula
Date:
Subject: Re: Installed. Now what?