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 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq