Обсуждение: Starting without WAL files
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
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
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
> Not sure. Does /contrib/pg_resetxlog help? Try running it. That would have helped quite a bit. It's too late now, but it's something I'll remember for next time. Thanks. --Nate