Can't figure out how to start postgres on port 5432 in windows
Setting up Postgres on Windows for frontend web dev
This is not my area of expertise (frontend guy), but I need postgres simply running on my side to connect with the test DB for the project I'm working on:
I have to run this before I start my project: dropdb [db_name] && createdb [db_name] && npm run migration:run:dev
When I do so, I get the typical:
dropdb: 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 "/var/run/postgresql/.s.PGSQL.5432"?
This tells me that postgres isn't running on port 5432, which I verified in Resource Monitor and inside pgAdmin... in pgAdmin, all the PIDs are NOT 5432 and when I try to change the port to 5432 (although, already set to that), I get:
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?
I have postgres installed via the packaged installer, and I've tried various solutions, such as:
https://tableplus.io/blog/2018/10/how-to-start-stop-restart-postgresql-server.html
https://stackoverflow.com/questions/38466190/cant-connect-to-postgresql-on-port-5432 (I don't need remote connections)
Note(s)
I use homebrew to do this on my mac in like 2 commands... but services doesn't work with linuxbrew. I don't think my network is an issue if my mac has no problem with it on the same network.
I'm thinking something could be running on port 5432, but nothing appears to be in Resource Monitor.
postgresql windows
asked 24 mins ago
Chris JohnsonChris Johnson
11
New contributor
Chris Johnson 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 |
Setting up Postgres on Windows for frontend web dev
This is not my area of expertise (frontend guy), but I need postgres simply running on my side to connect with the test DB for the project I'm working on:
I have to run this before I start my project: dropdb [db_name] && createdb [db_name] && npm run migration:run:dev
When I do so, I get the typical:
dropdb: 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 "/var/run/postgresql/.s.PGSQL.5432"?
This tells me that postgres isn't running on port 5432, which I verified in Resource Monitor and inside pgAdmin... in pgAdmin, all the PIDs are NOT 5432 and when I try to change the port to 5432 (although, already set to that), I get:
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?
I have postgres installed via the packaged installer, and I've tried various solutions, such as:
https://tableplus.io/blog/2018/10/how-to-start-stop-restart-postgresql-server.html
https://stackoverflow.com/questions/38466190/cant-connect-to-postgresql-on-port-5432 (I don't need remote connections)
Note(s)
I use homebrew to do this on my mac in like 2 commands... but services doesn't work with linuxbrew. I don't think my network is an issue if my mac has no problem with it on the same network.
I'm thinking something could be running on port 5432, but nothing appears to be in Resource Monitor.
postgresql windows
asked 24 mins ago
Chris JohnsonChris Johnson
11
New contributor
Chris Johnson 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 |
Setting up Postgres on Windows for frontend web dev
This is not my area of expertise (frontend guy), but I need postgres simply running on my side to connect with the test DB for the project I'm working on:
I have to run this before I start my project: dropdb [db_name] && createdb [db_name] && npm run migration:run:dev
When I do so, I get the typical:
dropdb: 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 "/var/run/postgresql/.s.PGSQL.5432"?
This tells me that postgres isn't running on port 5432, which I verified in Resource Monitor and inside pgAdmin... in pgAdmin, all the PIDs are NOT 5432 and when I try to change the port to 5432 (although, already set to that), I get:
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?
I have postgres installed via the packaged installer, and I've tried various solutions, such as:
https://tableplus.io/blog/2018/10/how-to-start-stop-restart-postgresql-server.html
https://stackoverflow.com/questions/38466190/cant-connect-to-postgresql-on-port-5432 (I don't need remote connections)
Note(s)
I use homebrew to do this on my mac in like 2 commands... but services doesn't work with linuxbrew. I don't think my network is an issue if my mac has no problem with it on the same network.
I'm thinking something could be running on port 5432, but nothing appears to be in Resource Monitor.
postgresql windows
asked 24 mins ago
Chris JohnsonChris Johnson
11
New contributor
Chris Johnson is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Setting up Postgres on Windows for frontend web dev
This is not my area of expertise (frontend guy), but I need postgres simply running on my side to connect with the test DB for the project I'm working on:
I have to run this before I start my project: dropdb [db_name] && createdb [db_name] && npm run migration:run:dev
When I do so, I get the typical:
dropdb: 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 "/var/run/postgresql/.s.PGSQL.5432"?
This tells me that postgres isn't running on port 5432, which I verified in Resource Monitor and inside pgAdmin... in pgAdmin, all the PIDs are NOT 5432 and when I try to change the port to 5432 (although, already set to that), I get:
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?
I have postgres installed via the packaged installer, and I've tried various solutions, such as:
https://tableplus.io/blog/2018/10/how-to-start-stop-restart-postgresql-server.html
https://stackoverflow.com/questions/38466190/cant-connect-to-postgresql-on-port-5432 (I don't need remote connections)
Note(s)
I use homebrew to do this on my mac in like 2 commands... but services doesn't work with linuxbrew. I don't think my network is an issue if my mac has no problem with it on the same network.
I'm thinking something could be running on port 5432, but nothing appears to be in Resource Monitor.
postgresql windows
postgresql windows
asked 24 mins ago
Chris JohnsonChris Johnson
11
New contributor
Chris Johnson is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 24 mins ago
Chris JohnsonChris Johnson
11
New contributor
Chris Johnson is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 24 mins ago
Chris JohnsonChris Johnson
11
New contributor
Chris Johnson is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 24 mins ago
Chris JohnsonChris Johnson
11
asked 24 mins ago
Chris JohnsonChris Johnson
11
11
New contributor
Chris Johnson is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Chris Johnson is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Chris Johnson 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: "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
});
}
});
Chris Johnson 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%2fdba.stackexchange.com%2fquestions%2f231966%2fcant-figure-out-how-to-start-postgres-on-port-5432-in-windows%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
Chris Johnson is a new contributor. Be nice, and check out our Code of Conduct.
Chris Johnson is a new contributor. Be nice, and check out our Code of Conduct.
Chris Johnson is a new contributor. Be nice, and check out our Code of Conduct.
Chris Johnson is a new contributor. Be nice, and check out our Code of Conduct.
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%2f231966%2fcant-figure-out-how-to-start-postgres-on-port-5432-in-windows%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
