Postgres Pro
Downloads
Home   >   mailing lists

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

From Serge Fonville
Subject Re: Is it possible to start PostgreSQL in 'restrict' mode
Date
Msg-id CAOAS_+KuYd56N_==tLsBfAPMb9Q24JQ3DNmUt-D9X8KRgb_dtw@mail.gmail.com
Whole thread Raw
In response to Is it possible to start PostgreSQL in 'restrict' mode  ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>)
List pgsql-novice
Tree view
Hi,

Do you mean only a single user could logon?
If that is what you mean, then you can get that by simply not adding any other users.

HTH

Kind regards/met vriendelijke groet,

Serge Fonville

http://www.sergefonville.nl

Convince Microsoft!
They need to add TRUNCATE PARTITION in SQL Server


2013/7/3 Birchall, Austen <austen.birchall@metoffice.gov.uk>

Hi

 

Is it possible to start a PostgreSQL cluster in ‘restrict’ mode so that only the postgres user can connect to a database i.e. as a means of keeping ‘normal’ user out when data updates etc. are being carried out?

 

Thanks

 

Austen Birchall

DBA

The Met Office


pgsql-novice by date:

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