Re: Database names and pg_dump

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

In response to

Browse pgsql-novice by date

  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