pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhow recovery database (i have all /data catalogue but pg_database file in /data/global is corrupt :/ - empty)
2+ messages / 2 participants
[nested] [flat]
* how recovery database (i have all /data catalogue but pg_database file in /data/global is corrupt :/ - empty)
@ 2015-04-05 16:47 tierr <tomek@gorzyca.pl>
0 siblings, 1 reply; 2+ messages in thread
From: tierr @ 2015-04-05 16:47 UTC (permalink / raw)
To: pgsql-admin
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
--
View this message in context: http://postgresql.nabble.com/how-recovery-database-i-have-all-data-catalogue-but-pg-database-file-in...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: how recovery database (i have all /data catalogue but pg_database file in /data/global is corrupt :/ - empty)
@ 2015-04-06 22:13 Alvaro Herrera <alvherre@2ndquadrant.com>
parent: tierr <tomek@gorzyca.pl>
0 siblings, 0 replies; 2+ messages in thread
From: Alvaro Herrera @ 2015-04-06 22:13 UTC (permalink / raw)
To: tierr <tomek@gorzyca.pl>; +Cc: 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-04-06 22:13 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-04-05 16:47 how recovery database (i have all /data catalogue but pg_database file in /data/global is corrupt :/ - empty) tierr <tomek@gorzyca.pl>
2015-04-06 22:13 ` Alvaro Herrera <alvherre@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox