Restoring database disk space requirements???
От | Gordan Bobic |
---|---|
Тема | Restoring database disk space requirements??? |
Дата | |
Msg-id | 000701c0f7e2$99b947a0$800010ac@localdomain обсуждение исходный текст |
Ответ на | Re: Insert and limit ("Matteo Centenaro" <gente_che_mixa@hotmail.com>) |
Ответы |
Re: Restoring database disk space requirements???
|
Список | pgsql-general |
Hi! I seem to be having a problem. I have a database that is around 10 GB in size. I have it running on a 40 Gb disk. I tried to dump and restore two of the tables, around 4 GB in size. All went find, the file approximately 5 GB in size was created. No problem. I wanted to import the data into another database. However, when I try to import the database, the disk fills up with about 20 GB of files in the pg_xlog directory, and the postmaster crashes out. The only way to get anything to run then is to kill those files, after which postgres refuses to start. the only way to get it to work again is to delte the files in /var/lib/pgsql/data and re-run initdb. Unfortunately, when I try to restore the backed up data, the same thing happens. Can somebody please explain to me why is it that 20 Gb of disk space is required to restore 5 GB of data? I am guessing that WAL is creating those files, but with the 64 file limit in the config file, and each file being 16 MB, that should only ever be up to 1 GB - NOT 20 GB! What is going on? I have had this same problem with v7.0, and now with v7.1. Is there an obscure section in the docs that I have missed? Cheers. Gordan
В списке pgsql-general по дате отправления: