From: | Petr Novak <petr(dot)novak23(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: CLOG read problem after pg_basebackup |
Date: | 2015-01-23 16:55:08 |
Message-ID: | CAB+GdvCa-8pr8ASz6XK418T_SanEBKk_BtCnVBF3gR_MQaCJww@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've checked wal_keep_segments before i've started the backup and the xlog
dir on the master contained logs from several hours ago. Which was
sufficient.
Also if this would be the case, then copying affected clog file from the
master wouldn't solve the problem as the requires wals would be still
missing..
P
On Jan 23, 2015 5:42 PM, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> wrote:
> On 01/23/2015 08:36 AM, Petr Novak wrote:
>
>> Just the config files for the replica, all other dirs were removed.
>>
>
> Alright, lets look at the other end. You are using -x which is:
>
> Using this option is equivalent of using -X with method fetch.
>
> and
>
> -X fetch is:
>
> f
> fetch
>
> The transaction log files are collected at the end of the backup.
> Therefore, it is necessary for the wal_keep_segments parameter to be set
> high enough that the log is not removed before the end of the backup. If
> the log has been rotated when it's time to transfer it, the backup will
> fail and be unusable.
>
>
> So are the three servers that failed pulling from parents that are seeing
> heavy use and do not have a sufficiently large wal_keep_segments set?
>
>
>> P
>>
>> On Jan 23, 2015 5:30 PM, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>>
>> On 01/23/2015 08:21 AM, Petr Novak wrote:
>>
>> Hi Adrian,
>>
>> sure the command is as follows:
>>
>> pg_basebackup -h <hostname> -p <port> -D /data2/pgsql/baseb -P -v
>> -U
>> replicator -x -c fast
>>
>> After that I moved the content of /data2/pgsql/baseb to actual
>> datadir
>> and tried to start up the cluster.
>>
>>
>> Where there left over files in actual datadir from initial cluster
>> init?
>>
>> On some servers it worked on the
>>
>> three didn't. The servers are of the same HW config and the
>> prerequisites are on all servers set by puppet.
>>
>> P
>>
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Christophe Pettus | 2015-01-23 17:32:54 | Re: In need of some JSONB examples ? |
Previous Message | Adrian Klaver | 2015-01-23 16:42:24 | Re: CLOG read problem after pg_basebackup |