"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