Problem with PostgreSQL database connection

Asked By dla2000 10 points N/A Posted on - 09/30/2011

Hello, On my Windows 7 machine, I run PostgreSQL databases, but I can't add a server to create my databases. As an address I use 'localhost'  but can't connect, resulting to the following errors:

pgAdmin III

An error has occurred:

Error connecting to the server: FATAL: database "db" does not exist

pgAdmin III

An error has occurred:

Error connecting to the server: could not connect to server: Connection refused (0x0000274D/10061)

Is the server running on host "127.0.0.1' and accepting

TCP/IP connections on port 5432?

Keep in mind that I have configured my firewall to accept connection on port 5432.
 

• Status: Open
• Question Views: 3894
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: PostgreSQL

Best Answer by Rodney2001

Go To Solution

Best Answer

Best Answer

Answered By Rodney2001 0 points N/A #84026

Problem with PostgreSQL database connection

Ensure that your administrator creates a postgressSQL user account for you. This will largely solve the problem. Then try creating a pgadmin and a new login Role and name it (give it the user name you want to be using).  Give it permission graphically or from command line if you are the operating system's manager.

Create something that resembles this psql-U postgress- c then create a Role. Login nosuperuser inherit createdb createrole for more information about this you can go to https://www.postgresql.org/docs/devel/static/. This will enable you get accurate information about how to go about creating the database.

About Rodney2001

Questions
0

Answers
5

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 10/18/2011
• Question Category: PostgreSQL

Answered By Mikag08 0 points N/A #84028

Problem with PostgreSQL database connection

The first error window shows the non-existence of database ‘db’ from your PostgreSQL.

The means that PostgreSQL is trying to connect to the given database which has not been created.

Solution:

A database should be created with the specified name after logging in as Administrator to the machine. More information on database creation can be read at: https://www.postgresql.org/docs/8.1/static/tutorial-createdb.html

The Server connection problem could be arising from:

The server has not been started or 3rd party firewall software is installed in the machine.

Solution:

Try Uninstalling the software or disabling the firewall. If that doesn’t work out try restarting the server.

If the TCP/IP connections configurations errors persist. Follow this procedure.

Open the PostgreSQL configuration file (postgresql.conf) and enable the TCP/IP port by setting the (tcpip_socket = true).save and close the file and restart the server. More information can be read at: http://www.cyberciti.biz/faq/postgresql-remote-access-or-connection

About Mikag08

Questions
0

Answers
6

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/18/2011
• Question Category: PostgreSQL