Re: Database names and pg_dump - Mailing list pgsql-novice

From Ron Johnson
Subject Re: Database names and pg_dump
Date
Msg-id 1061934420.18060.176.camel@haggis
Whole thread Raw
In response to Database names and pg_dump  (David Rickard <David.Rickard@GTScompanies.com>)
List 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.l.johnson@cox.net
Jefferson, LA USA

PETA - People Eating Tasty Animals


pgsql-novice by date:

Previous
From: Juan Francisco Diaz
Date:
Subject: Returning SETOF INTEGER mystery...
Next
From: Tom Lane
Date:
Subject: Re: Database names and pg_dump