http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [71]
02.File Book
File 자료실 [95]
Site Link [17]
개인폴더 [201]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [43]
DB2 [79]
ORACLE [2973]
PSQL [133]
기타정보 [155]
운영체제 [600]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

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

 회원가입

$PGDATA/pg_wal/00000002.history 없는경우 [ ERROR: could not open file "pg_wal/00000002.history": ENOENT ]
최길호 [LIST]   2023-02-02 17:17:30, 조회 : 17


pg_basebackup -D /home/postgres/backup
pg_basebackup: error: could not send replication command "TIMELINE_HISTORY": ERROR:  could not open file "pg_wal/00000002.history": ENOENT
pg_basebackup: error: background process terminated unexpectedly
pg_basebackup: removing contents of data directory "/home/postgres/backup"

tail $PGDATA/log/postgresql-`date +%a`.log
2023-02-02 16:42:49.458 KST [38171] ERROR:  could not open file "pg_wal/00000002.history": ENOENT
2023-02-02 16:42:49.458 KST [38171] STATEMENT:  TIMELINE_HISTORY 2
2023-02-02 16:42:49.476 KST [38167] LOG:  could not send data to client: EPIPE
2023-02-02 16:42:49.476 KST [38167] STATEMENT:  BASE_BACKUP ( LABEL 'pg_basebackup base backup',  PROGRESS,  WAIT 0,  MANIFEST 'yes',  TARGET 'client')
2023-02-02 16:42:49.476 KST [38167] FATAL:  connection to client lost
2023-02-02 16:42:49.476 KST [38167] STATEMENT:  BASE_BACKUP ( LABEL 'pg_basebackup base backup',  PROGRESS,  WAIT 0,  MANIFEST 'yes',  TARGET 'client')

cat > $PGDATA/pg_wal/00000002.history
1 2

pg_basebackup -D /home/postgres/backup
pg_basebackup: error: backup failed: FATAL:  syntax error in history file: 1 2
HINT:  Expected a write-ahead log switchpoint location.
pg_basebackup: removing contents of data directory "/home/postgres/backup"

rm $PGDATA/pg_wal/00000002.history

postgres=# select pg_switch_wal();
pg_switch_wal
---------------
4/24005F0
(1 row)

cat > $PGDATA/pg_wal/00000002.history
0 0/0000000

pg_basebackup -D /home/postgres/backup
[ 정상 백업 ]
cat /home/postgres/backup/backup_label
START WAL LOCATION: 4/6C00028 (file 00000002000000040000001B)
CHECKPOINT LOCATION: 4/6C00060
BACKUP METHOD: streamed
BACKUP FROM: primary
START TIME: 2023-02-02 17:10:02 KST
LABEL: pg_basebackup base backup
START TIMELINE: 2


이후 복구 잘되는지 해봐야 한다.
44.192.254.173


  LIST

제목 작성자 작성일 조회
Admin  psql 10.7 oracle dblink [ oracle_fdw db link ]    최길호 2023/07/25 14
Admin  HA 복구 test    최길호 2023/03/03 23
Admin  log: COPY public.xxxx (xxx, xxx, xxx) TO stdout; / pg_dump 백업시 발생    최길호 2023/03/03 12
Admin  requested timeline x is not a child of this server's history    최길호 2023/03/02 13
Admin  recovery_target_action / archive log 받아서 계속 복구    최길호 2023/02/28 22
Admin  recovery_target_action = 'pause' / select pg_wal_replay_pause(); / select pg_get_wal_replay_pause_state();    최길호 2023/02/27 6
Admin  memory buffer cache    최길호 2023/02/06 10
Admin  active session, pid, lock sql , kill pid / pg_terminate_backend    최길호 2023/02/06 50
Admin  psql HA    최길호 2023/02/05 36
Admin  pg_ctl start -D . | postmaster.pid | /tmp/.s.PGSQL.5432 |    최길호 2023/02/03 26
Admin  pg_waldump    최길호 2023/02/03 7
Troubleshoot  $PGDATA/pg_wal/00000002.history 없는경우 [ ERROR: could not open file "pg_wal/00000002.history": ENOENT ]    최길호 2023/02/02 17
Admin  pg_basebackup 복구 test lv:9   최길호 2023/02/02 21
Admin  shmem_exit(0): 0 before_shmem_exit callbacks to make [ 로그 기록용 ]    최길호 2023/02/01 32
Troubleshoot  LOG: invalid resource manager ID in primary checkpoint record    최길호 2023/02/01 21
Admin  pg_restore [ 다른 계정, 다른 DB, sql 파일로 저장 ]    최길호 2023/01/30 13
Admin  pg_basebackup pg_dump pg_dumpall backup script    최길호 2023/01/30 66
Admin  session 정보    최길호 2023/01/27 18
Admin  limit fetch offset rows    최길호 2023/01/21 10

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

Copyright 1999-2023 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
09/27
[ORACLE]
auto compile [ dba_objects LAS....
by 최길호
09/25
[ORACLE]
verify_queryable_inventory ret....
by 최길호
09/11
[운영체제]
ntfy.sh / 푸시 알림 보내기.
by 최길호