Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I tried to run the odoo and got 'Internal server error', when checked the PostgreSQL service I found that it is stopped. When I tried to run it I got the error message : "The PostgerSQL_For_OpenERP - PostgreSQL Server 9.3 service on local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs."
any help ?
For some reasons postgresql process is still running in the background.
You can encounter this problem if your system forcefully shutdowns down.
Solution:
1. Windows + X (Open task Manager - Processes)
2. Find all running postgresql services and 'End Task'.
After all processes have ended. You can reopen task manager to ensure no postgres services is running.
3. Restart Postgresql server
I also face this error. The suggestion cannot help me to solve the problem. I checked all the background process but don't have any postgresql process.
This is log file in pg_log
2019-06-28 11:17:50 ICT LOG: database system was interrupted while in recovery at 2019-06-28 10:20:30 ICT
2019-06-28 11:17:50 ICT HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2019-06-28 11:17:51 ICT FATAL: the database system is starting up
2019-06-28 11:17:52 ICT FATAL: the database system is starting up
2019-06-28 11:17:53 ICT FATAL: the database system is starting up
2019-06-28 11:17:54 ICT FATAL: the database system is starting up
2019-06-28 11:17:55 ICT FATAL: the database system is starting up
2019-06-28 11:17:56 ICT FATAL: the database system is starting up
2019-06-28 11:17:57 ICT FATAL: the database system is starting up
2019-06-28 11:17:58 ICT FATAL: the database system is starting up
2019-06-28 11:18:00 ICT FATAL: the database system is starting up
2019-06-28 11:18:01 ICT FATAL: the database system is starting up
2019-06-28 11:18:02 ICT FATAL: the database system is starting up
2019-06-28 11:18:03 ICT FATAL: the database system is starting up
2019-06-28 11:18:03 ICT FATAL: the database system is starting up
2019-06-28 11:18:04 ICT FATAL: the database system is starting up
2019-06-28 11:18:05 ICT FATAL: the database system is starting up
2019-06-28 11:18:06 ICT FATAL: the database system is starting up
2019-06-28 11:18:07 ICT LOG: database system was not properly shut down; automatic recovery in progress
2019-06-28 11:18:07 ICT FATAL: the database system is starting up
2019-06-28 11:18:07 ICT LOG: redo starts at B/86A556A0
2019-06-28 11:18:07 ICT FATAL: could not access status of transaction 1413782
2019-06-28 11:18:07 ICT DETAIL: Could not read from file "pg_clog/0001" at offset 90112: No error.
2019-06-28 11:18:07 ICT CONTEXT: xlog redo Transaction/COMMIT: 2019-06-27 17:46:18.90281+07
2019-06-28 11:18:07 ICT LOG: startup process (PID 11432) exited with exit code 1
2019-06-28 11:18:07 ICT LOG: aborting startup due to startup process failure
I cannot access SQL Shell(psql) because the service not running
Server [localhost]:
Database [postgres]:
Port [5432]:
Username [openpg]:
psql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?
Enter below command on terminal
pg_lscluster
This will give you status of postgres service and log file path.
Check log file of postgres by entering following command on terminal.
tailf /postgres log file path
This will help to find root cause to fix issue.
try to replace mimetypes.pyc in odoo server from python lib folder. after that restart server
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Try to start/restart you service for the postgreSQL.
I've already done this, but it stops and give me the message I posted.