"Unknown Host" - Connecting to PostgreSQL database in SQL Shell (Windows)

Question

I've previously been using PostgreSQL in Ubuntu using:

$sudo -i -u postgres

to access postgres through the terminal to create a role and database. And then able to log in and make changes using:

$sudo -u [dbname] psql

However now I need to use PostgreSQL with LabVIEW so I've had to download PostgreSQL on a Windows PC. I can access the database through Pgadmin and have created a database but when I go into SQL shell it comes up with:

Server [localhost]:
Database [postgres]:
Port [5432]:
Username [postgres]:

I'm not sure if this has anything to do with roles, as I haven't created one for the windows database. But I can't even get past the above to create a role or make any changes in the command prompt.

When I type my computer host name, it says

    psql: could not translate host name "Lisa" to address: Unknown host

It says I am connected on PgAdmin and I am able to create databases and tables through the interface, but I can't figure out how to access it in the SQL Shell (psql).

Don't put "solved" into the title of the question. Accept the answer - that will mark this question as solved. — user330315
– user330315, Commented Oct 13, 2016 at 11:27

L Marfell · Accepted Answer · 2016-10-13 12:22:44Z

1

Entered server as localhost IP.

    Server [localhost]: 127.0.0.1 
    Database [localhost]: [dbname]
    Port [5432]: 5432
    Username [postgres]: [username]

edited Oct 13, 2016 at 12:22

answered Oct 13, 2016 at 11:15

L Marfell

3592 gold badges6 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

"Unknown Host" - Connecting to PostgreSQL database in SQL Shell (Windows)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related