From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | puetz(at)mpipsykl(dot)mpg(dot)de |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Incomplete dump? |
Date: | 2006-05-24 20:17:00 |
Message-ID: | 1419.1148501820@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
=?ISO-8859-1?Q?Benno_P=FCtz?= <puetz(at)mpipsykl(dot)mpg(dot)de> writes:
> When trying to dump a database for upgrading to the current PSQL version
> using pg_dump I observed the following:
Which version of pg_dump were you using, exactly?
> The process seems to have finished without problems, but the resulting
> dump file does not end in
> --
> -- PostgreSQL database dump complete
> --
> but rather with a command line (complete, not truncated as might be the
> case when running out of disk space, which was plenty anyway)
> Is this an indication of an incomplete dump? If so how could one proceed?
I don't remember which version of pg_dump started adding that trailer.
If it's an old copy then maybe you're OK. If it should have a trailer
and doesn't then you're right to be suspicious. Could pg_dump have been
operating under a file-size ulimit that stopped it early?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-05-24 20:28:32 | Re: I dont get it, dump / restore failures to the same cluster. |
Previous Message | Scott Ribe | 2006-05-24 20:14:00 | Re: Error I don't understand, losing synch with server |