Re: Schema backup

On Tuesday 30 September 2003 09:15 pm, Greg wrote:
> I also have troubles with pg_dump. I have a database called 'shipping' and
> it has many tables(I populated them via a script). To dump the database I
> did these steps:
>
> su greg and then pg_dump > /tmp/greg.dmp. A file greg.dmp gets created but
> it has nothing in it(0 bytes). Could you advise what was wrong, please?
>
> Thanks in advance, Greg
>

You forgot to tell pg_dump the name of the database.  Try:
pg_dump shipping > /tmp/greg.dmp

Or, for a gzipped backup:
pg_dump shipping | gzip -c > /tmp/greg.dmp.gz

Best of luck,

Andrew Gould