From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Can't Use DB As Template - accessed by other users error |
Date: | 2005-05-03 19:35:14 |
Message-ID: | 20050503193515.57777.qmail@web52406.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | operationsengineer1 | 2005-05-03 19:44:01 | Re: Foreign Key Problem |
Previous Message | Tim Goodaire | 2005-05-03 18:47:42 | Re: Can't Use DB As Template - accessed by other users error |