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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster