Re: What is the best setup for distributed and fault-tolerant PG database?

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.