Dump large DB and restore it after all.
От | Condor |
---|---|
Тема | Dump large DB and restore it after all. |
Дата | |
Msg-id | d21227dbb4c219504b50f79cb40f148e@stz-bg.com обсуждение исходный текст |
Ответы |
Re: Dump large DB and restore it after all.
Re: Dump large DB and restore it after all. |
Список | pgsql-general |
Hello ppl, can I ask how to dump large DB ? I read documentation but I has a problem with split that was year ago and did not use it after then. Problem was when I start: pg_dump dbname | split -b 1G - filename I unable to restore it correct. When I start restore DB i got error from sql he did not like one line. I make investigation and the problem was in last line of first file value field was something like '"This is a ' and here file over. I added single quotes in the example that I can pay the phrase to make it clear what I mean. In next file sentence was end correct 'simple test"' (also without single quotes) and this was not inserted into db. I use for now gzip but I don't know how safe is that, because when I check db size uncompressed is 5G and pg_database_size show me 10 G -- Regards, Condor
В списке pgsql-general по дате отправления: