locking all databases

From: Michiel Lange <michiel(at)minas(dot)demon(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: locking all databases
Date: 2003-06-24 06:43:53
Message-ID: 5.1.0.14.0.20030624084130.00b8edb0@192.168.1.3
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello everybody,

I wondered if it was possible to make all databases quiet for a while (e.g.
for a dump) so there are no updates in any database during that time? But
all transactions get into the before image, instead of being commited,
until the quiet state is ended?

Thanks!
Michiel

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Barna, Gary 2003-06-24 13:37:35 pg_restore --data-only (-a) does not work
Previous Message Michael Kovalcik 2003-06-23 18:47:06 How do I select the last Id in a column???