Re: [GENERAL] WAL file size vs. data file size

2011-10-27 Thread Ben Chobot
On Oct 27, 2011, at 8:44 AM, Tom Lane wrote: > Ben Chobot writes: >> Today I tried to restore a 70GB database with the standard "pg_dump -h >> old_server <∑> | psql -h new_server <∑>" method. I had 100GB set aside for >> WAL files, which I figured surely would be enough, because all of the data

Re: [GENERAL] WAL file size vs. data file size

2011-10-27 Thread Tom Lane
Ben Chobot writes: > Today I tried to restore a 70GB database with the standard "pg_dump -h > old_server <…> | psql -h new_server <…>" method. I had 100GB set aside for > WAL files, which I figured surely would be enough, because all of the data, > including indices, is only 70GB. So I was a bi

[GENERAL] WAL file size vs. data file size

2011-10-26 Thread Ben Chobot
Today I tried to restore a 70GB database with the standard "pg_dump -h old_server <…> | psql -h new_server <…>" method. I had 100GB set aside for WAL files, which I figured surely would be enough, because all of the data, including indices, is only 70GB. So I was a bit surprised when the restore