Re: Upgrade 7.2.1 to 7.3 - Mailing list pgsql-admin

From Robert Treat
Subject Re: Upgrade 7.2.1 to 7.3
Date
Msg-id 1047509468.23126.899.camel@camel
Whole thread Raw
In response to Upgrade 7.2.1 to 7.3  (Michael Brusser <michael@synchronicity.com>)
List 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@postgresql.org)




pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: I cannot get the db to initialize. Please help.
Next
From: Stephan Szabo
Date:
Subject: Re: Using functions as filters in queries