From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Database names and pg_dump |
Date: | 2003-08-26 21:47:01 |
Message-ID: | 1061934420.18060.176.camel@haggis |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tue, 2003-08-26 at 16:38, David Rickard 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.
http://archives.postgresql.org/pgsql-interfaces/2003-08/msg00058.php
--
-----------------------------------------------------------------
Ron Johnson, Jr. ron(dot)l(dot)johnson(at)cox(dot)net
Jefferson, LA USA
PETA - People Eating Tasty Animals
From | Date | Subject | |
---|---|---|---|
Next Message | Juan Francisco Diaz | 2003-08-26 21:47:19 | Returning SETOF INTEGER mystery... |
Previous Message | Tom Lane | 2003-08-26 21:44:19 | Re: Database names and pg_dump |