Thread: ERROR: database is being accessed by other users
Hi! I got the following psql's error when executing a script, ERROR: database "test" is being accessed by other users 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?
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
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@fuhr.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 >
On 8/23/05 10:10 PM, "wolverine my" <wolverine.my@gmail.com> wrote: > Hi! > > I got the following psql's error when executing a script, > ERROR: database "test" is being accessed by other users > > 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? What were you trying to do when you got this message? What version of postgres? What OS? Sean