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:27] – [Disk Caching] paul | how_to:database_issues [2013/06/24 08:36] – [PostgreSQL Log Entries] 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: | ||
- | 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 55: | ||
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** or **PANIC** 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. |
===no pg_hba.conf entry for host ":: | ===no pg_hba.conf entry for host ":: |