스틸아이에서 장애로 인해서 PPAS 리소스에 대해서 명령어나 관리자에 의해서 Fail-Over 될 때에는 동작하지 않지만, 장애로 인해서 Fail-Over 가 되면 아래 처럼 Template1 테이블에 쿼리를 날려서 해당 쿼리가 정상적으로 피드백이 되야지만 ISP 로 인지하여 정상 으로 처리를 합니다.
2015-08-05 09:37:16 KST @/ (8591)LOG: record with zero length at 0/2357E50
2015-08-05 09:37:16 KST @/ (8591)LOG: redo is not required
2015-08-05 09:37:16 KST @/ (8576)LOG: database system is ready to accept connections
2015-08-05 09:37:16 KST @/ (8595)LOG: autovacuum launcher started
2015-08-05 09:37:17 KST steel_live@[local]/template1 (8646)LOG: statement: SELECT n.nspname as "Schema",
c.relname as "Name",
CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' WHEN 'f' THEN 'foreign table' END as "Type",
pg_catalog.pg_get_userbyid(c.relowner) as "Owner"
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r','v','m','S','s','f','')
AND n.nspname !~ '^pg_toast'
AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;
2015-08-05 09:37:17 KST steel_live@[local]/template1 (8646)LOG: QUERY STATISTICS
2015-08-05 09:37:17 KST steel_live@[local]/template1 (8646)DETAIL: ! system usage stats:
! 0.029042 elapsed 0.004999 user 0.006000 system sec
! [0.008998 user 0.012998 sys total]
! 1664/0 [3312/312] filesystem blocks in/out
! 0/699 [0/1637] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 46/55 [72/92] voluntary/involuntary context switches
2015-08-05 09:37:17 KST steel_live@[local]/template1 (8646)STATEMENT: SELECT n.nspname as "Schema",
c.relname as "Name",
CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' WHEN 'f' THEN 'foreign table' END as "Type",
pg_catalog.pg_get_userbyid(c.relowner) as "Owner"
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r','v','m','S','s','f','')
AND n.nspname !~ '^pg_toast'
AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;
|
