Re: Securing Information

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Securing Information
Date: 2016-12-28 16:49:34
Message-ID: alpine.LNX.2.11.1612280845390.30065@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 27 Dec 2016, Chris Weekes wrote:

> I was wondering what steps if any need to be taken to ensure that the
> patient and operational data is secure on a machine and or across the
> network.

Chris,

I'm far from an expert but until more knowledgeable folks respond I'll
offer a couple of quick suggestins. First, in your postgres data/ directory
modify pg_hba.conf. Specifying hostssl and an appropriate authentication method
will help. Second, partition your users into postgres role specifying what
each role can access and do.

The postgresql-9.6-US.pdf manual has all the details.

HTH,

Rich

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan de Visser 2016-12-28 16:53:51 Re: Performance PLV8 vs PLPGSQL
Previous Message Pavel Stehule 2016-12-28 16:42:35 Re: Indexes and loops