Getting unfamiliar error when using terminal command to update database
I'm a bit in over my head when it comes to using and managing large databases. I run a small startup that uses a PostGreSQL and pgAdmin to administer and query the database, which is housed on Herkou.
Typically, I need to 'pull' and updated version of the database in order for the pgAdmin platform to query. This was all set up and explained to me a few months ago, and since then, things have worked well.
Recently, however, whenever I pull the using the following terminal command:
heroku pg:pull <db name> <local db name> --app <app name>
I get the following error:
heroku-cli: Pulling swimming-****-**** ---> <app name>
createdb: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
I have absolutely no idea how to fix this, and the person that set it up is long gone.
postgresql heroku
edited Jan 21 at 21:11
a_horse_with_no_name
40.4k777113
migrated from superuser.com Jan 20 at 21:17
This question came from our site for computer enthusiasts and power users.
add a comment |
I'm a bit in over my head when it comes to using and managing large databases. I run a small startup that uses a PostGreSQL and pgAdmin to administer and query the database, which is housed on Herkou.
Typically, I need to 'pull' and updated version of the database in order for the pgAdmin platform to query. This was all set up and explained to me a few months ago, and since then, things have worked well.
Recently, however, whenever I pull the using the following terminal command:
heroku pg:pull <db name> <local db name> --app <app name>
I get the following error:
heroku-cli: Pulling swimming-****-**** ---> <app name>
createdb: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
I have absolutely no idea how to fix this, and the person that set it up is long gone.
postgresql heroku
edited Jan 21 at 21:11
a_horse_with_no_name
40.4k777113
migrated from superuser.com Jan 20 at 21:17
This question came from our site for computer enthusiasts and power users.
What I can say from your error message is that it's trying to connect locally to an instance on port 5432 and can't find it. So either your local instance doesn't run on port 5432 or it needs to be started...
– Arkhena
Jan 21 at 10:54
add a comment |
I'm a bit in over my head when it comes to using and managing large databases. I run a small startup that uses a PostGreSQL and pgAdmin to administer and query the database, which is housed on Herkou.
Typically, I need to 'pull' and updated version of the database in order for the pgAdmin platform to query. This was all set up and explained to me a few months ago, and since then, things have worked well.
Recently, however, whenever I pull the using the following terminal command:
heroku pg:pull <db name> <local db name> --app <app name>
I get the following error:
heroku-cli: Pulling swimming-****-**** ---> <app name>
createdb: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
I have absolutely no idea how to fix this, and the person that set it up is long gone.
postgresql heroku
edited Jan 21 at 21:11
a_horse_with_no_name
40.4k777113
I'm a bit in over my head when it comes to using and managing large databases. I run a small startup that uses a PostGreSQL and pgAdmin to administer and query the database, which is housed on Herkou.
Typically, I need to 'pull' and updated version of the database in order for the pgAdmin platform to query. This was all set up and explained to me a few months ago, and since then, things have worked well.
Recently, however, whenever I pull the using the following terminal command:
heroku pg:pull <db name> <local db name> --app <app name>
I get the following error:
heroku-cli: Pulling swimming-****-**** ---> <app name>
createdb: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
I have absolutely no idea how to fix this, and the person that set it up is long gone.
postgresql heroku
postgresql heroku
edited Jan 21 at 21:11
a_horse_with_no_name
40.4k777113
edited Jan 21 at 21:11
a_horse_with_no_name
40.4k777113
edited Jan 21 at 21:11
a_horse_with_no_name
40.4k777113
edited Jan 21 at 21:11
a_horse_with_no_name
40.4k777113
edited Jan 21 at 21:11
a_horse_with_no_name
40.4k777113
40.4k777113
asked Jan 20 at 20:57
ironjatt
migrated from superuser.com Jan 20 at 21:17
This question came from our site for computer enthusiasts and power users.
migrated from superuser.com Jan 20 at 21:17
This question came from our site for computer enthusiasts and power users.
What I can say from your error message is that it's trying to connect locally to an instance on port 5432 and can't find it. So either your local instance doesn't run on port 5432 or it needs to be started...
– Arkhena
Jan 21 at 10:54
add a comment |
What I can say from your error message is that it's trying to connect locally to an instance on port 5432 and can't find it. So either your local instance doesn't run on port 5432 or it needs to be started...
– Arkhena
Jan 21 at 10:54
What I can say from your error message is that it's trying to connect locally to an instance on port 5432 and can't find it. So either your local instance doesn't run on port 5432 or it needs to be started...
– Arkhena
Jan 21 at 10:54
What I can say from your error message is that it's trying to connect locally to an instance on port 5432 and can't find it. So either your local instance doesn't run on port 5432 or it needs to be started...
– Arkhena
Jan 21 at 10:54
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});
}
});
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%2fdba.stackexchange.com%2fquestions%2f227616%2fgetting-unfamiliar-error-when-using-terminal-command-to-update-database%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
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f227616%2fgetting-unfamiliar-error-when-using-terminal-command-to-update-database%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
What I can say from your error message is that it's trying to connect locally to an instance on port 5432 and can't find it. So either your local instance doesn't run on port 5432 or it needs to be started...
– Arkhena
Jan 21 at 10:54