Re: [GENERAL] Porblems migrating a server.
On Sep 25, 2007, at 10:37 , Alvaro Herrera wrote: Michael Glaesemann wrote: You might need to use adddepend, which is a contrib module included in 8.1 (not 8.2 AIUI). (Perhaps 8.2 includes this functionality in core? You can probably check the release notes for 8.2 for details.) Not in core -- the code was pushed to pgfoundry. Ah, that's right. Thanks, Alvaro. Here's a link: http://pgfoundry.org/projects/adddepends/ Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Porblems migrating a server.
Michael Glaesemann wrote: > > On Sep 25, 2007, at 9:00 , David Siebert wrote: >> Any suggestions on what the command line should look like? > > You might need to use adddepend, which is a contrib module included in 8.1 > (not 8.2 AIUI). (Perhaps 8.2 includes this functionality in core? You can > probably check the release notes for 8.2 for details.) Not in core -- the code was pushed to pgfoundry. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] Porblems migrating a server.
On Sep 25, 2007, at 9:00 , David Siebert wrote: I have a very old postgres server that I am trying to move the data off of. It is running 7.1 and has been trouble free for 6 plus years. I am trying to move the data base off to a server running 8.1. In my opinion you should look at 8.2, not 8.1. And 8.3 is on the horizon :) I have managed to back up the data using PG_Dump using like this. " pg_dump -b -Fc -h stan.someplace.com -u phone >phone.data" Be sure to use the 8.2 pg_dump, not the 7.1 pg_dump, against the 7.1 database. But I have had no luck getting PG_Restore to restore the data. It would be helpful if you provided the exact pg_restore command you're using (again, it should be the 8.2 version of pg_restore) and the exact error you're getting. Otherwise it's difficult for us to know what's going on. Any suggestions on what the command line should look like? You might need to use adddepend, which is a contrib module included in 8.1 (not 8.2 AIUI). (Perhaps 8.2 includes this functionality in core? You can probably check the release notes for 8.2 for details.) I really want to migrate it before the PII 266 it is running on gives up the ghost :) Not only the hardware :) 7.1 includes known data-eating bugs. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/