Read-only mode

Started by Nonamealmost 25 years ago2 messagesgeneral
Jump to latest
#1Noname
alla@sergey.com

Is it possible to run PostgreSQL in read-only mode?

For executing some maintenance procedures, I need to move database in
and out of the read-only mode

Is it possbile in PostgreSQl and if yes, how would I do it

Thanks in advance

#2GH
grasshacker@over-yonder.net
In reply to: Noname (#1)
Re: Read-only mode

On Tue, Jul 03, 2001 at 09:29:35AM -0700, some SMTP stream spewed forth:

Is it possible to run PostgreSQL in read-only mode?

\begin{random guess and hackish mode}
Maybe by changing the permissions on the physical files.
It seems like PgSQL shouldn't be writing anything unless you tell it to.
\end{}

gh
--

What, no one sings along with Ricky Martin anymore?

My kid sister does (but then, she prefers pico to vi ...)
-- Suresh Ramasubramanian, alt.sysadmin.recovery