This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
how_to:postgresql_server_won_t_start_due_to_damaged_log_files [2012/12/05 09:39] – [PostgreSQL server won't start due to damaged log files] paul | how_to:postgresql_server_won_t_start_due_to_damaged_log_files [2018/11/14 10:45] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 2: | Line 2: | ||
If the PostgreSQL server won't start at all, because its transaction logs are damaged, you will probably need to recreate the database store totally. | If the PostgreSQL server won't start at all, because its transaction logs are damaged, you will probably need to recreate the database store totally. | ||
- | |||
- | You **may** be able to use the **[[http:// | ||
To rebuild the database: | To rebuild the database: | ||
Line 10: | Line 8: | ||
- Run < | - Run < | ||
- 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 < | + | - Type < |
- Set the permissions on the new Data folder. In Windows Explorer, right-click the VPOP3\pgsql\DATA folder and choose ' | - Set the permissions on the new Data folder. In Windows Explorer, right-click the VPOP3\pgsql\DATA folder and choose ' | ||
- Start the PostgreSQL service in Windows | - Start the PostgreSQL service in Windows | ||
Line 18: | Line 16: | ||
Once you're happy everything is working OK, you can delete the **data_old** folder. | Once you're happy everything is working OK, you can delete the **data_old** folder. | ||
- | If you wish, we can remote into your server and try to recover the data for you, but there will be a [[http:// | + | If you wish, we can remote into your server and try to recover the data for you, but there will be a [[http:// |
=====Possible Causes===== | =====Possible Causes===== | ||
Line 26: | Line 24: | ||
The only files in the pgsql\data folder which should ever be accessed by anything other than PostgreSQL itself are the contents of the '' | The only files in the pgsql\data folder which should ever be accessed by anything other than PostgreSQL itself are the contents of the '' | ||
+ | |||
+ | |||
+ | ====Possible alternative solution==== | ||
+ | You **may** be able to use the **[[http:// | ||