| From: | Justin Alston <jusalston(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Postgres 8.2 database recovery Could not create relation Invalid Argument |
| Date: | 2009-07-28 03:29:13 |
| Message-ID: | 2fe027640907272029j4c75a9efnb20c204dc3376e0e@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Novice here :). I have PostgreSQL 8.2 installed on a single board computer
running Windows XP Embedded on a Compact Flash drive - 2 databases with no
more than 2000 ro. After 10 power cycles spaced 6 mins apart, I noticed the
postgres.exe processes no longer running. I located log file (see below) and
it appears postgres attempts to recover but fails to do so. Any suggestions:
2009-07-28 04:31:01 LOG: database system was interrupted at 2009-07-28
04:27:54 GMT Daylight Time
2009-07-28 04:31:01 LOG: checkpoint record is at 0/7CBF58
2009-07-28 04:31:01 LOG: redo record is at 0/7CBF58; undo record is at 0/0;
shutdown TRUE
2009-07-28 04:31:01 LOG: next transaction ID: 0/12290; next OID: 17183
2009-07-28 04:31:01 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2009-07-28 04:31:01 LOG: database system was not properly shut down;
automatic recovery in progress
2009-07-28 04:31:02 LOG: redo starts at 0/7CBFA8
2009-07-28 04:31:02 FATAL: could not create relation 1663/16403/16586:
Invalid argument
2009-07-28 04:31:02 CONTEXT: xlog redo update: rel 1663/16403/16586; tid
35/32; new 35/33
2009-07-28 04:31:02 LOG: startup process (PID 1484) exited with exit code 1
2009-07-28 04:31:02 LOG: aborting startup due to startup process failure
2009-07-28 04:31:02 LOG: logger shutting down
Thanks in advance for any insights.
Jus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brendan Hill | 2009-07-28 04:23:43 | Idle processes chewing up CPU? |
| Previous Message | Tom Lane | 2009-07-28 02:15:47 | Re: A question about the permissions |