pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
moving from 7.4.13 to 8.0.14 2+ messages / 2 participants [nested] [flat]
* moving from 7.4.13 to 8.0.14 @ 2008-04-24 10:15 Antonis Antoniou <antonis@witch-spirit.com> 2008-04-24 15:59 ` Re: moving from 7.4.13 to 8.0.14 Scott Marlowe <scott.marlowe@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Antonis Antoniou @ 2008-04-24 10:15 UTC (permalink / raw) To: pgsql-admin Hi, Currently I am using postgres 7.4.13 and I will like upgrade it to 8.0.14 I have backup my databases by using pg_dumpall (7.4.13) pg_dumpall -U postgres > /root/backup_all_db Is it doable to load the backup file using the psql (8.0.14) ? Another question: Is it possible to upgrade 7.4.13 straight to 8.2? Many Thanks, Antonis ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: moving from 7.4.13 to 8.0.14 2008-04-24 10:15 moving from 7.4.13 to 8.0.14 Antonis Antoniou <antonis@witch-spirit.com> @ 2008-04-24 15:59 ` Scott Marlowe <scott.marlowe@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Scott Marlowe @ 2008-04-24 15:59 UTC (permalink / raw) To: Antonis Antoniou <antonis@witch-spirit.com>; +Cc: pgsql-admin On Thu, Apr 24, 2008 at 4:15 AM, Antonis Antoniou <antonis@witch-spirit.com> wrote: > Hi, > > Currently I am using postgres 7.4.13 and I will like upgrade it to 8.0.14 > I have backup my databases by using pg_dumpall (7.4.13) > pg_dumpall -U postgres > /root/backup_all_db It will probably work. However, it is best to dump the old database (7.4.x) with the new pg_dump (8.0.x) > Is it doable to load the backup file using the psql (8.0.14) ? Yes. psql is the preferred restore program for uncompressed file formats. > Another question: Is it possible to upgrade 7.4.13 straight to 8.2? yes, and also 8.3 as well. I'd recommend going to at least 8.2. 8.3 got rid of a lot of auto-type coercion that may break some poorly formed queries. I'd recommend at least testing on 8.3 to see if you can go to it. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-04-24 15:59 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-04-24 10:15 moving from 7.4.13 to 8.0.14 Antonis Antoniou <antonis@witch-spirit.com> 2008-04-24 15:59 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox