Re: [GENERAL] Locking a database

2001-04-30 Thread Tom Lane
"Jose Norberto" <[EMAIL PROTECTED]> writes: > I want to make a pg_dump of a database, but I must be sure that no one is > logged in. Why? pg_dump will return a consistent state of the database even if other transactions are proceeding meanwhile. regards, tom lane -

Re: [GENERAL] Locking a database

2001-04-30 Thread Michelle Murrain
On Monday 30 April 2001 02:37 pm, Jose Norberto wrote: > Hello all! > I want to make a pg_dump of a database, but I must be sure that no one is > logged in. Which is the best way to do it? > Thanks in advance Change the permissions in the pg_hba.conf file (/usr/local/pgsql/data/pg_hba.conf is th

[GENERAL] Locking a database

2001-04-30 Thread Jose Norberto
Hello all! I want to make a pg_dump of a database, but I must be sure that no one is logged in. Which is the best way to do it? Thanks in advance _ Get your FREE download of MSN Explorer at http://explorer.msn.com -