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