From: | Bhartendu Maheshwari <bhartendum(at)jataayusoft(dot)com> |
---|---|
To: | Postgres Mailing List <pgsql-admin(at)postgresql(dot)org> |
Subject: | Running Postgres Daemons with same data files |
Date: | 2003-12-09 11:17:09 |
Message-ID: | 1070968629.15674.23.camel@bharat |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 then run it like
shell>postmaster -D $(PATH_TO_DATA_FILE)
Daemons are running well but there is problems with synchronization of
the data files i.e when i insert some tuples in the tables its not
immediately writing then to file its kept in the cache only and when I
try to see from the other machine its displaying the old tuples.
I want after every transaction or query the database update the data
files, how can I do this? And always read from the data files for select
operations. My main aim is no cache operation to use the postgres as
file system(for every operation file operations only), I know it will
degrade the database performance but its the requirement OR if there is
any other way by which I can achieve this, please tell me.
regards
bhartendu
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Barnett-Cormack | 2003-12-09 11:43:32 | Re: Running Postgres Daemons with same data files |
Previous Message | Sai Hertz And Control Systems | 2003-12-09 08:43:36 | Re: Auto commit Off how will it effect us ? |