Re: Multiple backends on a single physical database
| От | Vincent Janelle |
|---|---|
| Тема | Re: Multiple backends on a single physical database |
| Дата | |
| Msg-id | 3DA520E1.5020005@goblinstudios.com обсуждение исходный текст |
| Ответ на | Multiple backends on a single physical database (Anuradha Ratnaweera <anuradha@gnu.org>) |
| Ответы |
Re: Multiple backends on a single physical database
|
| Список | pgsql-admin |
No. Only one postmaster can access the PGDATA dir at one time. Attempting to run multiple copies will result in data corruption. http://gborg.postgresql.org/project/pgreplication/projdisplay.php contains the gborg project for replication. Anuradha Ratnaweera wrote: >I am wondering if it is sane to mount PGDATA over NFS on many >machines and run posmaster backends on them, so that all the >postmasters are using the same database. > >Obviously performance is going to suffer because network traffic >is going to be high, but later we may use a distributed filesystem >with replications instead of NFS. > >Thanks in advance. > > Anuradha > > >
В списке pgsql-admin по дате отправления: