From: | root <root(at)weyland(dot)caerdroia(dot)org> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Import Database |
Date: | 2005-03-23 03:31:45 |
Message-ID: | 200503230331.j2N3VjOt008146@weyland.caerdroia.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
This is a little odd, and I can't quite figure out how to do it.
I have a postgres 7.2.2 database, without the DB_VERSION file, so I'm assuming
this is an "alternate location" - as you can tell, I'm not a DBA. Anyway,
the machine it was on got hacked, and I backed off the things I thought were
important, reinstalled the OS and put the other things, including this DB,
back into place. Problem: I don't have the /var/lib/pgsql part of my old
installation, and now I have an apparently-good postgres 7.2.2 installation,
and an apparently-good database, but I cannot get the postgres server to
recognize the old database.
Obviously, without this I cannot dump and re-import, so I'm at a bit of a lss
as to what to do. Is it possible to tell postgres that a database already
exists, and just to use it? (I do know the information on the user who
owns the database, and the old passwords and such.)
Thanks
-jeff
From | Date | Subject | |
---|---|---|---|
Next Message | Olivier Martineau | 2005-03-23 13:18:44 | Probllem with initdb on Windows XP |
Previous Message | Gregory S. Williamson | 2005-03-22 22:49:54 | Re: dbmirror |