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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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..."
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2003-08-27 12:51:54 | Re: Database names and pg_dump |
Previous Message | Stuart Woodward | 2003-08-27 08:58:08 | Upgrading from 7.1.2 to 7.3.3 - function may need to add explicit typecasts |