Skip site navigation (1) Skip section navigation (2)

Re: Database names and pg_dump

From: Tomka Gergely <tomka(at)zeus(dot)gau(dot)hu>
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 11:28:41
Message-ID: Pine.LNX.4.33.0308271328080.31338-100000@zeus.gau.hu (view raw or flat)
Thread:
Lists: pgsql-novice
2003-08-26 ragyogó napján David Rickard ezt üzente:

> 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.

Ehm, psql -l ?

-- 
Tomka Gergely
"S most - vajon barbárok nélkül mi lesz velünk?
Ők mégiscsak megoldás voltak valahogy..."


In response to

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2003-08-27 12:51:54
Subject: Re: Database names and pg_dump
Previous:From: Stuart WoodwardDate: 2003-08-27 08:58:08
Subject: Upgrading from 7.1.2 to 7.3.3 - function may need to add explicit typecasts

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group