Re: [Pgpool-general] Trouble with pgpool installation

2011-06-08 Thread Tatsuo Ishii
> I've used Postgres for several years now, and I am just starting to > play with pgpool. For my test configuration we have two servers: > > srvh016 - pgpool, postgres node, and pgpool system_db > srvh035 - Postgres node > > I've followed the tutorial here: > http://pgpool.projects.postgresql.or

Re: [Pgpool-general] Trouble with pgpool installation

2011-06-09 Thread Paul Giblock
Tatsuo, Thanks for the response. > pg_last_xlog_receive_location only returns meaningfull result on > standby. You should connect directly to standby and issue the > query. Even if you do that, I suspect you will get NULL since pgpool > log says however. > >> ERROR: pid 8733: check_replication_ti

Re: [Pgpool-general] Trouble with pgpool installation

2011-06-09 Thread Paul Giblock
Possibly related, I'm also receiving this "DEBUG" message, so it may be a concern: pool_ssl: SSL requested but SSL support is not available I did some research on it and it appears that pgpool is trying SSL for authentication and trusted auth is required. However on all my database servers I hav

Re: [Pgpool-general] Trouble with pgpool installation

2011-06-10 Thread Paul Giblock
Any help with this? Paul On Thu, Jun 9, 2011 at 9:52 AM, Paul Giblock wrote: > Tatsuo, > > Thanks for the response. > >> pg_last_xlog_receive_location only returns meaningfull result on >> standby. You should connect directly to standby and issue the >> query. Even if you do that, I suspect you

Re: [Pgpool-general] Trouble with pgpool installation

2011-06-10 Thread Guillaume Lelarge
On Fri, 2011-06-10 at 12:52 -0400, Paul Giblock wrote: > Any help with this? > Before putting pgpool in the middle of this, did you install master and slave as recommended on http://www.postgresql.org/docs/9.0/interactive/warm-standby.html ? -- Guillaume http://blog.guillaume.lelarge.info