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

사용자

ID:
PW:

INDEX
01.게시판
게시판 [69]
02.File Book
File 자료실 [95]
Site Link [18]
개인폴더 [195]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2917]
PostgreSQL [103]
기타정보 [151]
운영체제 [584]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

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

 회원가입

pg_ctl start $PGDATA/pg_log/ 한글/영어 메세지 [ $PGDATA/postgresql.conf lc_messages ]
최길호 [LIST]   2021-10-29 18:11:13, 조회 : 205


-bash-4.1$ export LANG=ko_KR.euckr
-bash-4.1$ pg_ctl start
2021-10-29 08:48:30.177 GMT  32341 치명적오류:  "/var/lib/pgsql/data" 데이터 디렉터리 액세스 권한이 잘못 되었습니다
2021-10-29 08:48:30.177 GMT  32341 상세정보:  액세스 권한은 u=rwx (0700) 값이어야 합니다.
서버를 시작합니다

-bash-4.1$ chmod 700 /var/lib/pgsql/data
-bash-4.1$ pg_ctl start
server starting
-bash-4.1$

tail -20 /var/lib/pgsql/data/pg_log/postgresql-Fri.log
2021-10-29 18:05:14.122 KST  397 ??:  ?????? ???? ?????? ?????; ??? ????: 2021-10-29 12:57:26 KST
2021-10-29 18:05:14.123 KST  397 ??:  creating missing WAL directory "pg_xlog/archive_status"
2021-10-29 18:05:14.130 KST  397 ??:  "pg_xlog/00000001000001370000008C" ??? ?? ?? (???? 311, ???? 140): ENOENT
2021-10-29 18:05:14.130 KST  397 ??:  ??? primary checkpoint ???
2021-10-29 18:05:14.130 KST  397 ??:  "pg_xlog/00000001000001370000008C" ??? ?? ?? (???? 311, ???? 140): ENOENT
2021-10-29 18:05:14.130 KST  397 ??:  ??? secondary checkpoint ???
2021-10-29 18:05:14.130 KST  397 ??:  ????? ???? ??? ??? ?? ? ??
2021-10-29 18:05:25.249 KST  395 ??:  ?? ???? (PID 397) was terminated by signal 6: Aborted
2021-10-29 18:05:25.249 KST  395 ??:  ?? ???? ?? ??? ?? ??? ?? ?????
export LANG=ko_KR.euckr
pg_ctl start
2021-10-29 18:11:02.743 KST  897 로그:  데이터베이스 시스템이 비정상적으로 종료되었음; 마지막 운영시간: 2021-10-29 12:57:26 KST
2021-10-29 18:11:02.743 KST  897 로그:  "pg_xlog/00000001000001370000008C" 파일을 열기 실패 (로그파일 311, 세그먼트 140): 그런 파일이나 디렉터리가 없습니다
2021-10-29 18:11:02.743 KST  897 로그:  잘못된 primary checkpoint 레코드
2021-10-29 18:11:02.743 KST  897 로그:  "pg_xlog/00000001000001370000008C" 파일을 열기 실패 (로그파일 311, 세그먼트 140): 그런 파일이나 디렉터리가 없습니다
2021-10-29 18:11:02.743 KST  897 로그:  잘못된 secondary checkpoint 레코드
2021-10-29 18:11:02.744 KST  897 손상:  체크포인트 레코드의 위치를 바르게 잡을 수 없음

grep lc $PGDATA/postgresql.conf
###lc_messages = 'ko_KR.UTF-8'             # locale for system error message strings
lc_messages = 'en_US.UTF-8'
lc_monetary = 'ko_KR.UTF-8'             # locale for monetary formatting
lc_numeric = 'ko_KR.UTF-8'              # locale for number formatting
lc_time = 'ko_KR.UTF-8'                 # locale for time formatting

export LANG=C
pg_ctl start

