Zico wrote:
> On Mon, May 18, 2009 at 6:11 PM, Albe Laurenz <laurenz.albe@wien.gv.at
> <mailto:laurenz.albe@wien.gv.at>> 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?