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@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