Re: [GENERAL] Recovery in PostgreSql

2006-03-27 Thread Simon Riggs
On Mon, 2006-03-27 at 14:55 +0530, Sumita Chatterjee wrote: > 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 anothe

Re: [GENERAL] Recovery in PostgreSql

2006-03-27 Thread Chris
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 manageme

[GENERAL] Recovery in PostgreSql

2006-03-27 Thread Sumita Chatterjee
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 se