Skip to content
This repository has been archived by the owner on Jul 3, 2023. It is now read-only.

pgpool warning when using nohup to start #35

Open
yuananf opened this issue May 12, 2015 · 1 comment
Open

pgpool warning when using nohup to start #35

yuananf opened this issue May 12, 2015 · 1 comment

Comments

@yuananf
Copy link

yuananf commented May 12, 2015

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
Copy link

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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants