Postgres Pro
Downloads
Home   >   mailing lists

Re: Re-sync slave server - Mailing list pgsql-general

From Patrick B
Subject Re: Re-sync slave server
Date
Msg-id CAJNY3itvKjEUD2iPLMb1g5nrNp2cUYPy95f+ORQUZ5RPfx-SSw@mail.gmail.com
Whole thread Raw
In response to Re: Re-sync slave server  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Re-sync slave server  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Re-sync slave server  (bricklen <bricklen@gmail.com>)
List pgsql-general
Tree view
My set up:


Master --> slave01 (streaming replication) --> slave02 (streaming replication)
Master --> slave03 (wal_files 4 days old, not streaming replication)

The wal_files are stored into each server.
But when the slave03 was down, the wal_files weren't being copied into it. We took too long to discover that, and now we lost some wal_files.. they've been recycled...

So my question is:

Can I just do a RE-SYNC from slave01 to slave03 of the data folder?
Or do I have to sync all the database again?

I'm asking because the DB is 2.2TB, don't wanna do one step and discover later that did not work and have to do all over again

Cheers
Patrick

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Re-sync slave server
Next
From: John R Pierce
Date:
Subject: Re: Postgres Dropped DB have recovered files how to restore