°Ô½Ã¹° 32°Ç
   
[½ºÆ¿¾ÆÀÌ] Àýü½Ã Template1 ¿¡ ½ºÆ¿¾ÆÀÌ°¡ ³¯¸®´Â ·Î±× (ÀǽÉ)
±Û¾´ÀÌ : ÃÖÀå¼· ³¯Â¥ : 2015-08-05 (¼ö) 09:39 Á¶È¸ : 1299
½ºÆ¿¾ÆÀÌ¿¡¼­ Àå¾Ö·Î ÀÎÇؼ­ 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;


À̸§ Æнº¿öµå
ºñ¹Ð±Û (üũÇÏ¸é ±Û¾´À̸¸ ³»¿ëÀ» È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.)
¿ÞÂÊÀÇ ±ÛÀÚ¸¦ ÀÔ·ÂÇϼ¼¿ä.
   

miwit.com sir.co.kr DNS Powered by DNSEver.com DNS Powered by DNSEver.com