Re: Access a Postgres storage with two independent instances

From: Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)ca>
To: pgsql-novice(at)lists(dot)postgresql(dot)org, pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: Access a Postgres storage with two independent instances
Date: 2024-05-06 20:36:59
Message-ID: 03caa4a3b0daf352e53e99212baa9c012cd744f2.camel@lists.simkin.ca
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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
> . Anyway, it can not use single
> storage(
> https://stackoverflow.com/questions/78436945/access-a-mysql-storage-with-two-independent-instances
> ).
> 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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message first last 2024-05-07 04:26:50 Re: Access a Postgres storage with two independent instances
Previous Message first last 2024-05-06 19:17:40 Access a Postgres storage with two independent instances