Re: Need help - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Need help
Date
Msg-id D960CB61B694CF459DCFB4B0128514C202FF65D1@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Need help  (Zico <mailzico@gmail.com>)
Responses Re: Need help  (Zico <mailzico@gmail.com>)
List pgsql-general
Zico wrote:
> our server suddenly went down and after searching, i found
> out that, the OS crashed. So, i had to re-install my OS
> again. But, the problem is, I couldnot take the dump file for
> my postgresql database. Now, i have the raw data, that means,
> my datas are in a disk. Is it possible to restore those data
> here in new server?

Copy all the files that belong to the PostgreSQL server (everything
under the data directory) to a working machine with PostgreSQL
installed, and you should be able to start the server there.

And remember to keep backups from now on.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: jub4@email.cz
Date:
Subject: pg_dump and 2gb limit on windows and version 8.1.3
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: Excel and pg