Re: [ADMIN] Multiple postmasters for one data directory...

2004-03-11 Thread Stef
Tom Lane mentioned : => Get out your backup tapes, because what you have on disk now is just a => pile of inconsistent bits. I haven't actually done anything but SELECT's from the shared postmaster, and it was a test machine. Phew!! Glad I asked first... I think the way I'll do it, is by using in

Re: [ADMIN] Multiple postmasters for one data directory...

2004-03-11 Thread Tom Lane
Stef <[EMAIL PROTECTED]> writes: > I've managed to make such a database cluster on a separate postmaster, > and re-linked all the database directories to point to the data directories > of all the other postmasters. > Although this workaround seems to be working rather well, I know for one > thing

[ADMIN] Multiple postmasters for one data directory...

2004-03-11 Thread Stef
Hi all, I've got a situation on certain machines where approximately 70 postmasters are running. Each with one database, and one data directory. This is fine most of the time, except for a certain time of the month, when a very large consolidation process has to run on each database. At this tim