This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
how_to:database_issues [2013/03/15 08:29] – [PostgreSQL service not starting] paul | how_to:database_issues [2013/06/24 08:35] – [PostgreSQL service not starting] paul | ||
---|---|---|---|
Line 38: | Line 38: | ||
If the PostgreSQL service doesn' | If the PostgreSQL service doesn' | ||
+ | * Look in the Windows // | ||
* Look in the VPOP3\pgsql\data\pg_log folder for a log file created at the time when you started VPOP3. If that is there, you can read that (using Notepad) and see if it reports any problems with files or ' | * Look in the VPOP3\pgsql\data\pg_log folder for a log file created at the time when you started VPOP3. If that is there, you can read that (using Notepad) and see if it reports any problems with files or ' | ||
- | * Look in the Windows event log for entries relating to PostgreSQL | ||
You can also try starting the PostgreSQL service manually: | You can also try starting the PostgreSQL service manually: | ||
- | For VPOP3 v3 and v4, from a command prompt, run "runas / | + | * For VPOP3 v3 and v4, from a command prompt, run "runas / |
- | For VPOP3 v5 and later, from a command prompt, run "runas / | + | |
Then | Then | ||
Line 54: | Line 54: | ||
See what response you get to the pg_ctl command | See what response you get to the pg_ctl command | ||
+ | |||
+ | ====Event Viewer Entries==== | ||
====PostgreSQL Log Entries==== | ====PostgreSQL Log Entries==== | ||
If you get **FATAL** entries in the PostgreSQL log files (in **VPOP3\pgsql\data\pg_log**) then they may give more information about why PostgreSQL could not start. Some log entries we have come across are below. | If you get **FATAL** entries in the PostgreSQL log files (in **VPOP3\pgsql\data\pg_log**) then they may give more information about why PostgreSQL could not start. Some log entries we have come across are below. |