Re: Incomplete dump?

=?ISO-8859-1?Q?Benno_P=FCtz?= <puetz@mpipsykl.mpg.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