Re: [ADMIN] Getting master host info from a slave

2012-02-02 Thread Guillaume Lelarge
On Thu, 2012-02-02 at 15:40 +0100, Mario Splivalo wrote: > How can I get the master server host data from a running slave, without > reading recovery.conf file? > > I've tried with SHOW, but that just gives me: > > postgres=# show primary_conninfo; > ERROR: unrecognized configuration parameter "

Re: [ADMIN] ssl3 errors in replication.

2012-02-02 Thread Tom Lane
Mario Splivalo writes: > Reading the docs, it shouldn't use SSL when connecting. I think you're misreading the docs. There's nothing in your configuration that *forbids* an SSL connection, and libpq will try SSL first unless configured otherwise. Try adding sslmode=disable.

Re: [ADMIN] ssl3 errors in replication.

2012-02-02 Thread Mario Splivalo
On 02/02/2012 05:15 PM, Mario Splivalo wrote: > On 02/02/2012 05:16 PM, Tom Lane wrote: >> Mario Splivalo writes: >>> I have these errors in my log files, occurring very often: >>> 2012-02-02 01:05:53 CST [4103]: [2-1] user=,db= FATAL: could not >>> receive data from WAL stream: SSL error: sslv3

Re: [ADMIN] ssl3 errors in replication.

2012-02-02 Thread Mario Splivalo
On 02/02/2012 05:16 PM, Tom Lane wrote: > Mario Splivalo writes: >> I have these errors in my log files, occurring very often: >> 2012-02-02 01:05:53 CST [4103]: [2-1] user=,db= FATAL: could not >> receive data from WAL stream: SSL error: sslv3 alert unexpected message > > Google suggests that t

Re: [ADMIN] ssl3 errors in replication.

2012-02-02 Thread Tom Lane
Mario Splivalo writes: > I have these errors in my log files, occurring very often: > 2012-02-02 01:05:53 CST [4103]: [2-1] user=,db= FATAL: could not > receive data from WAL stream: SSL error: sslv3 alert unexpected message Google suggests that this might be caused by version or configuration m

[ADMIN] Getting master host info from a slave

2012-02-02 Thread Mario Splivalo
How can I get the master server host data from a running slave, without reading recovery.conf file? I've tried with SHOW, but that just gives me: postgres=# show primary_conninfo; ERROR: unrecognized configuration parameter "primary_conninfo" Mario -- Sent via pgsql-admin mailing list