From: | "Nagy Karoly" <nagykaroly(at)expert-software(dot)ro> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Manage PostgreSQL Connections |
Date: | 2003-08-18 17:20:44 |
Message-ID: | bhr1ta$1284$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you for the information.
> the easy way to do that is to create an alternate pg_hba.conf in the
> $PGDATA directory that only allows the postgresql superuser to attach and
> then restart postgresql with that pg_hba.conf in place.
By that you mean to have a pg_hba.conf file in $PGDATA directory named for
example pg_hba.conf.dump and when
I want to perform the backup/restore to rename it to pg_hba.conf and make a
/etc/init.d/postgresql reload?
and by doing that users will not lose their data between the dump and
restore?
I think by doing /etc/init.d/postgresql reload with the new pg_hba.conf
users will be cut of brutaly, or am I wrong?
Thank you again,
> On Thu, 14 Aug 2003, Nagy Karoly wrote:
>
> > Is there any way to close the connections of other users in PostgreSQL.
> > I wish to run an automatic pg_dump and pg_restore and I guess users must
be disconnected first.
> > Is that right?
>
> Actually, for a pg_dump, no, you don't need to disconnect people. pg_dump
> creates a single snapshot backup that is consistent across the database
> you are backing up (not the whole cluster of databases, just the one
> you're pointing pg_dump at at the moment.)
>
> It really depends on what you are doing. If you're gonna pg_dump / drop
> database / create database pg_restore it might be a good idea to
> disconnect people so they don't lost data between the dump and restore.
>
> the easy way to do that is to create an alternate pg_hba.conf in the
> $PGDATA directory that only allows the postgresql superuser to attach and
> then restart postgresql with that pg_hba.conf in place.
>
--
________________________
Nagy Kroly Gabriel
R&D Manager
Expert Software Group
410066 Oradea, Al. Gojdu 2
Tel. +4 0259 230 776
http://www.expert-software.ro
""Nagy Karoly"" <nagykaroly(at)expert-software(dot)ro> wrote in message
news:000801c3626c$cda8fd20$0301a8c0(at)karaszexpert(dot)(dot)(dot)
Is there any way to close the connections of other users in PostgreSQL.
I wish to run an automatic pg_dump and pg_restore and I guess users must be
disconnected first.
Is that right?
________________________
Nagy Kroly Gabriel
R&D Manager
Expert Software Group
410066 Oradea, Al. Gojdu 2
Tel. +4 0259 230 776
http://www.expert-software.ro
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-08-18 17:23:40 | Re: Cache lookup failed? |
Previous Message | Ed L. | 2003-08-18 17:17:20 | Re: dbmirror revisions |