Re: Running Postgres Daemons with same data files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bhartendu Maheshwari <bhartendum(at)jataayusoft(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Running Postgres Daemons with same data files
Date: 2003-12-11 15:01:08
Message-ID: 13258.1071154868@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Bhartendu Maheshwari <bhartendum(at)jataayusoft(dot)com> writes:
> I got all your points, thanks for such a great discussion, Now the last
> thing I want is how can I close the data files and flush the cache into
> the data files. How can I do this in postgresql????

Shut down the postmaster.

> I will also try with RAID and other suggested way you all suggested.

I don't think what people have been telling you has penetrated at all.
You CAN NOT run multiple postmasters concurrently on the same set of
database files. It will not work. It will corrupt your data. There
is no hack that will make it work.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Contact 2003-12-11 15:24:06 Re: Help---- Urgent
Previous Message Tom Lane 2003-12-11 14:15:12 Re: Postrgres data restoration problem