Postgres sometimes will not start after hard reboot Announcing the arrival of Valued Associate...
Why is std::move not [[nodiscard]] in C++20?
Nose gear failure in single prop aircraft: belly landing or nose-gear up landing?
Did Mueller's report provide an evidentiary basis for the claim of Russian govt election interference via social media?
Google .dev domain strangely redirects to https
Delete free apps from library
How many time has Arya actually used Needle?
New Order #6: Easter Egg
What does it mean that physics no longer uses mechanical models to describe phenomena?
Putting class ranking in CV, but against dept guidelines
Why do early math courses focus on the cross sections of a cone and not on other 3D objects?
"klopfte jemand" or "jemand klopfte"?
My mentor says to set image to Fine instead of RAW — how is this different from JPG?
Printing attributes of selection in ArcPy?
What is the "studentd" process?
Was Kant an Intuitionist about mathematical objects?
Asymptotics question
Why is a lens darker than other ones when applying the same settings?
Monty Hall Problem-Probability Paradox
GDP with Intermediate Production
Central Vacuuming: Is it worth it, and how does it compare to normal vacuuming?
Random body shuffle every night—can we still function?
NERDTreeMenu Remapping
After Sam didn't return home in the end, were he and Al still friends?
Positioning dot before text in math mode
Postgres sometimes will not start after hard reboot
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)Mac updated just now, postgres now brokenBest place to clean up files in linux start upHomebrew postgres won't start after uninstall, reinstall and rebootPostgres won't start after restore pointPermissions in SambaMount a directory of another server on boot automaticalyPostgres won't start after blackoutSystemd: Starting of *.automount not supportedCan't get BananaPi to start Access PointHow to start a service at startup
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
We have around 100 servers in clients running Postgres with Ubuntu server.
Sometimes after a hard reboot (eg. power loss) the postgres do not start. To start we have to access the server and type:
sudo systemctl start postgresql.service
What is the best solution fix the problem automatically without we have to access the server manually? Is it a good idea a script the checks the postgres startup status and use the start command if necessary?
Best regards
linux postgresql
asked 5 hours ago
Joao PauloJoao Paulo
61
New contributor
Joao Paulo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
We have around 100 servers in clients running Postgres with Ubuntu server.
Sometimes after a hard reboot (eg. power loss) the postgres do not start. To start we have to access the server and type:
sudo systemctl start postgresql.service
What is the best solution fix the problem automatically without we have to access the server manually? Is it a good idea a script the checks the postgres startup status and use the start command if necessary?
Best regards
linux postgresql
asked 5 hours ago
Joao PauloJoao Paulo
61
New contributor
Joao Paulo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
We have around 100 servers in clients running Postgres with Ubuntu server.
Sometimes after a hard reboot (eg. power loss) the postgres do not start. To start we have to access the server and type:
sudo systemctl start postgresql.service
What is the best solution fix the problem automatically without we have to access the server manually? Is it a good idea a script the checks the postgres startup status and use the start command if necessary?
Best regards
linux postgresql
asked 5 hours ago
Joao PauloJoao Paulo
61
New contributor
Joao Paulo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
We have around 100 servers in clients running Postgres with Ubuntu server.
Sometimes after a hard reboot (eg. power loss) the postgres do not start. To start we have to access the server and type:
sudo systemctl start postgresql.service
What is the best solution fix the problem automatically without we have to access the server manually? Is it a good idea a script the checks the postgres startup status and use the start command if necessary?
Best regards
linux postgresql
linux postgresql
asked 5 hours ago
Joao PauloJoao Paulo
61
New contributor
Joao Paulo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 hours ago
Joao PauloJoao Paulo
61
New contributor
Joao Paulo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 hours ago
Joao PauloJoao Paulo
61
New contributor
Joao Paulo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 hours ago
Joao PauloJoao Paulo
61
asked 5 hours ago
Joao PauloJoao Paulo
61
61
New contributor
Joao Paulo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Joao Paulo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Joao Paulo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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',
autoActivateHeartbeat: false,
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
});
}
});
Joao Paulo is a new contributor. Be nice, and check out our Code of Conduct.
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%2fsuperuser.com%2fquestions%2f1427763%2fpostgres-sometimes-will-not-start-after-hard-reboot%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Joao Paulo is a new contributor. Be nice, and check out our Code of Conduct.
Joao Paulo is a new contributor. Be nice, and check out our Code of Conduct.
Joao Paulo is a new contributor. Be nice, and check out our Code of Conduct.
Joao Paulo is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- 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.
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%2fsuperuser.com%2fquestions%2f1427763%2fpostgres-sometimes-will-not-start-after-hard-reboot%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
