network profile
| bio | website | cs.brown.edu/people/etremel |
|---|---|---|
| location | Seattle, WA | |
| age | 22 | |
| visits | member for | 10 months |
| seen | Aug 13 '12 at 16:26 | |
| stats | profile views | 5 |
|
Jul 24 |
comment |
Recover PostgreSQL database from WAL errors on startup? @CraigRinger According to psql, it's 9.1.4. |
|
Jul 22 |
comment |
Recover PostgreSQL database from WAL errors on startup? Thanks for posting that question to the mailing list, though there doesn't seem to be any responses to it yet. In the meantime, I can tell you that I used the /etc/init.d/postgresql restart script to restart PostgresSQL, and never used kill -9. (Question updated, too). |
|
Jul 22 |
revised |
Recover PostgreSQL database from WAL errors on startup? added more detail about restarting postgres |
|
Jul 19 |
awarded | Supporter |
|
Jul 18 |
revised |
Recover PostgreSQL database from WAL errors on startup? added another log pastebin |
|
Jul 18 |
comment |
Recover PostgreSQL database from WAL errors on startup? Yes, that's the entire log file. The very next log file in the sequence starts with the line 2012-07-13 00:31:22 UTC LOG: database system was interrupted; last known up at 2012-07-13 00:15:20 UTC so there are no more messages from the shutdown process. (I added a pastebin of the next log since it's also the one where you see the WAL errors). |
|
Jul 17 |
awarded | Scholar |
|
Jul 17 |
comment |
Drop and restore PostgresSQL database without losing settings OK, I guess I'll just copy the log and configuration files and copy them back after the drop and restore. Thanks for the advice on running initdb. |
|
Jul 17 |
accepted | Drop and restore PostgresSQL database without losing settings |
|
Jul 17 |
comment |
Recover PostgreSQL database from WAL errors on startup? I updated my question to include the relevant logs. I hope this helps. (Actually I did that yesterday, but I just realized StackExchange doesn't give you a notification when I edit the question, like it does when I comment). |
|
Jul 16 |
asked | Drop and restore PostgresSQL database without losing settings |
|
Jul 16 |
answered | Should I add an arbitrary length limit to VARCHAR columns? |
|
Jul 16 |
awarded | Editor |
|
Jul 16 |
revised |
Recover PostgreSQL database from WAL errors on startup? udpated with more logs |
|
Jul 16 |
awarded | Student |
|
Jul 13 |
asked | Recover PostgreSQL database from WAL errors on startup? |
