On Tue, Apr 18, 2006 at 11:40:42AM +0530, [EMAIL PROTECTED] wrote:
> 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 reco
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.
Is it po
You can usually get the directory name by doingSELECT dataname, oid FROM pg_databases;To get the file name do:SELECT relname, relfilenode FROM pg_class WHERE relname = 'tblName';The relfilenode will tell you what numbed file belongs to the talbe. It's not always OID, but it often is (don't just as
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
the pg_xlog diectory.First time we have made a base backup & restore
the backup server by this backup.
