Page 1 of 1
Unable to connect to the database
Posted:
Mon Jun 24, 2013 11:51 am
by ma6inata100
Hallo,
I have installed PT 4. I run the program and the comes the window Configure PostgreSQL server.
The information is :
Server : localhost
Port : 5432
Database user : postgres
Password : dbpass
I click on connect and then comes the message : Unable to connect to the database.Please check the configuration.
What should I do ?
Re: Unable to connect to the database
Posted:
Mon Jun 24, 2013 12:45 pm
by kraada
When you installed PT4 did it offer to install PostgreSQL for you? Click Start type services.msc and click on it when it appears. Is PostgreSQL in the list of services?
Re: Unable to connect to the database
Posted:
Wed Jun 26, 2013 5:49 am
by ma6inata100
Yes, it offers me to install the PostgreSQL for me and it has installed it.
Yes, PostgreSQL is in the list of services and in the start up type is written automatic.
When i click on start the service, it loads and the i become a note : error 1053 - the service did not respond to the start or control request in a timely fashion.
Re: Unable to connect to the database
Posted:
Wed Jun 26, 2013 9:21 am
by kraada
Click Start, type Event Viewer and click on it when it appears. In the left pane expand Windows Logs and click on Applications. In the top center look for an error relating to PostgreSQL (there should be one) and click on it and tell me what the error text says.
Re: Unable to connect to the database
Posted:
Fri Jun 28, 2013 7:47 am
by ma6inata100
There are two errors from today :
So the first error says : Timed out waiting for server startup.
The other error says : postgres cannot access the server configuration file "C:/Program Files/PostgreSQL/9.0/data/postgresql.conf": No such file or directory
Re: Unable to connect to the database
Posted:
Fri Jun 28, 2013 8:38 am
by kraada
What files and folders are in the C:\Program Files\PostgreSQL\9.0\data folder?
Re: Unable to connect to the database
Posted:
Mon Jul 01, 2013 8:37 am
by ma6inata100
So in this directory is only pg_log file but it is empty. The whole directory is 0 byte.
I have installed the program in C:\Program Files(x86)\PostgreSQL\9.0\.. and there is another files and folders. But the data folder is not there.
Re: Unable to connect to the database
Posted:
Mon Jul 01, 2013 2:39 pm
by kraada
Can you find a base folder anywhere on your computer that's inside of a folder called data? If not, PostgreSQL has become uninstalled one way or another and you will need to reinstall it and reimport your hands.
Re: Unable to connect to the database
Posted:
Wed Jul 10, 2013 5:21 am
by ma6inata100
So i have re-install the PostgreSQL, and then everything was all right. It works good.
Thank you for the help.