Re: Postgres on shared network drive

Поиск
Список
Период
Сортировка
От Tomasz Ostrowski
Тема Re: Postgres on shared network drive
Дата
Msg-id 47FF1818.3090809@batory.org.pl
обсуждение исходный текст
Ответ на Postgres on shared network drive  (J Ottery <jottery@becsystems.com.au>)
Ответы Re: Postgres on shared network drive  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-general
On 2008-04-11 08:53, J Ottery wrote:

> I install PostgreSQL on a client PC and put the data files on a
> networked drive (instead of the local drive).  Postgres as user and
> localport. This works well.

This is not the way it is meant to work, and it can eat your data.

> Now I install postgresSQL on another client machine and point it to
> the same data directory on the network drive.

Wrong. You have to install PostgreSQL on one computer, with data
directory on local hard drive, and allow many client computers to
connect to it.

> Will this setup work OK for multiple / concurrent users and accessing
> the same tables on either of the client machines or is there something
> else I need to be aware of?

It won't work. Don't even try.

Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
                                                       Winnie the Pooh

В списке pgsql-general по дате отправления:

Предыдущее
От: J Ottery
Дата:
Сообщение: Postgres on shared network drive
Следующее
От: "Jan de Visser"
Дата:
Сообщение: Re: how to use transaction isolation