chinnaobi wrote: >> When the standby is promoted, it starts a new time line, so it >> is on a different time line from the old master. The old >> primary cannot be turned to a standby without a new base backup >> (possibly via rsync to speed up things). > But taking 200 GB to 500 GB DB base backup is impossible for me. Is there > any other solution ?? But you must take backups anyway, right? Using rsync should make the backup much faster if nothing much has happened since failover. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general