Re: protect data of postgres database

From: Allan Kamau <kamauallan(at)gmail(dot)com>
To: Atul Kumar <akumar14871(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: protect data of postgres database
Date: 2020-12-16 12:16:14
Message-ID: CAF3N6oQ-rNPSEtntauDsUuiTFeZZN9p9Jeh0UX-JCCC4u-bbHw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)com> wrote:

> Hi,
>
> How can I protect my data by using any security on my postgres database.
>
>
> Please help me.
>
>
> Regards,
> Atul
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martín Marqués 2020-12-16 15:14:49 Re: Autovacuum not functioning for large tables but it is working for few other small tables.
Previous Message M Tarkeshwar Rao 2020-12-16 11:55:47 RE: Autovacuum not functioning for large tables but it is working for few other small tables.