Re: Is it possible to start PostgreSQL in 'restrict' mode - Mailing list pgsql-novice

From Tom Lane
Subject Re: Is it possible to start PostgreSQL in 'restrict' mode
Date
Msg-id 6170.1372866262@sss.pgh.pa.us
Whole thread Raw
In response to Is it possible to start PostgreSQL in 'restrict' mode  ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>)
Responses Re: Is it possible to start PostgreSQL in 'restrict' mode  ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>)
List pgsql-novice
"Birchall, Austen" <austen.birchall@metoffice.gov.uk> writes:
> Is it possible to start a PostgreSQL cluster in 'restrict' mode so that only the postgres user can connect to a
databasei.e. as a means of keeping 'normal' user out when data updates etc. are being carried out? 

Sure, just adjust pg_hba.conf to accept connections from only that user.

            regards, tom lane


pgsql-novice by date:

Previous
From: Serge Fonville
Date:
Subject: Re: Is it possible to start PostgreSQL in 'restrict' mode
Next
From: "Birchall, Austen"
Date:
Subject: Re: Is it possible to start PostgreSQL in 'restrict' mode