티스토리 뷰

DB/PostgreSQL

postgresql 停止手順

swhwang 2016. 5. 4. 00:54
postgresql 정지수순

atgames01

gp_db31(master): /etc/rc.d/init.d/gp_postgres stop
gp_db36(slave):/etc/rc.d/init.d/gp_postgres stop

atgames02,03
gp_db37(master):/etc/rc.d/init.d/gp_postgres stop
gp_db32(slave):/etc/rc.d/init.d/gp_postgres stop

atgames07
gp_db33(master):/etc/rc.d/init.d/gp_postgres_atgames12
gp_db38(slave):/etc/rc.d/init.d/gp_postgres_atgames12

atgames09,selfydb,manage01
gp_db34(master):/etc/rc.d/init.d/gp_postgres stop
gp_db39(slave):/etc/rc.d/init.d/gp_postgres stop

atgames04,05,06,08,10
gp_db40(master):/etc/rc.d/init.d/gp_postgres stop
gp_db35(slave):/etc/rc.d/init.d/gp_postgres stop



atgames12
gp_db33(master):/etc/rc.d/init.d/gp_postgres stop
gp_db38(slave):/etc/rc.d/init.d/gp_postgres stop
gp_db41(slave):/etc/rc.d/init.d/gp_postgres stop
gp:db42(slave):/etc/rc.d/init.d/gp_postgres stop


mail01

gp_mail2のheatbeatから止める
 
gp_mail1(master):1./etc/rc.d/init.d/heartbeat stop
                           2./etc/rc.d/init.d/gp_postgres stop
  
gp_mail2(slave):1./etc/rc.d/init.d/heartbeat stop
                        2.  /etc/rc.d/init.d/gp_postgres stop


backup saerver (5時前に止めてほしい)

gp_db4(slave):
/etc/rc.d/init.d/gp_postgres9_atgames01
/etc/rc.d/init.d/gp_postgres9_atgames0203
/etc/rc.d/init.d/gp_postgres9_selfydb



gp_db21(slave):
/etc/rc.d/init.d/gp_postgres_atgames12 stop











































(














'DB > PostgreSQL' 카테고리의 다른 글

새로운 DB를 구축  (0) 2016.05.04
slony전용 클러스터의 작성  (0) 2016.05.04
wget http://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CD  (0) 2016.05.04
PostgreSQL 백업 쉘  (0) 2016.05.04
tmc_db01 backup 순서  (0) 2016.05.04
댓글
공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
링크
TAG
more
«   2026/03   »
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31
글 보관함