Re: Database names and pg_dump - Mailing list pgsql-novice

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.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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

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