Skip site navigation (1) Skip section navigation (2)

Re: Wish for an option to close a DB

From: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
To:
Cc: pgadmin-support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Wish for an option to close a DB
Date: 2005-01-19 15:53:18
Message-ID: ED4E30DD9C43D5118DFB00508BBBA76EB16575@neptun.sonorys.at (view raw or flat)
Thread:
Lists: pgadmin-support
Thanks, I'll remember it and have a try.

> -----Original Message-----
> From: Alexander Borkowski [mailto:alexander(dot)borkowski(at)abri(dot)une(dot)edu(dot)au]
> Sent: Dienstag, 18. Jänner 2005 23:42
> To: KÖPFERL Robert
> Cc: pgadmin-support
> Subject: Re: [pgadmin-support] Wish for an option to close a DB
> 
> 
> Hello,
> 
> > we've got often the problem that we were working on a 
> database just to drop
> > it afrerwarts and recreate it from the current developement 
> schema. However
> > postgres denies to drop a DB until all sessions are closed. 
> Since we were
> > working on it and pgAdmin has no db-specific option (or did 
> we just oversee
> > it) to close a specific DB, we have to close the whole 
> connection. This is
> > bad.
> > I whish myself an option in the context menu to detach a db.
> 
> I second that wish. Here is what I found useful as a 
> workaround: If you 
> select the "Databases" item in the treeview and do a refresh (via 
> hitting F5 or from the context menu item), pgAdmin will close all 
> connections to that server _except_ for the one connection to the 
> initial database for that server, i.e. you only have to disconnect if 
> you drop the database listed as being the one pgAdmin connects to by 
> default when connecting to this particular server.
> 
> Cheers,
> 
> Alex
> 

pgadmin-support by date

Next:From: cathy.hemsleyDate: 2005-01-21 08:47:18
Subject: Re: Pgadmin 3 version 1.2.0 crashes on every connection attempt
Previous:From: christian.graefeDate: 2005-01-19 14:33:44
Subject: [Feature-Request] Pre-defined Select in SQL-Query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group