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 revision Previous revision
Next revision
Previous revision
how_to:postgresql_server_won_t_start_due_to_damaged_log_files [2015/09/23 13:46]
127.0.0.1 external edit
how_to:postgresql_server_won_t_start_due_to_damaged_log_files [2018/11/14 10:45] (current)
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 (external edit)