Problems with running pgAgent with postgres
up vote
0
down vote
favorite
I'm running pgAgent and postgres on ubuntu server. Now, from time to time, pgAgent loses the connection to the server and I get the following errors:
Mon Oct 8 11:47:14 2018 : WARNING: Couldn't create the primary connection (attempt 9): could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
Mon Oct 8 11:47:19 2018 : WARNING: Couldn't create the primary connection (attempt 10): could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
Mon Oct 8 11:47:19 2018 : ERROR: Stopping pgAgent: Couldn't establish the primary connection with the database server.
What might be causing this behaviour? What should I do to fix this?
postgresql
asked Nov 22 at 12:44
Keselme
354213
add a comment |
up vote
0
down vote
favorite
I'm running pgAgent and postgres on ubuntu server. Now, from time to time, pgAgent loses the connection to the server and I get the following errors:
Mon Oct 8 11:47:14 2018 : WARNING: Couldn't create the primary connection (attempt 9): could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
Mon Oct 8 11:47:19 2018 : WARNING: Couldn't create the primary connection (attempt 10): could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
Mon Oct 8 11:47:19 2018 : ERROR: Stopping pgAgent: Couldn't establish the primary connection with the database server.
What might be causing this behaviour? What should I do to fix this?
postgresql
asked Nov 22 at 12:44
Keselme
354213
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I'm running pgAgent and postgres on ubuntu server. Now, from time to time, pgAgent loses the connection to the server and I get the following errors:
Mon Oct 8 11:47:14 2018 : WARNING: Couldn't create the primary connection (attempt 9): could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
Mon Oct 8 11:47:19 2018 : WARNING: Couldn't create the primary connection (attempt 10): could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
Mon Oct 8 11:47:19 2018 : ERROR: Stopping pgAgent: Couldn't establish the primary connection with the database server.
What might be causing this behaviour? What should I do to fix this?
postgresql
asked Nov 22 at 12:44
Keselme
354213
I'm running pgAgent and postgres on ubuntu server. Now, from time to time, pgAgent loses the connection to the server and I get the following errors:
Mon Oct 8 11:47:14 2018 : WARNING: Couldn't create the primary connection (attempt 9): could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
Mon Oct 8 11:47:19 2018 : WARNING: Couldn't create the primary connection (attempt 10): could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
Mon Oct 8 11:47:19 2018 : ERROR: Stopping pgAgent: Couldn't establish the primary connection with the database server.
What might be causing this behaviour? What should I do to fix this?
postgresql
postgresql
asked Nov 22 at 12:44
Keselme
354213
asked Nov 22 at 12:44
Keselme
354213
asked Nov 22 at 12:44
Keselme
354213
asked Nov 22 at 12:44
Keselme
354213
asked Nov 22 at 12:44
Keselme
354213
354213
add a comment |
add a comment |
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53431326%2fproblems-with-running-pgagent-with-postgres%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53431326%2fproblems-with-running-pgagent-with-postgres%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
