SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 05:38 AM
| ||||
| ||||
 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? ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match      |
|
04-09-2008, 05:38 AM
| |||
| |||
| Re: ERROR: database is being accessed by other users 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 |
|
04-09-2008, 05:38 AM
| |||
| |||
| 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@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 > ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
|
04-09-2008, 05:38 AM
| ||||
| ||||
| Re: ERROR: database is being accessed by other users 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
Linear Mode