2021-10-29 20:14:38.944 KST  5160 LOG:  database system was interrupted; last known up at 2021-10-29 12:57:26 KST
2021-10-29 20:14:38.944 KST  5160 LOG:  could not open file "pg_xlog/00000001000001370000008C" (log file 311, segment 140): No such file or directory
2021-10-29 20:14:38.944 KST  5160 LOG:  invalid primary checkpoint record
2021-10-29 20:14:38.944 KST  5160 LOG:  could not open file "pg_xlog/00000001000001370000008C" (log file 311, segment 140): No such file or directory
2021-10-29 20:14:38.945 KST  5160 LOG:  invalid secondary checkpoint record
2021-10-29 20:14:38.945 KST  5160 PANIC:  could not locate a valid checkpoint record
2021-10-29 20:14:49.731 KST  5158 LOG:  startup process (PID 5160) was terminated by signal 6: Aborted
2021-10-29 20:14:49.731 KST  5158 LOG:  aborting startup due to startup process failure

cp /backup/arch/00000001000001370000008C $PGDATA/pg_xlog/
pg_ctl start

2021-10-29 21:34:19.955 KST  7102 LOG:  database system was interrupted; last known up at 2021-10-29 12:57:26 KST
2021-10-29 21:34:19.955 KST  7102 LOG:  database system was not properly shut down; automatic recovery in progress
2021-10-29 21:34:19.979 KST  7102 LOG:  redo starts at 137/8CE73BB0
2021-10-29 21:34:19.987 KST  7102 LOG:  record with zero length at 137/8CE8CE88
2021-10-29 21:34:19.987 KST  7102 LOG:  redo done at 137/8CE8CE58
2021-10-29 21:34:20.004 KST  7102 LOG:  last completed transaction was at log time 2021-10-29 13:01:31.141194+09
2021-10-29 21:34:20.062 KST  7099 LOG:  database system is ready to accept connections
2021-10-29 21:34:20.063 KST  7105 LOG:  autovacuum launcher started
3.239.112.140


  LIST

제목 작성자 작성일 조회
Admin  odbc_fdw test    최길호 2021/11/22 139
Admin  ERROR: cross-database references are not implemented / postgres_fdw / psql dblink    최길호 2021/11/15 185
Admin  CREATE EXTENSION postgres_fdw; [ source install ]    최길호 2021/11/15 292
Admin  psql [ 8.4.20 , 8.4.22 ] 여러 Version 운영, upgrade 8.4.20 to 8.4.22 [ 뒤 Version 다르면 그냥 시작 ]    최길호 2021/11/12 117
Admin  source make install [ 8 ~ 14 ]    최길호 2021/11/11 171
Admin  psql odbc make install    최길호 2021/11/09 135
Admin  oracle to psql dblink    최길호 2021/11/09 155
Admin  /usr/bin/initdb -D /var/lib/pgsql/test [ Instance 추가 ]    최길호 2021/11/05 107
Troubleshoot  connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?    최길호 2021/11/04 168
Troubleshoot  ERROR: current transaction is aborted, commands ignored until end of transaction block; [ postgresql-odbc upgrade ]    최길호 2021/11/04 183
Troubleshoot  pg_ctl start $PGDATA/pg_log/ 한글/영어 메세지 [ $PGDATA/postgresql.conf lc_messages ]    최길호 2021/10/29 205
Admin  pg_dumpall pg_upgrade    최길호 2021/10/21 149
Admin  통계정보    최길호 2021/10/21 124
Admin  pg_dump / pg_restore[ psql (8.4.20) to psql (14.0) ]    최길호 2021/10/20 170
Admin  PostgreSQL 14 / pgadmin Install [ lc_collate 'ko_KR.UTF-8' order by 정상 ]    최길호 2021/10/17 235
Admin  psql dblink to oracle [ odbc test ] 한글    최길호 2021/04/19 2499
Admin  postgres , enterprisedb(EDB) / [ ERROR: type "number" does not exist ]    최길호 2020/09/01 273
Admin  install postgresql on docker centos:7    최길호 2020/08/31 382
Troubleshoot  psql: server closed the connection unexpectedly [ vi $PGDATA/postgresql.conf / listen_addresses='*' ]    최길호 2020/08/31 413

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

Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
11/23
[ORACLE]
acfsutil size: ACFS-03006: sma....
by 최길호
11/07
[운영체제]
Job for sshd.service failed be....
by 최길호
11/04
[ORACLE]
jsp error 위치 확인 [ debug ].
by 최길호