Re: Incomplete dump?

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

=?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