On Tue, Aug 26, 2003 at 14:38:15 -0700,
David Rickard <David.Rickard@GTScompanies.com> wrote:
> We are planning to migrate from Oracle to PostGreSQL, and we would like to
> replicate our database maintenance procedures/scripts as closely as
> possible;
> Our Oracle backup scripts extract the names of all active SIDs from the
> /etc/oratab file and perform a backup export for each SID;
> Is there an equivalent file or utility that will provide the name of each
> database within a PostGreSQL cluster?
> I know you can extract an entire cluster via pg_dumpall, but we would like
> to stick with the individual db backups--for file-size issues and restore
> efficiency.
pg_dump can be used to dump one database at a time.
psql -l can be used in a script to get a list of database names.