Starting without WAL files
Starting without WAL files
От:
Nathan Mueller <nmueller@cs.wisc.edu>
Дата:
I had a hardware error on my server and lost the WAL files. I can restore my data, but because of the size of the database that'll take at least 12 hours. Is there any way to start the server without the transaction logs? --Nate
Re: Starting without WAL files
От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
Nathan Mueller wrote: > I had a hardware error on my server and lost the WAL files. I can > restore my data, but because of the size of the database that'll take at > least 12 hours. Is there any way to start the server without the > transaction logs? Not sure. Does /contrib/pg_resetxlog help? Try running it. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Re: Starting without WAL files
От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
Nathan Mueller wrote: > I had a hardware error on my server and lost the WAL files. I can > restore my data, but because of the size of the database that'll take at > least 12 hours. Is there any way to start the server without the > transaction logs? However, once you use /contrib/pg_resetxlog, you will need to dump your data, initdb and reload, so a restore from a backup may be more reliable. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026