Re: protect data of postgres database - Mailing list pgsql-general

From Allan Kamau
Subject Re: protect data of postgres database
Date
Msg-id CAF3N6oQ-rNPSEtntauDsUuiTFeZZN9p9Jeh0UX-JCCC4u-bbHw@mail.gmail.com
Whole thread Raw
In response to protect data of postgres database  (Atul Kumar <akumar14871@gmail.com>)
List pgsql-general

A good place to start would be here "https://www.postgresql.org/docs/13/user-manag.html" and "https://www.postgresql.org/docs/13/client-authentication.html" and "https://www.postgresql.org/docs/current/ssl-tcp.html"

Additionally.
1) You may need to look into securing access to the physical server which hosts your PostgreSQL database.
2) Look into OS security and securing your OS (Operating System software) users.
3) Look into network security and network  firewalls, you may also configure and activate some firewall rules on your OS.
4) You may need to ensure your client applications are not prone to SQL injection. SQL injection can be mitigated by the use of parameters when supplying values to your database queries.

Allan.



On Wed, Dec 16, 2020 at 12:35 PM Atul Kumar <akumar14871@gmail.com> wrote:
Hi,

How can I protect my data by using any security on my postgres database.


Please help me.


Regards,
Atul


pgsql-general by date:

Previous
From: M Tarkeshwar Rao
Date:
Subject: Autovacuum not functioning for large tables but it is working for few other small tables.
Next
From: Martín Marqués
Date:
Subject: Re: Autovacuum not functioning for large tables but it is working for few other small tables.