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)
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. |