Table of contents

Resync a PostgreSQL standby

To resync a standby from a primary run this on the affected standby:

sudo pg_resync_slave

You will see something like this:

vagrant@postgresql-standby-1:~$ sudo pg_resync_slave
36237/36237 kB (100%), 1/1 tablespace
pg_basebackup: base backup completed
 * Stopping PostgreSQL 9.3 database server                                 [ OK ]
 * Starting PostgreSQL 9.3 database server                                 [ OK ]
This page was last reviewed . It needs to be reviewed again by the page owner #2ndline.