Hi, Michael You are right, the script was trying to drop the database and the error makes sense to me now. Thank you! On 8/24/05, Michael Fuhr <mike@xxxxxxxx> wrote: > On Wed, Aug 24, 2005 at 10:10:55AM +0800, wolverine my wrote: > > I got the following psql's error when executing a script, > > ERROR: database "test" is being accessed by other users > > What does the script do? Based on the error message I'd guess that > you're trying to drop or rename the database. > > > To solve this, I have to disconnect the database connection from the > > pgAdmin III. > > > > May I know how can I configure the database to allow multiple user access? > > Databases do allow multiple user access, but PostgreSQL won't allow > you to drop or rename a database if somebody else is using it. > > -- > Michael Fuhr > ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org