Hi --
> I'm writing a backup script. Right now, I only have one database on my
> postgresql server. I'm
> deciding if I should use pg_dump or pg_dumpall when backing up the server. As
> far as I can tell,
> pg_dumpall cannot compress the dumps automatically and it only dumps data in
> the standard SQL
> text file format. This means that I would not be able to use pg_restore to
> selectively restore the
> database, correct?
>
> What is *NOT* included in a pg_dump that IS in pg_dumpall (Other than all the
> databases)?
> Things like user-defined functions and datatypes? Roles? Views?
The pg_dumpall gets users and groups that are not dumped in the single database
versions; I used
to use pg_dump on each of several databases on a given server and then
pg_dumpall with suitable
parameters to get only those bits and nothing else. User defined stuff, views
etc. are all in a given
database so they will be in the pg_dump.
HTH,
Greg Williamson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
