How To Easily Migrate A PostgreSQL Server With Minimal Downtime
Apr 09, 2010, 13:34 (0 Talkback[s])
[ Thanks to Falko
Timme for this link. ]
"PostgreSQL is a great database server, but when your
dataset is rather large, migrating a server by using pg_dump can be
a rather long process. In this tutorial we will discuss a way to
migrate a entire server with as little downtime as possible. To
achieve this, we will be using the PostgreSQL built in features for
PITR (Point in time recovery).
"Assumptions
"This tutorial assumes you have 2 PostgreSQL 8.3 servers running
on a Debian / Ubuntu based Linux distribution. The database
versions need to be the same. You cannot use this to migrate from
8.3 to 8.4.
"The destination PostgreSQL server's data directory will be
lost!
"Preperation
"Preperation is key, especially to avoid as much downtime as
possible. Therefore, read this entire tutorial before proceeding
with running any of the commands. If you do not fully understand
what the command is supposed to do; don't run it. It is possible to
destroy your current PostgreSQL database. Always have a backup on
hand!"
Complete Story
Related Stories:
- Chrooting Apache2 With mod_chroot On Fedora 12(Apr 07, 2010)
- Virtualization With KVM On A Mandriva 2010.0 Server(Mar 27, 2010)
- Tweaking Hidden Settings With Ubuntu Tweak On Ubuntu 9.10(Mar 26, 2010)
- Weekly Ten: Tech Bubble That Didn't Pop, Build Your Own 3D Scanner, WebDAV On OpenSUSE(Mar 25, 2010)
- Creating An NFS-Like Standalone Storage Server With GlusterFS On CentOS 5.4(Mar 21, 2010)
- Build Your Own Video Community With Lighttpd And FlowPlayer (Ubuntu 9.10)(Mar 18, 2010)
- VBoxHeadless - Running Virtual Machines With VirtualBox 3.1.x On A Headless Fedora 12 Server(Mar 15, 2010)
- How To Harden PHP5 With Suhosin On CentOS 5.4(Mar 15, 2010)
