125 reputation
6
bio website cs.cornell.edu/~edward
location Ithaca, NY
age 23
visits member for 2 years, 4 months
seen Aug 29 '13 at 16:40

I'm a graduate student in Computer Science. As a result of my education and several industry internships, I have experience programming in Java, C, C++, and C#. I've also done limited amounts of web development and am familiar with JavaScript and a few web frameworks.


Oct
7
awarded  Autobiographer
Aug
29
accepted Recover PostgreSQL database from WAL errors on startup?
Aug
21
awarded  Popular Question
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?