[ The imperialist Japanese military must officially acknowledge and apologize for the coercion of young women into sexual slaves. / 幼い女性を性の奴隷にした帝國主義日本軍の?制性を公式に認め、謝罪しなければならない. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [71]
02.File Book
File 자료실 [96]
Site Link [14]
개인폴더 [201]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [25]
MySQL [43]
DB2 [79]
ORACLE [3054]
PSQL [135]
CUBRID [5]
기타정보 [158]
운영체제 [607]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: PostgreSQL

 회원가입

requested timeline x is not a child of this server's history
최길호 [LIST]   2023-03-02 12:09:10, 조회 : 21


테스트 과정에서 xx.history 파일 발생, HA start 에러

pg_ctl start -D .
----------------------------
2023-03-02 11:54:58.298 KST [25244] LOG:  listening on IPv4 address "0.0.0.0", port 5433
2023-03-02 11:54:58.308 KST [25244] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5433"
2023-03-02 11:54:58.327 KST [25248] LOG:  database system was shut down in recovery at 2023-03-02 11:05:48 KST
2023-03-02 11:54:58.336 KST [25248] LOG:  restored log file "00000003.history" from archive
2023-03-02 11:54:58.345 KST [25248] LOG:  restored log file "00000004.history" from archive
2023-03-02 11:54:58.351 KST [25248] LOG:  restored log file "00000005.history" from archive
sh: /home/postgres/arch/00000006.history.gz: 그런 파일이나 디렉터리가 없습니다
2023-03-02 11:54:58.355 KST [25248] LOG:  entering standby mode
2023-03-02 11:54:58.361 KST [25248] LOG:  restored log file "00000005.history" from archive
sh: /home/postgres/arch/000000050000000900000250.gz: 그런 파일이나 디렉터리가 없습니다
sh: /home/postgres/arch/000000020000000900000250.gz: 그런 파일이나 디렉터리가 없습니다
2023-03-02 11:54:58.379 KST [25248] FATAL:  requested timeline 5 is not a child of this server's history
2023-03-02 11:54:58.379 KST [25248] DETAIL:  Latest checkpoint is at 9/94000028 on timeline 2, but in the history of the requested timeline, the server forked off from that timeline at 9/92C00178.
2023-03-02 11:54:58.380 KST [25244] LOG:  startup process (PID 25248) exited with exit code 1
2023-03-02 11:54:58.380 KST [25244] LOG:  aborting startup due to startup process failure
2023-03-02 11:54:58.381 KST [25244] LOG:  database system is shut down

ls /home/postgres/arch/0000000[3-9]*
00000003.history.gz
000000030000000900000246.gz
00000004.history.gz
000000040000000900000246.gz
00000005.history.gz
00000005000000090000024B.gz

rm -rf /home/postgres/arch/0000000[3-9]*

pg_ctl start -D .
----------------------------
2023-03-02 11:57:40.214 KST [25573] LOG:  listening on IPv4 address "0.0.0.0", port 5433
2023-03-02 11:57:40.230 KST [25573] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5433"
2023-03-02 11:57:40.252 KST [25577] LOG:  database system was shut down in recovery at 2023-03-02 11:05:48 KST
sh: /home/postgres/arch/00000003.history.gz: 그런 파일이나 디렉터리가 없습니다
2023-03-02 11:57:40.257 KST [25577] LOG:  entering standby mode
sh: /home/postgres/arch/00000002.history.gz: 그런 파일이나 디렉터리가 없습니다
sh: /home/postgres/arch/000000020000000900000250.gz: 그런 파일이나 디렉터리가 없습니다
2023-03-02 11:57:40.279 KST [25577] LOG:  consistent recovery state reached at 9/940000A0
2023-03-02 11:57:40.279 KST [25577] LOG:  invalid record length at 9/940000A0: wanted 24, got 0
2023-03-02 11:57:40.279 KST [25573] LOG:  database system is ready to accept read-only connections
2023-03-02 11:57:40.293 KST [25584] LOG:  started streaming WAL from primary at 9/94000000 on timeline 2
2023-03-02 11:57:40.294 KST [25577] LOG:  redo starts at 9/940000A0

$ psql -p 5433
psql (15.1)
Type "help" for help.
postgres=#

data sync 메세지
----------------------------
2023-03-02 12:02:40.354 KST [25575] LOG:  restartpoint starting: time
2023-03-02 12:02:40.817 KST [25575] LOG:  restartpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 2 recycled; write=0.420 s, sync=0.010 s, total=0.464 s; sync files=5, longest=0.009 s, average=0.002 s; distance=8192 kB, estimate=8192 kB
2023-03-02 12:02:40.817 KST [25575] LOG:  recovery restart point at 9/94800028
2023-03-02 12:02:40.817 KST [25575] DETAIL:  Last completed transaction was at log time 2023-03-02 12:02:33.775177+09.

3.239.9.151


  LIST

제목 작성자 작성일 조회
Admin  pg_backup_start / pg_backup_stop / psql 세션 유지 / WARNING: aborting backup due to backend exiting before pg_backup_stop was called    최길호 2023/12/21 25
Admin  psql 10.7 oracle dblink [ oracle_fdw db link ]    최길호 2023/07/25 29
Admin  HA 복구 test    최길호 2023/03/03 45
Admin  log: COPY public.xxxx (xxx, xxx, xxx) TO stdout; / pg_dump 백업시 발생    최길호 2023/03/03 23
Admin  requested timeline x is not a child of this server's history    최길호 2023/03/02 21
Admin  recovery_target_action / archive log 받아서 계속 복구    최길호 2023/02/28 34
Admin  recovery_target_action = 'pause' / select pg_wal_replay_pause(); / select pg_get_wal_replay_pause_state();    최길호 2023/02/27 14
Admin  memory buffer cache    최길호 2023/02/06 19
Admin  active session, pid, lock sql , kill pid / pg_terminate_backend    최길호 2023/02/06 77
Admin  psql HA    최길호 2023/02/05 62
Admin  pg_ctl start -D . | postmaster.pid | /tmp/.s.PGSQL.5432 |    최길호 2023/02/03 39
Admin  pg_waldump    최길호 2023/02/03 18
Troubleshoot  $PGDATA/pg_wal/00000002.history 없는경우 [ ERROR: could not open file "pg_wal/00000002.history": ENOENT ]    최길호 2023/02/02 33
Admin  shmem_exit(0): 0 before_shmem_exit callbacks to make [ 로그 기록용 ]    최길호 2023/02/01 58
Troubleshoot  LOG: invalid resource manager ID in primary checkpoint record    최길호 2023/02/01 33
Admin  pg_restore [ 다른 계정, 다른 DB, sql 파일로 저장 ]    최길호 2023/01/30 26
Admin  pg_basebackup pg_dump pg_dumpall backup script    최길호 2023/01/30 122
Admin  session 정보    최길호 2023/01/27 30

    목록보기   다음페이지 1 [2][3][4][5][6][7]
       

Copyright 1999-2024 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
03/04
[기타정보]
아두이노 wifi web test.
by 최길호
03/01
[기타정보]
아두이노 스마트하우스 V2.
by 최길호
02/28
[ORACLE]
plsql run sql from column / 테....
by 최길호