> Not sure if I can do that when the master database is shut down Yes, In fact both server must be turned off for safety. > On 24 Jun 2015 6:36 pm, "Gilberto Castillo" <gilberto.castillo@xxxxxxxxx> > wrote: > >> > Hi, >> > >> > Yes we have failover. If after a few minutes the master database goes >> up >> > the replication works again which is fine. >> > >> > But I need something that deletes all records in the slave database >> > meanwhile master database is down. The reason is because we are >> sending >> > not >> > updated data when this happens and we prefer deleted what it is in the >> > slave database. >> >> Uhmmmm, use rsync of the folder wal in the master and slave. >> >> >> Saludos, Gilberto Castillo ETECSA, La Habana, Cuba -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin