ChatGPT解决这个技术问题 Extra ChatGPT

PostgreSQL database service

I downloaded PostgreSQL from their site - http://www.postgresql.org/download/windows

However, I can't create a database from pgAdmin and get a message:

could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting TCP/IP connections on port 5432?

Do I have to create a windows service? How is it called? Do I have to install it separately?

EDITED

Let me explain myself. I am trying to run the service. I tried running postgres.exe from the command line but still it does not run.

What could run the database?

EDITED

The problem was with my installation file. I downloaded it again - and it worked well!


o
ontrack

Use services (start -> run -> services.msc) and look for the postgresql-[version] service.

If it is not there you might have just installed pgAdmin and not installed PostgreSQL itself.

If it is not running try to start it, if it won't start open the event-viewer (start -> run -> eventvwr) and look for error messages relating to the PostgreSQL service.

If it does start check the startup type, if you want it to start with windows it should be "Automatic"; or perhaps "Automatic, delayed start" if you don't want it to slow down startup too much.

Adding to the first, because in a different comment you've said the service isn't there. It is possible to download a standalone pgAdmin so you can connect to an external PostgreSQL database. It would seem you have done such a thing, or explicitly chosen to not add the service. Just try the One Click Installer, which still allows proper configuration of installation directory despite its name.


I actually downloaded the OneClickInstaller. I don't know why I don't have the service in the list!
When I start my postgresql9.1, it automaticall stoped by giving message some service stopautomatically.
even when the service says it's stopped, the problem with refused connection is resolved (for me). trying to start the service again shows: postmaster.pid already exists. implying that postgres is now running
nice answer! for some reason this service has a tendency to crash and fail to start. if and when it does it isn't configured by default (although default is automatic start) to restart itself. I think Postgres really shit the bed on this one. I dunno why their DB is so unstable.
@ANIL right click on the Postgresql sevice and select properties > go to log on tab > select first option and tick the check box> then start the service .
J
Jhon

I have the solution to this problem enters (Start -> Run -> services.msc) are looking for the postgresql service once you localizas le das Properties---> login and you disable the account you have and what you leave as the local system account , save and restart the programs pgadmin3 and ready should operate.

Greeting from Colombia


A
Ahmad Abdelghany

You might get a more descriptive error message if you tried to start the service from command line using this command:

"C:\Program Files\PostgreSQL\9.5\bin\pg_ctl.exe" start -N "postgresql-x64-9.5" 
  -D "C:\Program Files\PostgreSQL\9.5\data" -w

The log file would be at C:\Program Files\PostgreSQL\9.5\data\pg_log. Note that paths and service name might be different depending on your installation.


A
Anaurg

(start -> run -> services.msc) and look for the postgresql-[version] service then right click and enable it


F
Frank Liao

You only need to do

pg_ctl register

then execute servcies.msc

enable the "PostgresSQL" and set to auto

then, your postgresql will run like the "server".


R
Ruslan

The solution was simply to comment the lines "work_mem=256MB" and "maintenance_work_mem=$3GB" in the file postgresql.conf and try to start the postgresql service. (start -> run -> services.msc) and look for the postgresql-[version] service then right click and start.


M
Mesut ASARKAYA

Checking the port may work.

On pgAdmin page at the top, go to Properties and check the port if it is same with the one provided during the setup. If not click the edit button on the top right and change the port.


This work for me. My server default port is 5433 when open PgAdmin it runs on 5432.
u
user14298639

Your server running on port 5432 but in the properties, the port is set to 5433.

You must go to pgAdmin, click on database version, ex: PostgresSQL 10 and edit properties.

A new window appears and you need to change the port to 5432 [this is default port].


B
Bonshington

check conenctionstring check SSL check firewall if u use VS studio, check for db driver


The connection string is fine. I am afraid that the server is not on. How do I turn it on?
T
Tobu

I'm not on windows, but I think you can use the pgAdmin you just installed to configure a server connection and start the server.


I think it's just a matter of finding the right menu to start the service.
D
DrColossos

Your server might not be running. This can have 2 issus IMO:

I had the problem that the permissions were not set on the postgres folders and so the service was not able to start. I have no idea why that happend but giving proper permissions on the root postges folder and subfolders did the trick. If I recall it correctly, postgres is also installed as a service so you should find it in the Service List To start the server, you have a startcommand in your Startmenu. Somewhere at Start -> PostgreSQL -> Start Service/Server/... (haven't used it on Windows for a long time but it should be there).


I tried Start -> PostgreSQL -> Start Service/Server/ but there is not start service/server there
Y
YasirPoongadan

Please Download from this

https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

install above downloaded file

then

The solution was simply to delete %appdata%\pgAdmin (win key + r then type %appdata% got folder pgAdmin) which was created by an earlier version. On systems other than Windows, there probably is a pgAdmin directory in your user directory. Of course, all session settings etc. are gone after deleting this.


M
Mohammed Al-Reai

you to restart services PostgreSQL from task manager click ctrl+alt+delete then chose services the postgresql-[version] chose the option to run automatically then start and apply ->ok


A
Ankit Garg

Use Services

Windows -> Services check your PostgresSQL is started or in running state. ( If it's not then start your services for PostgresSQL). Close services and check again with your PostgresSQL.

This will start PostgresSQL servers as normal.


S
Sidrah Madiha Siddiqui

On windows, Just go to the 'Services'. Start/Restart the postgresql-X64 service (click on this service, a dialog box will appear, click Start then OK).Refresh the browser window where postgre db is appearing. It worked for me as my service was in stopped state somehow.


Y
Yodi S.

In my case, it was the Log On issue. This is how I solve the issue:

Click the Windows button then search Services, open Services Search postgre-xxx service like this If the status is empty, try right click then choose start If you get an error like 'could not start postgre...', try right click and choose properties choose Log On tab choose Local System Account

https://i.stack.imgur.com/4x6i5.png

click OK, then right-click the service and try to start the service


关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now