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/