Re: [GENERAL] Un successful Restoration of DATA using WAL files

2010-02-22 Thread Bruce Momjian
Based on your suggestions, I have applied the attached patch to mention _not_ to use pg_dump or pg_dumpall in two places, and to briefly explain why. Thanks. --- Craig Ringer wrote: > On Mon, 2009-10-19 at 07:18 -0700, Mite

Re: [GENERAL] Un successful Restoration of DATA using WAL files

2009-10-19 Thread Craig Ringer
On Mon, 2009-10-19 at 07:18 -0700, Mitesh51 wrote: > I am unable to restore data with the use of WAL files by following procedure. > > I have done following changes in postgres.conf to enable WAL archiving... > > archive_mode = on # allows archiving to be done > archive_command = 'cop

Re: [GENERAL] Un successful Restoration of DATA using WAL files

2009-10-19 Thread Craig Ringer
On Mon, 2009-10-19 at 07:18 -0700, Mitesh51 wrote: > I am unable to restore data with the use of WAL files by following procedure. > > I have done following changes in postgres.conf to enable WAL archiving... > > archive_mode = on # allows archiving to be done > archive_command = 'cop

[GENERAL] Un successful Restoration of DATA using WAL files

2009-10-19 Thread Mitesh51
I am unable to restore data with the use of WAL files by following procedure. I have done following changes in postgres.conf to enable WAL archiving... archive_mode = on # allows archiving to be done archive_command = 'copy "%p" "C:\\archivedir\\%f"' I have one database(buil