pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rob Sargent <robjsargent@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: What is the best setup for distributed and fault-tolerant PG database?
Date: Wed, 4 Jan 2023 16:54:03 -0700
Message-ID: <547a49b4-c296-b82f-df34-11cc819d4336@gmail.com> (raw)
In-Reply-To: <CAD80oWYLyQmzbh1NM6DM6MkrF1P1SvJeNA=GLD5Qi8yp+L2cbw@mail.gmail.com>
References: <CAD80oWYLyQmzbh1NM6DM6MkrF1P1SvJeNA=GLD5Qi8yp+L2cbw@mail.gmail.com>

On 1/4/23 06:26, Age Apache wrote:
> Dear PG experts,
>
> I am new to postgres, and I am also not a DBA. I am a solo developer 
> who is trying to evaluate what database to use for my hybrid 
> multi-tenancy sub-apps i.e. users of the application will be 
> authorised to use part or whole of the application based on their 
> authorisation levels. This delineation of user access has to also be 
> supported by the database, if possible. Also, for audit purposes the 
> data is append only. And the design is based on just two 
> tables(vertices and edges) to emulate a document-oriented(jsonb) graph 
> structure.
>
> Postgres is the database I am leaning towards for this project. But as 
> I am not a DBA and also a solo developer, I am trying to understand 
> how I can spend less time managing the DB and more time developing the 
> application. I would like to have a distributed and fault-tolerant DB 
> setup with multiple read and write nodes with little to no 
> configuration on my part, if possible. I am looking for a self-hosted 
> open source solution.
>
> Is this possible with PG? What is the best way to achieve this for a 
> non-DBA solo developer like me?
>
> Thanks and kind regards
None of the experts chimed in so I ante up my $0.02.

It won't be possible unless you become a serious DBA _and_ solo (full 
stack) developer.  Or you pay for db support.

view thread (4+ messages)  latest in thread

Message-ID: <547a49b4-c296-b82f-df34-11cc819d4336@gmail.com>
Permalink:  ../547a49b4-c296-b82f-df34-11cc819d4336@gmail.com/
Also on:    postgresql.org/message-id/547a49b4-c296-b82f-df34-11cc819d4336@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: robjsargent@gmail.com
  Subject: Re: What is the best setup for distributed and fault-tolerant PG database?
  In-Reply-To: <547a49b4-c296-b82f-df34-11cc819d4336@gmail.com>
  References: <CAD80oWYLyQmzbh1NM6DM6MkrF1P1SvJeNA=GLD5Qi8yp+L2cbw@mail.gmail.com> <547a49b4-c296-b82f-df34-11cc819d4336@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox