CANNOT CREATE A DATABASE

[JORGEMAL]

I just changed my PC and installed all the tools needed for my project development. I had been working with dotConnect for PostgreSQL 4.0 in my old machine and now I installed v4.5. When I tried to create the database I got the following error message:

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

I have already given the necessary rights to the directory where the DB needs to be created; I included the "postgres" user and gave "full control" access. I checked the "postgresql.conf" file and the "listen_addresses" options has a value of "*" meaning that the server listens on all ports.

PostgreSQL version in the old PC is 8.3.1 and in the new PC is 8.3.7. If I install version 8.3.1 everything works fine.

I will very much appreciate your advice.

Respectfuly,
Jorge Maldonado[/url]

[Shalex]

Dear JORGEMAL, this question exceeds the goals of our support. Probably, you didn't configure the pg_hba.conf file of your PostgreSQL 8.3.7. Please open this file in the text editor and add necessary entries to the IPv4 section. For example:

Code: Select all

# this entry allows connections to the database from the local machine
host    all         all         127.0.0.1/32          md5

# this entry allows connections to the database from the paticular remote host
host    all         all         192.168.0.210/32         md5

# this entry allows all connections
host    all         all         0.0.0.0/0         password

Please refer to the PostrgreSQL documentation for the detailed information.