Re: Re-sync slave server

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Patrick B <patrickbakerbr(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Re-sync slave server
Date: 2016-06-07 00:25:25
Message-ID: 7d66ef4f-f03a-60f3-e928-f895e868c7ab@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 06/06/2016 05:11 PM, Patrick B wrote:
> Hi guys,
>
> I'm using PostgreSQL 9.2
>
> There is a backup server that is 4 days old replication by wal_files
> (not streaming)
>
> However, the server went down and I lost some wal_files.. and now the
> replication is not working...

What is your set up?:

standby server
master --> | WAL archive --> standby_cluster

OR

wal storage standby server
master --> | WAL archive | --> standby

In other words where did you lose the WAL files?

More to the point are they still on the master or have they already been
recycled?

>
> Question:
>
> Do I need to sync all the data folder from my master....
>
> Or just doing an incremental rsync would work?
>
> Thanks
> Patrick

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick B 2016-06-07 00:32:13 Re: Re-sync slave server
Previous Message Patrick B 2016-06-07 00:11:56 Re-sync slave server