Re: Is it possible to start PostgreSQL in 'restrict' mode

From: Serge Fonville <serge(dot)fonville(at)gmail(dot)com>
To: "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Is it possible to start PostgreSQL in 'restrict' mode
Date: 2013-07-03 15:42:14
Message-ID: CAOAS_+KuYd56N_==tLsBfAPMb9Q24JQ3DNmUt-D9X8KRgb_dtw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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
https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table

2013/7/3 Birchall, Austen <austen(dot)birchall(at)metoffice(dot)gov(dot)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****
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2013-07-03 15:44:22 Re: Is it possible to start PostgreSQL in 'restrict' mode
Previous Message Birchall, Austen 2013-07-03 15:37:29 Is it possible to start PostgreSQL in 'restrict' mode