search

treasure-data / prestogres

PostgreSQL protocol gateway for Presto distributed SQL query engine
Other
292 stars 61 forks source link

pgpool warning when using nohup to start #35

Open yuananf opened 9 years ago

yuananf commented 9 years ago

I run 'prestogres-ctl postgres -D pgdata' using nohup and it succesfully starts. But when I run 'prestogres-ctl pgpool' it starts the pgpool, but the log looks like below:

2015-05-12 14:43:17: pid 63946: LOG:  Setting up socket for 0.0.0.0:5439
2015-05-12 14:43:17: pid 63946: LOG:  Setting up socket for :::5439
2015-05-12 14:43:17: pid 63946: LOG:  prestogres successfully started. version 0.6.7 (tataraboshi)
2015-05-12 14:43:17: pid 63948: WARNING:  Connection to database failed: "FATAL:  the database system is starting up
    "
2015-05-12 14:43:17: pid 63948: DETAIL:  connection failed for database:"prestogres@postgres" on Host:"127.0.0.1:5432"
2015-05-12 14:43:17: pid 63948: WARNING:  failed to make persistent system db connection
2015-05-12 14:43:17: pid 63948: DETAIL:  system_db_connect failed
2015-05-12 14:43:17: pid 63949: WARNING:  Connection to database failed: "FATAL:  the database system is starting up
    "
2015-05-12 14:43:17: pid 63949: DETAIL:  connection failed for database:"prestogres@postgres" on Host:"127.0.0.1:5432"
2015-05-12 14:43:17: pid 63949: WARNING:  failed to make persistent system db connection
2015-05-12 14:43:17: pid 63949: DETAIL:  system_db_connect failed
2015-05-12 14:43:17: pid 63950: WARNING:  Connection to database failed: "FATAL:  the database system is starting up

Is it a problem?

minguofeng commented 7 years ago

hi, have you fix this issue? i meet the same problem,

prestogres-ctl pgpool

/usr/local/bin/prestogres-pgpool -n 2017-07-04 11:08:37: pid 17554: LOG: Setting up socket for ::1:6719 2017-07-04 11:08:37: pid 17554: LOG: Setting up socket for 127.0.0.1:6719 2017-07-04 11:08:37: pid 17554: LOG: prestogres successfully started. version 0.6.7 (tataraboshi) 2017-07-04 11:08:37: pid 17554: FATAL: failed to create INET domain socket 2017-07-04 11:08:37: pid 17554: DETAIL: bind on host:"0.0.0.0" server:"monkeycom" failed with error "Address already in use" 2017-07-04 11:08:37: pid 17556: LOG: child process received shutdown request signal 15 2017-07-04 11:08:37: pid 17558: LOG: child process received shutdown request signal 15 2017-07-04 11:08:37: pid 17559: LOG: child process received shutdown request signal 15 2017-07-04 11:08:37: pid 17555: LOG: child process received shutdown request signal 15 2017-07-04 11:08:37: pid 17557: LOG: child process received shutdown request signal 15 2017-07-04 11:08:37: pid 17556: WARNING: Connection to database failed: "FATAL: role "presto" does not exist" 2017-07-04 11:08:37: pid 17556: DETAIL: connection failed for database:"presto@postgres" on Host:"localhost:5677" 2017-07-04 11:08:37: pid 17556: WARNING: failed to make persistent system db connection 2017-07-04 11:08:37: pid 17556: DETAIL: system_db_connect failed 2017-07-04 11:08:37: pid 17559: WARNING: Connection to database failed: "FATAL: role "presto" does not exist