반응형
/****************************************************************************************************************
-- Title : [PGS9.2] How to use pg_resetxlog
-- Reference : postgresql.org
-- Key word : postgresql 백업 복구 backup recovery 로그 리셋 로그리셋 log reset 리셋로그 reset log
****************************************************************************************************************/

-- Suppose we lost all of the xlog files, but have complete data files.

-- shutdown service
    $ pg_ctl stop -m immediate

-- clear xlog files
    $ rm -rf $PGDATA/pg_xlog/* 

-- execute reset log
    $ pg_resetxlog -f /home/postgres/pgsql/data

-- startup service
    $ pg_ctl start 


반응형

+ Recent posts