Re: upgrade from 7.4 to 8.3

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: upgrade from 7.4 to 8.3
Date: 2009-03-10 17:05:04
Message-ID: 20090310170504.GB13174@merkur.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Mar 10, 2009 at 05:02:59PM +0100, Marc Cuypers wrote:

> Is it possible to upgrade from 7.4 to 8.3 at once?
>
> I upgraded as follows:
> when 7.4 was installed i dumped the data with:
> su postgres -c "pg_dumpall --create" > out

Just a side note in case you didn't know: It is usually
recommended to use the later-version (8.3 here, that is)
pg_dump(all) for best results.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-03-10 17:12:03 Re: bug?: permission denied for schema on "on delete set null"
Previous Message Tom Lane 2009-03-10 16:56:56 Re: upgrade from 7.4 to 8.3