Re: Upgrade 7.2.1 to 7.3

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: michael(at)synchronicity(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Upgrade 7.2.1 to 7.3
Date: 2003-03-12 22:51:08
Message-ID: 1047509468.23126.899.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

as long as your 7.2.1 dump is created with the 7.3.x pg_dump, this
should work fine. There are a number of corner cases where you could run
into trouble (pl lang issues, custom types, etc...) but it's simpler to
just try it on a test machine and then deal with anything that comes up.

Robert Treat

On Tue, 2003-03-11 at 07:56, Michael Brusser wrote:
> Hi, folks,
> I need to upgrade Postgres 7.2.1 to the current version: 7.3 or 7.3.x.
>
> I think one way to do it is to dump db with pg_dump, run db_init
> on the new server and import the dump.
>
> I wonder if this is the right approach;
> Am I going to have any potential problems with it?
> Do I need to do anything else?
>
> Are there any other ways I need to consider?
>
> Thank you,
> Michael.
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-03-12 23:09:17 Re: Using functions as filters in queries
Previous Message Tom Lane 2003-03-12 22:48:56 Re: I cannot get the db to initialize. Please help.