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(at)linux(dot)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(at)yahoo(dot)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