psql: could not connect to server: Connection refused (0x0000274D/10061) in windows

postgresql psql postgresql-8.3
Patan picture Patan · Dec 26, 2012 · Viewed 8.7k times · Source

I am trying to run psql.exe from command line. I am getting error as below.

C:\>cd C:\Program Files\PostgreSQL\8.3\bin

C:\Program Files\PostgreSQL\8.3\bin>psql.exe
psql: could not connect to server: Connection refused (0x0000274D/10061)
        Is the server running on host "???" and accepting
        TCP/IP connections on port 5432?

Can any one help how to resolve it.

Thanks in advance.

Answer

titanofold picture titanofold · Dec 26, 2012

You need to provide it some arguments:

C:\Program Files\PostgreSQL\8.3\bin> psql.exe -h localhost -U user -d database

Related questions

PostgreSQL "DESCRIBE TABLE"

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

Read More
Run a PostgreSQL .sql file using command line arguments

I have some .sql files with thousands of INSERT statements in them and need to run these inserts on my PostgreSQL database in order to add them to a table. The files are that large that it is impossible to …

Read More
How to switch databases in psql?

In MySQL, I used use database_name; What's the psql equivalent?

Read More