Sidebar
how_to:postgresql_server_won_t_start_due_to_damaged_log_files
This is an old revision of the document!
PostgreSQL server won't start due to damaged log files
If the PostgreSQL server won't start at all, because its transaction logs are damaged, you will need to recreate the database store totally.
To do this:
- open a command prompt and find the VPOP\pgsql folder
- rename the data folder to data_old
- run bin\initdb -D <VPOP3folder>\pgsql\data -U postgres -W -A md5
- 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 copy data_old\postgresql.conf data to copy the database server configuration to the new location
- Start the PostgreSQL service in Windows
how_to/postgresql_server_won_t_start_due_to_damaged_log_files.1281086185.txt.gz · Last modified: 2018/11/14 10:44 (external edit)
