From: | Fabrice Scemama <gesnet(at)scemama(dot)org> |
---|---|
To: | will trillich <will(at)serensoft(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgresql upgrades -> where's the dump go? |
Date: | 2001-03-01 04:04:39 |
Message-ID: | Pine.LNX.4.10.10103010504001.21832-100000@ns.linux.bogus |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Why don't you read the INSTALL file, included in
any pg distribution ?
On Tue, 27 Feb 2001, will trillich wrote:
> when upgrading from version X to version Y of postgres, the
> install appears to dump the data and schema, and then suck it
> back in with the new binaries.
>
> [i just tried going from 6.5.3 to 7.0.3potato but the plpgsql.so
> module wasn't installed and data types were conflicting, so the
> new schema is a bit scrambled -- but if i can get to the
> resurrection file, i'll be fine...]
>
> so where's the dump file that gets created? mine had some snags
> and i can fix it if i can edit the dump text. (i presume it's a
> series of SQL commands...)
>
> anybody know where that file is?
>
> --
> will(at)serensoft(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Hans-Jürgen Schönig | 2001-03-01 04:24:46 | PL/pgSQL and function overloading |
Previous Message | Tom Lane | 2001-03-01 03:45:08 | Re: how to vacuum from cron? |