--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@sss.pgh.pa.us]
Sent: Friday, August 02, 2002 8:07 PM
To: Johnson, Shaunn
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] saving a view with pg_dump
"Johnson, Shaunn" <SJohnson6@bcbsm.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