Re: WAL Log Shipping - Warm Standby not working under 8.3.7

To clean up from a prior run.

Erik Jones <ejones(at)engineyard(dot)com> wrote:

On Jan 8, 2010, at 9:50 AM, Keaton Adams wrote:

> OK,
>
> So what am I doing wrong here?
>
> Installed PG 8.3.7 on Slave machine
>
> Restored from last evening's backup from the master DB to make the rsync across the network finish sooner.
>
> Shut down the PG instance on the slave machine
>
> Ran a script that does the following:
>
> select pg_start_backup('Master_Backup');
> rsync -rvlpogtz ${masterdb}/* ${slave_dbuser}(at)${slave_host}:${slavedb}
> select pg_stop_backup();
> ssh ${slave_dbuser}(at)${slave_host} rm ${slavedb}/postmaster.pid 2>/dev/null
> ssh ${slave_dbuser}(at)${slave_host} rm ${slave_backup_path}/0* 2>/dev/null
> ssh ${slave_dbuser}(at)${slave_host} ${PSQL_BIN}/pg_ctl -D ${slavedb} -l logfile start

Is ${slave_backup_path} your archive directory? Why are you deleting all of you archives there?

Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k