[GENERAL] Access more than one database from pgAdmin III

2005-08-29 Thread wolverine my
How can we access more than one database template1from pgAdmin III?   Currently in my pgAdmin III, I'm already accessing one database. When I tried to create another new database it says ERROR: database "template1" already exists.   May I know if we can actually connect to 2nd database? e.g. templa

Re: [GENERAL] ERROR: database is being accessed by other users

2005-08-23 Thread wolverine my
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 <[EMAIL PROTECTED]> wrote: > On Wed, Aug 24, 2005 at 10:10:55AM +0800, wolverine my wrote: > > I got the following psql's error whe

[GENERAL] ERROR: database is being accessed by other users

2005-08-23 Thread wolverine my
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? ---