Re: saving a view with pg_dump

--Thanks for the reply:

--I tried to do a dump of the entire database
to a partition and it choked on 2.1 Gig size
... the message was:

snip [error]

sh: line 34: 13302 Broken pipe /backup/pg_dump -U postgres bcn
13303 File size limit exceeded| /bin/gzip >/backup/tools/bcndmp.gz

[/snip error]

--If I could make some room on the same machine / filesystem, it
wouldn't be a problem. So now that I'm breaking it up,
I'm thinking I have to do the same for views, triggers, sequences,
etc ...

--Can pg_dump could do that?

-X

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Friday, August 02, 2002 8:07 PM
To: Johnson, Shaunn
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] saving a view with pg_dump

"Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> writes:
> Running PostgreSQL 7.1.3 (migrating to 7.2.1) and
> I'm dumping the database with pg_dump (from the 7.2.1
> version).

> Is it possible to use pg_dump to create a file for
> a view / sequence / etc?

pg_dump should save all that stuff automatically.

regards, tom lane