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

tim,

i spent about 30 minutes searching for pg_stat
information (manual, online, newsgroups) and couldn't
find out how to use it.  i tried "select pg_stat"
while logged into my db in psql, but nothing printed
to the screen.

while i'm at it, i have no clue how to get rid of
connections, if any are eventually found to be
present.

--- Tim Goodaire <tgoodaire@linux.ca> wrote:
> 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