"Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk> writes:
> 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?
Sure, just adjust pg_hba.conf to accept connections from only that user.
regards, tom lane