Re: Database names and pg_dump

Should this be an FAQ?

---------------------------------------------------------------------------

Bruno LEVEQUE wrote:
> You can do a "psql -l". With this you can see all databases you have
> After this you can do a loop and a pg_dump for each one.
>
> 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.
> >
> >
> > --
> >
> > David Rickard
> > Software Engineer
> > The GTS Companies
> > A TechBooks Company
> >
> > ----------------------------------------------------------------------------------
> > The GTS Companies:
> > GTS Publishing Services, GTS Graphics, GTS Innova:
> > Your Single-Source Solution!
> > Los Angeles CA  *  York, PA  *  Boston MA  *  New Delhi, India
> > ----------------------------------------------------------------------------------
> >
> >
> > David.Rickard@GTSCompanies.com
> > Visit us on the World Wide Web
> > http://www.gtscompanies.com
> > 5650 Jillson St., Los Angeles, CA 90040
> > (323) 888-8889 x331
> > (323) 888-1849 [fax]
> >
> >
>
> --
> Bruno LEVEQUE
> System Engineer
> SARL NET6D
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073