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]
CANNOT CREATE A DATABASE
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:
Please refer to the PostrgreSQL documentation for the detailed information.
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