Thank you, Shoaib.
Tena
On 11/9/10 6:26 PM, "Shoaib Mir" wrote:
On Wed, Nov 10, 2010 at 1:17 PM, Tena Sakai wrote:
Can somebody please tell me how I find who it is using the
x database?
select * from pg_stat_activity where datname = '';
Thank you, Sam.
Tena
On 11/9/10 6:25 PM, "Samuel Stearns" wrote:
Psql template1
Select * from pg_stat_activity;
Sam
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Tena Sakai
Sent: Wednesday, 10 November 2010 12:48 PM
To: pgsql-admin@postgresq
On Wed, Nov 10, 2010 at 1:17 PM, Tena Sakai wrote:
>
> Can somebody please tell me how I find who it is using the
> x database?
>
>
select * from pg_stat_activity where datname = '';
--
Shoaib Mir
http://shoaibmir.wordpress.com/
Psql template1
Select * from pg_stat_activity;
Sam
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Tena Sakai
Sent: Wednesday, 10 November 2010 12:48 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] I want to find out who is using a database
Hi E
Hi Everybody,
I want to drop a database and recreate it from a backup file.
But when I issue a dropdb command it wouldn’t let me do
so. It tells me: database x is being accessed by other
users.
Can somebody please tell me how I find who it is using the
x database?
Thank you.
Regards,
Hi All,
I 'm testing a HA solution for a PG version 9.01 database configured
using DBRD for pg_xlog directory and user data /table space
partitions.( block disk changes are copied from master to slave )
the archive mode option is off for both master and slaver node, when I
power off master
Michael,
Hello - and welcome to PostgreSQL (you're already on the right track!)
- Original Message -
From: "Michael O'Donnell"
To: pgsql-admin@postgresql.org
Sent: Tuesday, November 9, 2010 2:21:35 PM
Subject: [ADMIN] PostgreSQL Windows 8.4 tablespaces on remote servers
I a
I am a relatively new user of PostgreSQL and I would like to create a
tablespace on a remote 2008 standard x86 server. I am using a 2008 x64 R2
server to host the PostgreSQL service. The host is a VM and the NTFS is
not.
I am able to create tablespaces on the Postgres server in various places.
Hi Everybody,
I am experimenting with Postgres 9.0 64bit on windows 2008 R2 server (64bit).
I am having trouble creating a tablespace, I have a very strong suspicion that
my problems are windows specific, but I ran out of ideas of what else to try.
I create a folder under the PostgreSQL\data fold
