Hannu Krosing wrote:
> >
> > However, the limiting factor is that we don't have a mechanism to have
> > both databases running at the same time currently.
>
> How so ?
>
> AFAIK I can run as many backends as I like (up to some practical limit)
> on the same comuter at the same time, as long as they use different
> ports and different data directories.
We don't have an automated system for doing this. Certainly it is done
all the time.
> > Intersting idea, but I am not sure what that buys us. Having pg_dump
> > separate makes maintenance easier.
>
> can pg_dump connect to single-user-mode backend ?
Uh, no, I don't think so.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026