From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Bruno LEVEQUE <bruno(dot)leveque(at)net6d(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Database names and pg_dump |
Date: | 2003-08-30 01:08:55 |
Message-ID: | 200308300108.h7U18tu05484@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-08-30 01:40:52 | Re: Database names and pg_dump |
Previous Message | Herbie McDuck | 2003-08-30 00:44:39 | Re: Boolean variables... |