Recovery in PostgreSql

From: "Sumita Chatterjee" <sumita(dot)chatterjee(at)cmcltd(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Recovery in PostgreSql
Date: 2006-03-27 09:25:33
Message-ID: 1348.203.197.96.141.1143451533.squirrel@mail.cmcltd.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have two questions:

1. In Postgresql, what is the name of the exact DATAFILE under the DATA
DIRECTORY ?

2. We want to prepare a backup machine (for disaster management) by
passing only the ARCHIVEDIR directory from another online machine - both
the machines have Postgresql installed. We have sent PGLOG and ARCHIVEDIR
but the recovery is not successful unless we send the FULL DATA Directory.

Please help us in resolving this problem whereby we do not have to send
the full DATA Directory.

The version of Postgresql is 8.0.3 on SuSe Linux 9.

Thanks and Regards

Sumita Chatterjee

Responses

Browse pgsql-general by date

  From Date Subject
Next Message SunWuKung 2006-03-27 09:31:17 case insensitive match in unicode
Previous Message Jo De Haes 2006-03-27 08:52:50 Re: invalid page header