Thread: URGENT: how to restore corrupted pg?

URGENT: how to restore corrupted pg?

From
pginfo
Date:
Hi all,
after many months of well working I was very supporaised that my pg do
not work.

It is produktion server.
I checked the pd directory and found that the global directory was
destroyed.
In my system it is file owned by root( I do not know how is it happen).
All other directories are there ( I am usinf about 5 db).

Exist any way to recover my global dir and data in my 5 db?

Many thanks in avdance,
ivan.


Re: URGENT: how to restore corrupted pg?

From
Date:
> Exist any way to recover my global dir and data in my 5 db?

Yes, at least two:
pg_restore from your backup
tar -x from your backup

~Berend Tober