| From: | pg043g9j2g <pg043g9j2g(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | migration with additional complications |
| Date: | 2009-05-18 22:43:14 |
| Message-ID: | 4A11E482.90507@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Last year about this time I started developing a web app using WAPP. It
also happened to be my first foray into PostgreSQL.
For various reasons I had to abandon that OS install and
reformat/reinstall WinXP. Time passes... Today I am looking to recover
my work and basically resume where I left off.
One problem is that I never did an "export" of the old database using
pg_dump or similar command. (pg_dump is how you're supposed to do it,
right?) The DB exists in its most evolved form as simply a PostgreSQL
database. I am not sure I will be able to "mount" the old database on
its original PostgreSQL installation -- my backup of files from before I
reformatted is just a "copy", not an "image." I don't think I can turn
it into a bootable "snapshot" of my workstation from 1 year ago.
I could go on about the bastardized techniques I have tried, but rather
than spam up the list with that particular form of comedy entertainment,
I'll just ask: how can I get this data into a new install of PostgreSQL?
Not sure the exact version I was using originally, but it was an 8.3
variant, whatever was the current stable release at the time (was there
a build on 3/17/08? That might be it.). Today I am using 8.3.7-1.
For what it's worth, the application was very much a work in progress,
and I am really more interested in the schemata than the data itself.
Thanks for reading, and for any help!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tino Schwarze | 2009-05-19 08:26:14 | Re: migration with additional complications |
| Previous Message | Scott Mead | 2009-05-18 16:09:08 | Re: Problem with .pgpass |