Re: how recovery database (i have all /data catalogue but pg_database file in /data/global is corrupt :/ - empty) - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: how recovery database (i have all /data catalogue but pg_database file in /data/global is corrupt :/ - empty)
Date
Msg-id 20150406221342.GI4369@alvh.no-ip.org
Whole thread Raw
In response to how recovery database (i have all /data catalogue but pg_database file in /data/global is corrupt :/ - empty)  (tierr <tomek@gorzyca.pl>)
List pgsql-admin
tierr wrote:
> hello friends. sorry for my bad eglish. i am from polen. I have big problem.
> My serwer has crashed and my instantion of postgresql 8.3 on windows not
> started. i know why... file in directory /data/global/pg_database is empty
> :/  i have all file from postgres server without this file, but this file is
> most important. My question is... what i can make to restore database from
> folder /data in new instance of postgres server? Please help

That file is not critical.  If you just remove it, the server will
create it again on restart.  (I tried on 8.3.23 removing it and also
creating it as an empty file; the server is able to start in both cases,
and the file later contains the correct contents).  Your problem must be
something else.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-admin by date:

Previous
From: Christian Vazquez
Date:
Subject: Re: Remove Node BDR status kill
Next
From: Wei Shan
Date:
Subject: Maximum Availability Architecture(MAA) for PostgreSQL