Zico wrote:
On Mon, May 18, 2009 at 6:11 PM, Albe Laurenz <laurenz.albe@xxxxxxxxxx <mailto:laurenz.albe@xxxxxxxxxx>> wrote:I'm still not sure what that means, but if you have the contents of the database, but the database itself is gone without a trace,then what else can you do but create a new database and fill it anew?That`s what i am asking about. :) Fill it anew? That means, i have to insert all 2000 data again?? Is there any other option to "restore" all data there?
we still don't understand exactly what you have to work from.... Do you have a backup of the Postgres "data" directory, which typically is something like "C:\Program Files\PostgreSQL\8.2\data" on a Windows system? If so, you can install the same version of postgres, then "STOP" it, copy the 'data' directory into the proper place, and restart the server, and it should see your databases all intact. You might have to mess around a bit with file permissions, windows makes that kind of sketchy.
if you don't have a backup of this data directory, and you've said you don't have any pg_dumpall type backups made prior to the system crash, then, what exactly do you expect to be able to restore your data from?
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
