Re: Recovery in PostgreSql

Sumita Chatterjee wrote:
> I have two questions:
>
> 1. In Postgresql, what is the name of the exact DATAFILE under the DATA
> DIRECTORY ?

It depends. The subfolders under data are the OID of the database - they
are not stored per name.

> 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.

You're out of luck.

Even this method is dangerous - differences in platforms, software
versions will cause issues.

Why not use pg_dumpall or pg_dump ?

--
Postgresql & php tutorials
http://www.designmagick.com/