Re: Database names and pg_dump

Bruce Momjian wrote:
>
> Should this be an FAQ?

I now see this is already in the FAQ, items 4.7 and 4.3. Do we need
more?

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

>
> ---------------------------------------------------------------------------
>
> 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(dot)Rickard(at)GTSCompanies(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

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