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

사용자

ID:
PW:

INDEX
01.게시판
게시판 [72]
02.File Book
File 자료실 [96]
Site Link [14]
개인폴더 [201]
03.Field Book
Altibase [19]
Tibero [31]
MS-SQL [32]
MySQL [47]
DB2 [79]
ORACLE [3205]
PSQL [143]
CUBRID [5]
기타정보 [194]
운영체제 [634]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

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

 회원가입

psql: server closed the connection unexpectedly [ vi $PGDATA/postgresql.conf / listen_addresses='*' ]
최길호 [LIST]   2020-08-31 22:48:10, 조회 : 552


[postgres@pgsql ~]$ psql -h 192.168.1.1 -p 5432 -U postgres
psql: server closed the connection unexpectedly [ 비정상 ]
        This probably means the server terminated abnormally
        before or while processing the request.
[postgres@pgsql ~]$

# telnet 192.168.1.1 5432
Trying 192.168.1.1...
Connected to 192.168.1.1.
Escape character is '^]'.
Connection closed by foreign host. [ 기다림없이 종료 비정상 ]
#

[postgres@pgsql ~]$ psql
psql (9.2.24)
Type "help" for help.
postgres=# show listen_addresses;
listen_addresses
------------------
localhost [ 기본값: localhost => *로 변경 ]
(1 row)

# 조치
$ grep listen_addresses $PGDATA/postgresql.conf
listen_addresses='*' # 조치
#listen_addresses = 'localhost'         # what IP address(es) to listen on;
$ pg_ctl stop/start

postgres=# show listen_addresses;
listen_addresses
------------------
*
(1 row)

[postgres@pgsql ~]$ psql -h 192.168.1.1 -p 5432 -U postgres
Password: [ 정상 ]

$ telnet 192.168.1.1 5432
Trying 192.168.1.1...
Connected to 192.168.1.1.
Escape character is '^]'.
[ 입력 대기 정상 ]
Connection closed by foreign host.
216.73.216.200


  LIST

제목 작성자 작성일 조회
Admin  write db log msg    최길호 2025/04/07 7
Admin  CentOS 5 설치 가능 psql 11.22 설치    최길호 2024/11/21 10
Admin  ERROR: permission denied: "RI_ConstraintTrigger_331308" is a system trigger / violates foreign key constraint    최길호 2024/10/28 22
Admin  날짜 숫자 date unix epoch    최길호 2024/09/02 12
Admin  pg_backup_start / pg_backup_stop / psql 세션 유지 / WARNING: aborting backup due to backend exiting before pg_backup_stop was called    최길호 2023/12/21 69
Admin  psql 10.7 oracle dblink [ oracle_fdw db link ]    최길호 2023/07/25 75
Admin  HA 복구 test    최길호 2023/03/03 1866
Admin  log: COPY public.xxxx (xxx, xxx, xxx) TO stdout; / pg_dump 백업시 발생    최길호 2023/03/03 51
Admin  requested timeline x is not a child of this server's history    최길호 2023/03/02 64
Admin  recovery_target_action / archive log 받아서 계속 복구    최길호 2023/02/28 66
Admin  recovery_target_action = 'pause' / select pg_wal_replay_pause(); / select pg_get_wal_replay_pause_state();    최길호 2023/02/27 53
Admin  memory buffer cache    최길호 2023/02/06 48
Admin  active session, pid, lock sql , kill pid / pg_terminate_backend    최길호 2023/02/06 121
Admin  psql HA    최길호 2023/02/05 559
Admin  pg_ctl start -D . | postmaster.pid | /tmp/.s.PGSQL.5432 |    최길호 2023/02/03 81

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

Copyright 1999-2025 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
07/03
[ORACLE]
sms recovery check ORA-00278 ....
by 최길호
07/03
[ORACLE]
ORA-02019: connection descript....
by 최길호
07/02
[운영체제]
rsync -auv.
by 최길호