database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
ㆍPostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
PostgreSQL Q&A 7671 게시물 읽기
No. 7671
pgpool 기본포트로 접속시 질문드립니다
작성자
김태규
작성일
2009-04-02 18:40
조회수
6,510

전에 freebsd로 테스트해볼땐 잘 되던게 solaris 10으로 테스트 하니 접속이 안되고 있습니다

어떤게 문젠지 잘 모르겠네요 일단 메시지를 보면 


2009-04-02 18:49:37 DEBUG: pid 1201: Protocol Major: 1234 Minor: 5679 database:  user:

2009-04-02 18:49:37 DEBUG: pid 1201: SSLRequest: sent N; retry startup

2009-04-02 18:49:37 DEBUG: pid 1201: Protocol Major: 3 Minor: 0 database: nasa_ncms user: nasacti

2009-04-02 18:49:37 ERROR: pid 1201: connect_inet_domain_socket: connect() failed: Cannot assign requested address

2009-04-02 18:49:37 LOG:   pid 1201: notice_backend_error: master: 0 fail over request from pid 1201

2009-04-02 18:49:37 DEBUG: pid 1168: failover_handler called

2009-04-02 18:49:37 LOG:   pid 1168: starting degeneration. shutdown secondary host 192.168.10.86(0)

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1170

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1171

2009-04-02 18:49:37 DEBUG: pid 2009-04-02 18:49:37 DEBUG: pid 117011682009-04-02 18:49:37:  DEBUG: pid : 1171kill : child receives shutdown request signal child receives shutdown request signal 311723


2009-04-02 18:49:372009-04-02 18:49:37 DEBUG: pid  DEBUG: pid 11721168: kill 1173

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1174

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1175

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1176

2009-04-02 18:49:372009-04-02 18:49:37 DEBUG: pid  DEBUG: pid 11731168: : kill child receives shutdown request signal 11773

2009-04-02 18:49:37: child receives shutdown request signal 3 DEBUG: pid 1168: kill 1178

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1179

2009-04-02 18:49:37 DEBUG: pid 2009-04-02 18:49:37 DEBUG: pid 1168: kill 11801178: child receives shutdown request signal

3

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1181

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1182

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1183

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1184

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1185

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1186

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1187

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1188

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1189

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1190

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1191

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1192

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1193

2009-04-02 18:49:37 DEBUG: pid 2009-04-02 18:49:371168: kill 1194 DEBUG: pid

2009-04-02 18:49:371192: child receives shutdown request signal  DEBUG: pid 1168: kill 3

1195

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1196

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1197

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1198

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1199

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1200

2009-04-02 18:49:37 DEBUG: pid 1168: kill 1201

2009-04-02 18:49:37 DEBUG: pid 1199: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1196: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1198: child receives shutdown request signal 3

2009-04-02 18:49:372009-04-02 18:49:37 DEBUG: pid 11942009-04-02 18:49:37 DEBUG: pid 1182: child receives shutdown request signal 3: child receives shutdown request signal 3

 DEBUG: pid 1200: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1195: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1184: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1193: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1175: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1197: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1181: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1191: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1176: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 11892009-04-02 18:49:372009-04-02 18:49:37:  DEBUG: pid child receives shutdown request signal 3

 DEBUG: pid 11861190: child receives shutdown request signal 3: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1185: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1177: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1187: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1183: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 11802009-04-02 18:49:37 DEBUG: pid 1188: child receives shutdown request signal 3

: child receives shutdown request signal 32009-04-02 18:49:37

 DEBUG: pid 1179: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1174: child receives shutdown request signal 3

2009-04-02 18:49:37 DEBUG: pid 1229: I am 1229

2009-04-02 18:49:37 DEBUG: pid 1230: I am 1230

2009-04-02 18:49:37 DEBUG: pid 1231: I am 1231

2009-04-02 18:49:37 DEBUG: pid 1232: I am 1232

2009-04-02 18:49:37 DEBUG: pid 1233: I am 1233

2009-04-02 18:49:37 DEBUG: pid 1234: I am 1234

2009-04-02 18:49:37 DEBUG: pid 1235: I am 1235

2009-04-02 18:49:37 DEBUG: pid 1236: I am 1236

2009-04-02 18:49:37 DEBUG: pid 1237: I am 1237

2009-04-02 18:49:37 DEBUG: pid 1238: I am 1238

2009-04-02 18:49:37 DEBUG: pid 1239: I am 1239

2009-04-02 18:49:37 DEBUG: pid 1240: I am 1240

2009-04-02 18:49:37 DEBUG: pid 1241: I am 1241

2009-04-02 18:49:37 DEBUG: pid 1242: I am 1242

2009-04-02 18:49:37 DEBUG: pid 1243: I am 1243

2009-04-02 18:49:37 DEBUG: pid 1244: I am 1244

2009-04-02 18:49:37 DEBUG: pid 1245: I am 1245

2009-04-02 18:49:37 DEBUG: pid 1246: I am 1246

2009-04-02 18:49:37 DEBUG: pid 1247: I am 1247

2009-04-02 18:49:37 DEBUG: pid 1248: I am 1248

2009-04-02 18:49:37 DEBUG: pid 1249: I am 1249

2009-04-02 18:49:37 DEBUG: pid 1250: I am 1250

2009-04-02 18:49:37 DEBUG: pid 1251: I am 1251

2009-04-02 18:49:37 DEBUG: pid 1252: I am 1252

2009-04-02 18:49:37 DEBUG: pid 1253: I am 1253

2009-04-02 18:49:37 DEBUG: pid 1254: I am 1254

2009-04-02 18:49:37 DEBUG: pid 1255: I am 1255

2009-04-02 18:49:37 DEBUG: pid 1256: I am 1256

2009-04-02 18:49:37 LOG:   pid 1168: degeneration done. shutdown secondary host 192.168.10.86(0)

2009-04-02 18:49:37 DEBUG: pid 1257: I am 1257

2009-04-02 18:49:37 DEBUG: pid 1258: I am 1258

2009-04-02 18:49:37 DEBUG: pid 1259: I am 1259

2009-04-02 18:49:37 DEBUG: pid 1260: I am 1260

이렇게 나오네요


ERROR: pid 1201: connect_inet_domain_socket: connect() failed: Cannot assign requested address


이게 무슨 문젠지 좀 조언 부탁드립니다

[Top]
No.
제목
작성자
작성일
조회
7674Bindings were not allocated properly 팝업이... [1]
2009-04-03
6807
7673dump 를 하지 않고 data를 백업하는 방법 [1]
길재
2009-04-03
6888
7672csv import 할때에 만드시 테이블을 정의해주고 해야하나요?... [1]
성제호
2009-04-03
7054
7671pgpool 기본포트로 접속시 질문드립니다
김태규
2009-04-02
6510
7670월별자료 boxplot [1]
chunrima
2009-04-02
7013
7669쿼리좀... [1]
초짜
2009-04-01
7455
7668쿼리문 힌트좀 주세요~ T.T [1]
김연자
2009-03-31
6619
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.016초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다