The users are accessing the database using PhpPgAdmin. I thought that
this might happen if they closed the browser without closing logging
off. I know that if you do that the browser will return to where you
left it, when you open it again. I tried that with my own database,
and I
I'm using psql from the command line. Doing an ALTER DATABASE command.
Carol
On Mar 3, 2009, at 2:36 AM, Julius Tuskenis wrote:
Hello, Carol.
how exactly are you trying to change the DB name? In console or
using some management tool like pgAdmin?
Carol Walter rašė:
Periodically, my
That's interesting and is probably the answer to my question as to why
this happens. Thanks, Nick. What it doesn't explain is why I was
able to connect to a test database using PhpPgAdmin and close the
browser, without logging out, and I was able to rename my test
database. I couldn't
This has happened or is happening to me again, only this time, it's a
database that I just created. I restored another database into a test
database. One of the tables is empty. I want to drop the test
database and create a new one. When I try to drop the test database,
I get this
Have you got any copies of psql or tools like pgadmin open. I've been
caught out by this. try
select * from pg_stat_activity
it should tell you what connections are open on the table (look at the
datname column)
Carol Walter wrote:
This has happened or is happening to me again, only this
Carol Walter walt...@indiana.edu writes:
This has happened or is happening to me again, only this time, it's a
database that I just created. I restored another database into a test
database. One of the tables is empty. I want to drop the test
database and create a new one. When I try
On Wed, Mar 4, 2009 at 2:40 PM, Carol Walter walt...@indiana.edu wrote:
This has happened or is happening to me again, only this time, it's a
database that I just created. I restored another database into a test
database. One of the tables is empty. I want to drop the test database and
I had forgotten that I had used Aqua Data Studio to draw ERD's for
this test database. Even though, I closed it, it still had the
database open. When I reopened it, and did a disconnect, if allowed
me to drop the database.
Thanks,
Carol
On Mar 4, 2009, at 4:45 PM, John Lister wrote:
On Mar 4, 2009, at 4:53 PM, Scott Marlowe wrote:
On Wed, Mar 4, 2009 at 2:40 PM, Carol Walter walt...@indiana.edu
wrote:
This has happened or is happening to me again, only this time, it's a
database that I just created. I restored another database into a
test
database. One of the tables
Scott Marlowe scott.marl...@gmail.com writes:
On Wed, Mar 4, 2009 at 2:40 PM, Carol Walter walt...@indiana.edu wrote:
This database is one that I created just a few hours ago just to test some
things myself. There can be no one in it except me.
Correct me if I'm wrong, but isn't that enough
Periodically, my databases will give me a message that says that
someone is using the database when it appears that no one is. What
causes this? What can I do about it?
Thanks,
Carol
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
Carol Walter walt...@indiana.edu writes:
Periodically, my databases will give me a message that says that
someone is using the database when it appears that no one is. What
causes this? What can I do about it?
What's the context exactly?
In some cases you can get this type of message
Hi,
try this:
SELECT * FROM pg_stat_activity;
Maybe it will show you who is using it..
--
Lukas
UAB nSoft
http://www.nsoft.lt
Lukas at nsoft.lt
+370 655 10 655
Periodically, my databases will give me a message that says that
someone is using the database when it appears that no one is.
ps -ef | grep postgres
Date: Mon, 2 Mar 2009 22:35:23 +0200
Subject: Re: [ADMIN] Database in use?
From: lu...@fmf.vtu.lt
To: pgsql-admin@postgresql.org
Hi,
try this:
SELECT * FROM pg_stat_activity;
Maybe it will show you who is using it..
--
Lukas
UAB nSoft
http
Well, most recently I had created a new database using UTF8 encoding
and I had restored data to it, that had been in a database using
SQL_ASCII. I wanted to rename the original database. When I tried to
rename it, I got the message that I couldn't do it because the
database was in use.
Carol Walter walt...@indiana.edu writes:
Well, most recently I had created a new database using UTF8 encoding
and I had restored data to it, that had been in a database using
SQL_ASCII. I wanted to rename the original database. When I tried to
rename it, I got the message that I
I'm not sure I understand. If there is a lag time between when
someone exits the database and when the database knows that no one
is still in it, then that shouldn't be the problem here. I tried a
number of time over the course of 24 hours to rename the database and
it always reported
Carol Walter walt...@indiana.edu writes:
I'm not sure I understand. If there is a lag time between when
someone exits the database and when the database knows that no one
is still in it, then that shouldn't be the problem here. I tried a
number of time over the course of 24 hours to
Hello, Carol.
how exactly are you trying to change the DB name? In console or using
some management tool like pgAdmin?
Carol Walter rašė:
Periodically, my databases will give me a message that says that
someone is using the database when it appears that no one is. What
causes this? What
19 matches
Mail list logo