Dump large DB and restore it after all.

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

Responses

Browse pgsql-general by date

  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