Re: Access a Postgres storage with two independent instances

Поиск
Список
Период
Сортировка
От first last
Тема Re: Access a Postgres storage with two independent instances
Дата
Msg-id CAG3FJTamrfzk4k+KC+bTn0axMrPqj9yaoYOzmoiRX5n90QcTFg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Access a Postgres storage with two independent instances  (Alan Hodgson <ahodgson@lists.simkin.ca>)
Ответы Re: Access a Postgres storage with two independent instances
Re: Access a Postgres storage with two independent instances
Список pgsql-novice
Дерево обсуждения
Actually what I want is multiple Postgres instances to have read and write access to the same data storage directory. Anyway, that can not be possible as what you say. But, when I deploy MySQL/MongoDB deployment with multiple replicas to access the same storage, the all pods except one become CrashLoopBackOff state. This is happening for MySQL/Mongo. When it comes to Postgres, I deployed it with multiple pods, all the pods became healthy and there is no such CrashLoopBackOff state occurred. But those pods access different storages for every pod. Why this totally different from MySQL and Mongo?

On Tue, May 7, 2024 at 2:34 AM Alan Hodgson <ahodgson@lists.simkin.ca> wrote:
On Tue, 2024-05-07 at 00:47 +0530, first last wrote:
I tried to deploy Postgres deployment with Kubernetes, having three replicas that are accessing the same storage(PVC). Here is the configuration

Finally, my question is, why the scenario is different for MySQL and Postgres?  Could you please help me to figure out the issue? This is for my Final year project testing Kubernetes using fuzzing.


Not sure what you're trying to accomplish, but PostgreSQL can definitely not share storage between active postmasters. Nor can MySQL, afaik.

On Tue, May 7, 2024 at 2:34 AM Alan Hodgson <ahodgson@lists.simkin.ca> wrote:
On Tue, 2024-05-07 at 00:47 +0530, first last wrote:
I tried to deploy Postgres deployment with Kubernetes, having three replicas that are accessing the same storage(PVC). Here is the configuration

Finally, my question is, why the scenario is different for MySQL and Postgres?  Could you please help me to figure out the issue? This is for my Final year project testing Kubernetes using fuzzing.


Not sure what you're trying to accomplish, but PostgreSQL can definitely not share storage between active postmasters. Nor can MySQL, afaik.

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

Предыдущее
От: Alan Hodgson
Дата:
Сообщение: Re: Access a Postgres storage with two independent instances
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Access a Postgres storage with two independent instances