Re: [GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-14 Thread Sameer Kumar
On Tue, 14 Apr 2015 11:59 Ilya Ashchepkov koc...@gmail.com wrote: On Mon, 13 Apr 2015 12:24:11 -0700 Adrian Klaver adrian.kla...@aklaver.com wrote: On 04/13/2015 11:25 AM, Ilya Ashchepkov wrote: On Mon, 13 Apr 2015 10:06:05 -0700 Adrian Klaver adrian.kla...@aklaver.com wrote: On

[GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-14 Thread Ilya Ashchepkov
On Mon, 13 Apr 2015 22:05:40 +0200 Guillaume Lelarge guilla...@lelarge.info wrote: Thank you! Le 12 avr. 2015 16:50, Ilya Ashchepkov koc...@gmail.com a écrit : Hello. I'm setting up hot standby slave. It recovers from wal archive files, but I can't connect to it: $ psql psql:

[GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-14 Thread Ilya Ashchepkov
On Tue, 14 Apr 2015 10:34:29 + Sameer Kumar sameer.ku...@ashnik.com wrote: Problem solved, thanks for attention. On Tue, 14 Apr 2015 11:59 Ilya Ashchepkov koc...@gmail.com wrote: On Mon, 13 Apr 2015 12:24:11 -0700 Adrian Klaver adrian.kla...@aklaver.com wrote: On 04/13/2015 11:25

[GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-14 Thread Ilya Ashchepkov
On Tue, 14 Apr 2015 07:08:50 -0700 Adrian Klaver adrian.kla...@aklaver.com wrote: On 04/13/2015 01:05 PM, Guillaume Lelarge wrote: Le 12 avr. 2015 16:50, Ilya Ashchepkov koc...@gmail.com mailto:koc...@gmail.com a écrit : restore_command = '/usr/lib/postgresql/9.3/bin/pg_standby -t

Re: [GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-13 Thread Adrian Klaver
On 04/13/2015 11:25 AM, Ilya Ashchepkov wrote: On Mon, 13 Apr 2015 10:06:05 -0700 Adrian Klaver adrian.kla...@aklaver.com wrote: On 04/13/2015 09:42 AM, Ilya Ashchepkov wrote: On Sun, 12 Apr 2015 17:30:44 -0700 Adrian Klaver adrian.kla...@aklaver.com wrote: If a connection is not

[GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-13 Thread Ilya Ashchepkov
On Mon, 13 Apr 2015 10:06:05 -0700 Adrian Klaver adrian.kla...@aklaver.com wrote: On 04/13/2015 09:42 AM, Ilya Ashchepkov wrote: On Sun, 12 Apr 2015 17:30:44 -0700 Adrian Klaver adrian.kla...@aklaver.com wrote: Oh! I missed this! Thank you! Now slave reached consistent state some

[GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-13 Thread Ilya Ashchepkov
On Mon, 13 Apr 2015 12:24:11 -0700 Adrian Klaver adrian.kla...@aklaver.com wrote: On 04/13/2015 11:25 AM, Ilya Ashchepkov wrote: On Mon, 13 Apr 2015 10:06:05 -0700 Adrian Klaver adrian.kla...@aklaver.com wrote: On 04/13/2015 09:42 AM, Ilya Ashchepkov wrote: On Sun, 12 Apr 2015 17:30:44

[GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-13 Thread Ilya Ashchepkov
On Sun, 12 Apr 2015 17:30:44 -0700 Adrian Klaver adrian.kla...@aklaver.com wrote: On 04/12/2015 08:25 AM, Ilya Ashchepkov wrote: On Sun, 12 Apr 2015 08:10:48 -0700 Adrian Klaver adrian.kla...@aklaver.com wrote: On 04/12/2015 07:47 AM, Ilya Ashchepkov wrote: Hello. I'm setting up

Re: [GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-13 Thread Adrian Klaver
On 04/13/2015 09:42 AM, Ilya Ashchepkov wrote: On Sun, 12 Apr 2015 17:30:44 -0700 Adrian Klaver adrian.kla...@aklaver.com wrote: Oh! I missed this! Thank you! Now slave reached consistent state some time after start, but still no connection to master server and still restoring wal-files.

Re: [GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-12 Thread Adrian Klaver
On 04/12/2015 08:25 AM, Ilya Ashchepkov wrote: On Sun, 12 Apr 2015 08:10:48 -0700 Adrian Klaver adrian.kla...@aklaver.com wrote: On 04/12/2015 07:47 AM, Ilya Ashchepkov wrote: Hello. I'm setting up hot standby slave. It recovers from wal archive files, but I can't connect to it: $ psql psql:

[GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-12 Thread Ilya Ashchepkov
On Sun, 12 Apr 2015 08:10:48 -0700 Adrian Klaver adrian.kla...@aklaver.com wrote: On 04/12/2015 07:47 AM, Ilya Ashchepkov wrote: Hello. I'm setting up hot standby slave. It recovers from wal archive files, but I can't connect to it: $ psql psql: FATAL: the database system is