Re: Running Postgres Daemons with same data files
От | Bhartendu Maheshwari |
---|---|
Тема | Re: Running Postgres Daemons with same data files |
Дата | |
Msg-id | 1070973212.16487.31.camel@bharat обсуждение исходный текст |
Ответ на | Re: Running Postgres Daemons with same data files (Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>) |
Ответы |
Re: Running Postgres Daemons with same data files
(Frank Finner <postgresql@finner.de>)
Re: Running Postgres Daemons with same data files (Halford Dace <hal@stowe.co.za>) |
Список | pgsql-admin |
Dear Sam, Thank you for the quick response. Can I you tell me why its not possible, it is possible with mysql then why not with postgres. Actually I am working on High Avaibility framework, and its our need, we can't make a separate database server. I want to read/write and then close the file, very simple isn't? So how can I achieve in postgres? Please help me. regards bhartendu On Tue, 2003-12-09 at 17:13, Sam Barnett-Cormack wrote: > Don't do that!!!! This absolutely cannot be done in any sane way. > > Instead, consider locating the database itself on one server, 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 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 > > > > > > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 9: the planner will ignore your desire to choose an index scan if your > > joining column's datatypes do not match > > > > -- > > Sam Barnett-Cormack > Software Developer | Student of Physics & Maths > UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend
В списке pgsql-admin по дате отправления: