Search Postgresql Archives

pg_standby + test_warm_standby: A Community Report

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



After being asked to implement a warm standby server, I was pleased to happen upon Simon's pg_standby contribution. I was even more pleased to discover that it was designed to be compatible with the 8.2.x releases despite not being officially released until 8.3. I was then even more pleased to discover that Simon had helpfully provided a test harness for pg_standby, which is still available at the link referenced in this thread [note that pg_standby itself should probably be obtained from CVS at this point rather than from the thread referenced here]:


I had to tweak a few things to get the test harness functioning smoothly under Solaris 10 for x86, but once I did, pg_standby seemed fully up to the task of operating a warm standby server in a controlled environment.

Specifically, I had to:

* alter the hardcoded locale settings (e.g., the lc_ parameters in the supplied .conf files) from en_GB.UTF-8.
* avoid the use of the $PWD/.. syntax in archive_command and recovery_command. (I'm not sure whether this was just a shell environment issue or what.)
* change the deprecated -m option (for moving archived files) in restore_command in the supplied recovery.conf to -c

I've since tested pg_standby in a two-server primary/standby simple failover/recovery scenario, and everything worked smoothly.

All testing was conducted using postgres 8.2.3 on Solaris 10 for x86.

I still need to test restartable recovery and incrementable backups, but I'd like to say thanks to Simon and the whole PostgreSQL Global Development Group for a fine product and a robust community.

--
Thomas F. O'Connell

optimizing modern web applications
: for search engines, for usability, and for performance :

615-260-0005

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux