Skip site navigation (1) Skip section navigation (2)

PostgreSQL is hanging up !?

From: Louie Kwan <lkwan(at)nuvo(dot)com>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: PostgreSQL is hanging up !?
Date: 2004-05-27 20:43:47
Message-ID: FB4FDC17A002D711BC0C009027DE84AF027F6DB1@EXCHANGE.nuvo.com (view raw or flat)
Thread:
Lists: pgsql-sql
I have created several domains at Postgresql and I am trying to create some
views on a domain "dcenter" using

create or replace view cw_nodir_v
as
select ...

However, my PostgreSQL hangs up.. on this domain only but not in other
domains... 

Don't want to reboot PQ, and methods I can find out the root causes and fix
the issues... and log I can look into..

Any help is appreciated. Thanks in advance.


	[root(at)sedna itm]# ps -ef | grep post
	postgres  2162     1  0 May19 ?        00:00:12 /usr/bin/postmaster
-i -p 5432
	postgres  2164  2162  0 May19 ?        00:00:02 postgres: stats
buffer process   
	postgres  2165  2164  0 May19 ?        00:00:05 postgres: stats
collector process   
	postgres  3016  2162  0 May19 ?        00:00:00 postgres: eoc_sim
eocdb 206.116.78.175 idle
	postgres  3018  2162  0 May19 ?        00:00:03 postgres: eoc_sim
eocdb 206.116.78.175 SELECT waiting
	postgres 14988  2162  0 15:42 ?        00:00:00 postgres: eoc_core
eocdb 206.116.78.128 SELECT waiting
	postgres 16129  2162 23 16:03 ?        00:05:26 postgres: dcenter
eocdb 206.116.78.50 SELECT
	postgres 16826  2162  0 16:17 ?        00:00:00 postgres: dcenter
eocdb 206.116.78.128 DROP VIEW waiting
	root     17269  3236  0 16:26 pts/3    00:00:00 grep post 


Louie Kwan
lkwan(at)nuvo(dot)com





pgsql-sql by date

Next:From: sadDate: 2004-05-28 09:29:35
Subject: type regclass casting
Previous:From: Jean-Luc LachanceDate: 2004-05-27 13:08:35
Subject: Re: Multitable uniqueness ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group