User Tools

Site Tools


how_to:postgresql_server_won_t_start_due_to_damaged_log_files

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Last revisionBoth sides next revision
how_to:postgresql_server_won_t_start_due_to_damaged_log_files [2015/09/23 13:46] – external edit 127.0.0.1how_to:postgresql_server_won_t_start_due_to_damaged_log_files [2018/04/09 10:19] paul
Line 8: Line 8:
   - Run <code>bin\initdb -D <VPOP3folder>\pgsql\data -U postgres -W -A md5</code>   - Run <code>bin\initdb -D <VPOP3folder>\pgsql\data -U postgres -W -A md5</code>
   - When it prompts for a password, type in the password you want for the PostgreSQL superuser - we use **pgsqlpass**. If you choose to use something different, make sure you remember what it is!   - When it prompts for a password, type in the password you want for the PostgreSQL superuser - we use **pgsqlpass**. If you choose to use something different, make sure you remember what it is!
-  - Type <code>copy data_old\postgresql.conf data</code> to copy the database server configuration to the new location. You may be prompted if you want to overwrite the existing file. If so, confirm the overwrite.+  - Type <code>copy data_old\postgresql.conf data</code><code>copy data_old\vpop3db.conf data</code><code>copy data_old\vpop3dbuser.conf data</code> to copy the database server configuration to the new location. You may be prompted if you want to overwrite the existing file. If so, confirm the overwrite.
   - Set the permissions on the new Data folder. In Windows Explorer, right-click the VPOP3\pgsql\DATA folder and choose 'Properties' -> 'Security'. Check that the 'vpop3postgres' user ('postgres' user in VPOP3 versions 3 and 4) has 'Full control' of the folder.   - Set the permissions on the new Data folder. In Windows Explorer, right-click the VPOP3\pgsql\DATA folder and choose 'Properties' -> 'Security'. Check that the 'vpop3postgres' user ('postgres' user in VPOP3 versions 3 and 4) has 'Full control' of the folder.
   - Start the PostgreSQL service in Windows   - Start the PostgreSQL service in Windows
how_to/postgresql_server_won_t_start_due_to_damaged_log_files.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1