If I had to reorganize the database, I would prefer to terminate the
connections. Any way to do that without having to restart the db
server? Could I kill the PID's for the users (Linux RedHat)
In order to modify a user's permissions, must I restart the db server?
Can one do an SQL-dump while users are modifying the data?
-----Original Message-----
From: Bruno Wolff III [mailto:bruno@wolff.to]
Sent: Thursday, May 29, 2003 1:28 PM
To: Carlos
Cc: 'pgsql-general@postgresql.org'
Subject: Re: [GENERAL] Blocking access to the database??
On Thu, May 29, 2003 at 12:29:16 -0400,
Carlos <Carlos@pbsinet.com> wrote:
> Hi Forum,
>
> Is there a way to block access to the database or terminate ongoing
> connections while I carry-out updates or backups?
>
> Thanks in advance for your reply
You could update pg_hba.conf and restart the database server.
Are you sure you want to do that though? You can do consistant backups
while the database is being updated by other people. And people will see
a consistant view of the database if you do your updates properly.