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 Károly Gabriel R&D Manager Expert Software Group 410066 Oradea, Al. Gojdu 2 Tel. +4 0259 230 776 http://www.expert-software.ro ""Nagy Karoly"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] 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 Károly Gabriel R&D Manager Expert Software Group 410066 Oradea, Al. Gojdu 2 Tel. +4 0259 230 776 http://www.expert-software.ro ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
