Close access on DB or TABLE.

From: Mikail Majorov <mik(at)nix(dot)org(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Close access on DB or TABLE.
Date: 2002-04-27 04:25:58
Message-ID: 20020427082558.1abc72f6.mik@nix.org.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I have a production server. Many local (unix socket) and remote (tcp) connections.
Sometimes I need to work in 'single user' mode with one of database. For example, change structure of tables, triggers, functions. Very important is don't stop postmaster and over database must be accessable. How can I do it?

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2002-04-27 04:48:21 Re: delete column
Previous Message Bruce Momjian 2002-04-27 03:03:43 Re: delete column