From: Erik Wienhold <ewie@ewie.name>
To: B M <bmmasprep@gmail.com>
To: pgsql-docs@lists.postgresql.org
Subject: Re: large scale reliable software system
Date: Wed, 21 Jun 2023 19:17:48 +0200 (CEST)
Message-ID: <378043614.1217340.1687367868601@office.mailbox.org> (raw)
In-Reply-To: <CAPDsptXWa=pDMp1Y+e-R4+oQLNZ_nfoRkeAVMtaqWsEvrBxUOQ@mail.gmail.com>
References: <CAPDsptXWa=pDMp1Y+e-R4+oQLNZ_nfoRkeAVMtaqWsEvrBxUOQ@mail.gmail.com>
I recommend posting this to pgsql-admin or pgsql-general instead of pgsql-docs
to get more responses. Besides that, pgsql-docs is for discussions on the
Postgres docs.
> On 21/06/2023 18:52 CEST B M <bmmasprep@gmail.com> wrote:
>
> I would like to know your advices to develop a large scale reliable software
> system using PostgreSQL in the back-end,
This is very general but the following points hopefully lead you in the right
direction:
> through which i can share the storage with the different system users where
> they login to the system through the web application front-end with different
> passwords and usernames , save the privacy of each user data, improve overall
> system security
The OWASP Cheat Sheets give advice on securing web applications:
https://cheatsheetseries.owasp.org/> and performance, achieve fast response,
My general advice: design and implement for correctness, then measure and
optimize. For performance, look into high availability:
https://www.postgresql.org/docs/current/high-availability.html> make backups and save the stored data from loss.
Use pgBackRest or pgbarman with WAL streaming to reduce the recovery point
objective (the maximum period in which data might be lost).
> The system will be hosted on a cloud.
Some cloud providers offer Postgres instances including backups, e.g. Google
Cloud Platform which I'm looking into right now.
--
Erik
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 using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: ewie@ewie.name, bmmasprep@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: large scale reliable software system
In-Reply-To: <378043614.1217340.1687367868601@office.mailbox.org>
* 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