Dragos Valentin Moinescu <dragos.moinescu@xxxxxxxxx> wrote: > I succeded in creating a warm standby server: > > [custom scripting] That's gotta be nicer than what you were doing before. :-) That said, I fear there are a few unusual conditions you are not handling in your script. You might want to take a look at some packaged solutions which deal with these gracefully. pg_standby and pitrtools come to mind, although I might be forgetting something. In the meantime, keep an eye on the log files from both the source and standby databases to make sure transactions are flowing. You might also want to run pg_controldata and make sure that "Database cluster state" is "in archive recovery" and "Time of latest checkpoint" hasn't gotten too stale. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
