From: | Michelle Murrain <mpm(at)norwottuck(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Locking a database |
Date: | 2001-04-30 18:44:53 |
Message-ID: | 0104301444530B.01196@chicago.murrain.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 the default placement)
The bottom of the file looks like:
# Put your actual configuration here
# ----------------------------------
# This default configuration allows any local user to connect as any
# PostgreSQL username, over either UNIX domain sockets or IP:
local all trust
host all 127.0.0.1 255.255.255.255 trust
# If you want to allow non-local connections, you will need to add more
# "host" records (and don't forget to start the postmaster with "-i"!).
# CAUTION: if you are on a multiple-user machine, the above default
# configuration is probably too liberal for you --- change it to use
# something other than "trust" authentication.
Michelle
--
------------
Michelle Murrain, Ph.D.
President
Norwottuck Technology Resources
mpm(at)norwottuck(dot)com
http://www.norwottuck.com
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas F. O'Connell | 2001-04-30 18:46:41 | Re: do functions cache views? |
Previous Message | Fred Ingham | 2001-04-30 18:40:32 | RE: PostgreSQL and mySQL database size question |