5

I am currently setting up a postreSQL server on my Windows computer.

I want to create my first database, but couldn't create the createdb function due to a password authetification failed. Thus I found the following question on this website:

How to configure postgresql for the first time?

However, I think I forgot the ; at the end of :

ALTER USER postgres with encrypted password 'xxxxxxx';

And now, when I try to launch psql, I have the following errors:

Server [localhost]:
Database [postgres]:
Port [5432]:
Username [postgres]:
Active code page: 1252
psql: 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?
Press any key to continue . . .

Any idea of what I could do to solve the problem?

Do you think it is really the missing semi column that caused the problem?

Do you have any tutorial on how to setup a postgreSQL database on Windows? All the one I found until now were for Linux only.

Community
  • 1
  • 1
Aurel
  • 93
  • 1
  • 1
  • 6

1 Answers1

6

The error you're getting appears to be from Postgres not currently running, rather than an authentication error as you're presumed. The PSQL client or whatever PG client you're using is attempting to establish a connection on the default port but nothing is there.

If Postgres isn't currently running, try finding it (Via CTRL-Alt-Delete). If it's running, try terminating it and starting it up again. Hopefully that fixes the problem... Otherwise your port 5432 might be blocked for some reason.

If all fails, I am still skeptical the parentheses could cause this error because it's not an authentication error. Try to reinstall Postgres with a clean install.

edenzik
  • 146
  • 1
  • 4
  • 1
    Hi, thanks for your answer. I restarted my computer several times, but it didn't solve the problem. Uninstalling and reinstalling after deleting all configuration files solved the problem, even though I would have prefer to find a nicer way to do it. – Aurel Jul 09 '14 at 21:45
  • The config file probably had some wrong parameter (maybe a wrong port number or a commented out section). Glad it worked out – edenzik Jul 09 '14 at 22:12
  • Hi, i have postgres 9.3, 9.6 and 10 in same machine. My computer freezed and I've restarted the computer with hard reset and have the same issue with you. Services of Postgres 9.6 and 10 couldn't be started . So I've copied working pg_hba.conf of Postgre 9.3 to folders of 9.6 and 10 and restarted the services and connected to the database. – Capan Mar 15 '18 at 05:52