PostgreSQL Discussion - Recovery with pg

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Recovery with pg_xlog

jayati.biswas@cmcltd.com

2006-03-30, 8:26 pm

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.but when we want to recover from
pg_xlog backup.Firsttime it is working,after that not.Can we recover by
passing pg_xlog?

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Sponsored Links