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:vpop3db_postgresql_service_not_starting [2015/05/01 14:41] – paul | how_to:vpop3db_postgresql_service_not_starting [2018/01/02 10:42] – [Other things to try] paul | ||
---|---|---|---|
Line 3: | Line 3: | ||
* [[1069 - Login Failure - error when starting VPOP3DB service]] | * [[1069 - Login Failure - error when starting VPOP3DB service]] | ||
+ | * [[Timeout while VPOP3DB is starting]] | ||
If the PostgreSQL service doesn' | If the PostgreSQL service doesn' | ||
Line 49: | Line 50: | ||
====no pg_hba.conf entry for host ":: | ====no pg_hba.conf entry for host ":: | ||
+ | ====no pg_hba.conf entry for host ":: | ||
This usually happens if the PC where VPOP3 is installed used to only have IPv4 installed, and has now had IPv6 added. The PostgreSQL configuration needs altering to support IPv6. | This usually happens if the PC where VPOP3 is installed used to only have IPv4 installed, and has now had IPv6 added. The PostgreSQL configuration needs altering to support IPv6. | ||
Line 77: | Line 79: | ||
In some cases the last two lines may not exist, in which case you can simply copy those lines from the example above and paste them into your pg_hba.conf file | In some cases the last two lines may not exist, in which case you can simply copy those lines from the example above and paste them into your pg_hba.conf file | ||
- | You will then need to restart the PostgreSQL service in Windows. Note that sometimes PostgreSQL cannot close down properly, and there will be unwanted ' | + | You will then need to restart the VPOP3DB/PostgreSQL service in Windows. Note that sometimes PostgreSQL cannot close down properly, and there will be unwanted ' |
====Shared memory problems==== | ====Shared memory problems==== | ||
Line 125: | Line 127: | ||
In this case, in v6 or later you can manually replace all the PostgreSQL program files without having to reinstall or lose data. To do this, go to a command prompt in the VPOP3 installation directory and run: | In this case, in v6 or later you can manually replace all the PostgreSQL program files without having to reinstall or lose data. To do this, go to a command prompt in the VPOP3 installation directory and run: | ||
+ | ==VPOP3 v6.x== | ||
bsdtar -xvf pgsql.tbz | bsdtar -xvf pgsql.tbz | ||
+ | | ||
+ | ==VPOP3 v7.x== | ||
+ | 7z x -aoa -r pgsql95.7z | ||
That should overwrite all the PostgreSQL program files/ | That should overwrite all the PostgreSQL program files/ |