IOTN :: Field Book :: PostgreSQL

ȸ¿ø°¡ÀÔ

psql: server closed the connection unexpectedly [ vi $PGDATA/postgresql.conf / listen_addresses='*' ]

ÃÖ±æÈ£ [LIST]   2020-08-31 22:48:10, Á¶È¸ : 412 [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. 3.239.112.140

LIST

CategoryAdminTroubleshoot	Á¦¸ñ	ÀÛ¼ºÀÚ	ÀÛ¼ºÀÏ	Á¶È¸
Admin	odbc_fdw test	ÃÖ±æÈ£	2021/11/22	138
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	116
Admin	source make install [ 8 ~ 14 ]	ÃÖ±æÈ£	2021/11/11	171
Admin	psql odbc make install	ÃÖ±æÈ£	2021/11/09	134
Admin	oracle to psql dblink	ÃÖ±æÈ£	2021/11/09	155
Admin	/usr/bin/initdb -D /var/lib/pgsql/test [ Instance Ãß°¡ ]	ÃÖ±æÈ£	2021/11/05	106
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	272
Admin	install postgresql on docker centos:7	ÃÖ±æÈ£	2020/08/31	381
Troubleshoot	psql: server closed the connection unexpectedly [ vi $PGDATA/postgresql.conf / listen_addresses='*' ]	ÃÖ±æÈ£	2020/08/31	412

¸ñ·Ïº¸±â   ´ÙÀ½ÆäÀÌÁö

1 [2][3][4][5][6]

Copyright 1999-2022 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)