Re: Can't Use DB As Template - accessed by other users error

Take a look at pg_stat_activity for connections to your db database. If
there are connections to "db", then you can't use it as a template for
your new database. If you get rid of these connections, you'll be able
to use db as a template for your new database.


Tim

On Tue, May 03, 2005 at 10:17:49AM -0700, operationsengineer1@yahoo.com wrote:
> since i'm having very strange problems with my
> database, i want to create a new db and use the
> problem db as a template.  this allows me to keep th
> eproblem db in an unaltered state in case someone
> needs to review it.
>
> problem is, i get an error message:
>
> "ERROR: source database "db" is being accessed by
> other users".
>
> i'm stuck.  can anyone help?
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>