| From: | will trillich <will(at)serensoft(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, debian-user(at)lists(dot)debian(dot)org |
| Subject: | postgresql upgrades -> where's the dump go? |
| Date: | 2001-02-28 01:38:23 |
| Message-ID: | 20010227193823.A31544@mail.serensoft.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
http://groups.yahoo.com/group/newbieDoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Harding | 2001-02-28 01:44:44 | Re: Slowdown problem when writing 1.7million records |
| Previous Message | Jeff MacDonald | 2001-02-28 01:34:09 | Re: Does PostGresSQL have this feature? |