Re: [ADMIN] Running Postgres Daemons with same data files

2003-12-11 Thread Bhartendu Maheshwari
Dear matt Don't joke, this for stopping the Postgres Server. I want close the files in between the database operations. I am looking for some SQL command like in Mysql command is 'flush tables'. what's in postgres? regards bhartendu On Thu, 2003-12-11 at 16:56, Matt Clark wrote: > > I got all yo

Re: [ADMIN] Running Postgres Daemons with same data files

2003-12-10 Thread Bhartendu Maheshwari
y" system available if the first one fails. > > The path you seem anxious to trod will get very muddy and slippery. > > Good Luck. > > ...john > > Bhartendu Maheshwari wrote: > > >Dear UC, > > > >You are right for the HA solution but at the same t

Re: [ADMIN] Running Postgres Daemons with same data files

2003-12-10 Thread Bhartendu Maheshwari
> On Tuesday 09 December 2003 08:21 pm, Bhartendu Maheshwari wrote: > > Dear Hal, Frank, Oli and all, > > > > I understand what you all trying to say, I know this is not good way of > > designing, but we are planning for using the database for the keeping > > mobil

Re: [ADMIN] Running Postgres Daemons with same data files

2003-12-09 Thread Bhartendu Maheshwari
hunt around for > someone to add to your team who has extensive experience in this kind of > thing, since it's all too easy otherwise to unwittingly leave in lots of > single points of failure. (Have you considered multiple independent > UPSes? Communications lines? NAS switches l

Re: [ADMIN] Running Postgres Daemons with same data files

2003-12-09 Thread Bhartendu Maheshwari
erver, and then > having multiple other servers running the client application. > > On Tue, 9 Dec 2003, Bhartendu Maheshwari wrote: > > > Dear All, > > > > I am working in Linux 8.0 and running postgresql 7.2. I am trying to > > access same data files from the two

[ADMIN] Running Postgres Daemons with same data files

2003-12-09 Thread Bhartendu Maheshwari
Dear All, I am working in Linux 8.0 and running postgresql 7.2. I am trying to access same data files from the two postgres daemons. I mean there are two PC's running with postgres and one NAS server where data files are kept. To run postgres on the machines I first mount the NAS file system and t