News for hackers. Stuff that matters.
Re:PostgreSQL 9.0b1 with built-in replication support by a2tech on Monday May 03, 2010 @10:42AM (#1314816)
As with any major postgres update this calls from a full dump of the database and a restore into the new version-you can't simply update the database files.

pg_dump -clean makes this a snap so you shouldn't have any problems upgrading. (oh and if you're doing backups-you are using pg_dump --clean right? Its really the best way).

Re:PostgreSQL 9.0b1 with built-in replication support by russss on Monday May 03, 2010 @10:55AM (#1314844)
If you use "pg_dump -F c", pg_restore is able to parallelize the restore, which makes things go a lot quicker.
Re:PostgreSQL 9.0b1 with built-in replication support by a2tech on Monday May 03, 2010 @10:59AM (#1314851)
Wow-thats a great tip. Thanks!
Re:PostgreSQL 9.0b1 with built-in replication support by defen on Monday May 03, 2010 @03:23PM (#1315797)
Does this cause any problems if you have foreign key constraints? I remember running into that problem a couple years ago when restoring a pg_dump.
Re:PostgreSQL 9.0b1 with built-in replication support by pilif on Monday May 03, 2010 @12:22PM (#1315117)
maybe we'll get an updated pg_migrator once the release is out. While dump/restore is for sure the safer option, once your databases reach Terabytes in size, doing the migration in-place (most of the time the on-disc structure is quite similar between releases) will be a huge speed advantage.