From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Ilya Ashchepkov <koctep(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Re: Hot standby problems: consistent state not reached, no connection to master server. |
Date: | 2015-04-13 17:06:05 |
Message-ID: | 552BF77D.2000601@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 04/13/2015 09:42 AM, Ilya Ashchepkov wrote:
> On Sun, 12 Apr 2015 17:30:44 -0700
> Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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.
>>
>> Not quite sure what you are getting at.
>>
>> You are not seeing the streaming connection happening?
>
> Yes, no streaming connection.
>
>> If a connection is not being made:
>>
>> 1) Dose user replication have REPLICATION rights?
>> 2) Is the pg_hba.conf on the master set up to allow a connection from
>> the standby for user replication and database replication?
>
> I commented 'restore_command' in recovery.conf and after start slave
> connected to master.
> Then I uncomment it back. Is it possible to have a both, streaming
> connection and restoring from wal files from NFS share?
Yes:
http://www.postgresql.org/docs/9.3/interactive/warm-standby.html#STREAMING-REPLICATION
I wonder if your master is recycling WALs fast enough that the streaming
can't find them and the standby has to go to the archive instead.
What is your wal_keep_segments on the master set to?:
>
>>
>> Where are the WAL files coming from?
>
> NFS share on master.
>
>>
>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>
>
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis Jenkins | 2015-04-13 17:16:31 | Re: PG-9.3.6, unable to "drop role because some objects depend on it" |
Previous Message | Dennis Jenkins | 2015-04-13 17:05:40 | PG-9.3.6, unable to "drop role because some objects depend on it" |