Re: ERROR: database is being accessed by other users

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(at)fuhr(dot)org> 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
>