From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | David Rickard <David(dot)Rickard(at)GTScompanies(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org, Judith Strawser <judiths(at)GTScompanies(dot)com> |
Subject: | Re: Database names and pg_dump |
Date: | 2003-08-27 12:51:54 |
Message-ID: | 20030827125154.GE25066@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tue, Aug 26, 2003 at 14:38:15 -0700,
David Rickard <David(dot)Rickard(at)GTScompanies(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno LEVEQUE | 2003-08-27 16:56:21 | Re: Database names and pg_dump |
Previous Message | Tomka Gergely | 2003-08-27 11:28:41 | Re: Database names and pg_dump |