Any chance you might be able to put together a HOWTO on this? I think it would be extremely valuable to a lot of people.
On Tue, Nov 25, 2003 at 11:25:34PM -0500, Andrew Sullivan wrote: > On Mon, Nov 24, 2003 at 11:08:44PM -0600, Jim C. Nasby wrote: > > > Has anyone looked at using replication as a migration method? If > > Looked at? Sure. Heck, I've done it. Yes, it works. Is it > painless? Well, that depends on whether you think using erserver is > painless. ;-) It's rather less downtime than pg_dump | psql, I'll > tell you. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Member: Triangle Fraternity, Sports Car Club of America Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match