We are going to use the red hat cluster suite for a database solution
and would like to know if anyone has attempted (or knows if it's
possible) to have multiple postmasters running on separate nodes of the
cluster suite. Here's the specifics:
2 node cluster, 5 postmasters on each node, 10 dat
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
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
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
Ross J. Reedstrom writes:
> Another aspect of this problem is that, on most platforms, the children
> of postmaster that are forked for each connection rename themselves
> to 'postgres'. The code for this was changed, recently, due to some
> potential speed, security, or portability problems (I'm
On Wed, Jan 10, 2001 at 01:34:34PM -0600, David Mehringer wrote:
> On Wed, 10 Jan 2001, Peter Eisentraut wrote:
> >
> > > We're running postgresql 7.0.2 on solaris 5.7. The admin docs say that only
> > > one postmaster process should be running.
> >
> > The docs are wrong in that case. Can you
On Wed, 10 Jan 2001, Peter Eisentraut wrote:
>
> > We're running postgresql 7.0.2 on solaris 5.7. The admin docs say that only
> > one postmaster process should be running.
>
> The docs are wrong in that case. Can you name chapter and section so we
> can fix it?
>
Hi,
Thanks for the quick re
David Mehringer writes:
> We're running postgresql 7.0.2 on solaris 5.7. The admin docs say that only
> one postmaster process should be running.
The docs are wrong in that case. Can you name chapter and section so we
can fix it?
> However, our "master" postmaster
> process (PID=560 below) ap
Hi,
We're running postgresql 7.0.2 on solaris 5.7. The admin docs say that only
one postmaster process should be running. However, our "master" postmaster
process (PID=560 below) appears to have spawned off a couple of other
postmaster processes:
UID PID PPID CSTIME TTY TIME C
