From: | Condor <condor(at)stz-bg(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Dump large DB and restore it after all. |
Date: | 2011-07-05 09:00:45 |
Message-ID: | d21227dbb4c219504b50f79cb40f148e@stz-bg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Condor | 2011-07-05 09:03:23 | Re: Difference in DB size with dump and pg_database_size |
Previous Message | Magnus Hagander | 2011-07-05 08:43:38 | Re: Difference in DB size with dump and pg_database_size |