I wonder if anyone can help... (I'm running version 7.1.2)
I am trying to rebuild my database after a database corruption
(apparently from a VACUUM ANALYZE). I moved the old PGDATA directory
aside, but now I can't even run `initdb`. I don't understand how I
wouldn't be able to run initdb.
--- postgresql log from `initdb`
postmaster successfully started
DEBUG: database system shutdown was interrupted at 2001-08-14 01:44:45 PDT
DEBUG: CheckPoint record at (0, 768826048)
DEBUG: Redo record at (0, 766174000); Undo record at (0, 723411228); Shutdown FALSE
DEBUG: NextTransactionId: 167461; NextOid: 816519
DEBUG: database system was not properly shut down; automatic recovery in progress...
DEBUG: redo starts at (0, 766174000)
DEBUG: open(logfile 0 seg 48) failed: No such file or directory
DEBUG: redo done at (0, 805306308)
FATAL 2: ZeroFill(/var/pgsql/data/pg_xlog/xlogtemp.29805) failed: No such file or
directory
/usr/local/pgsql/bin/postmaster: Startup proc 29805 exited with status 512 - abort
postmaster successfully started
DEBUG: database system shutdown was interrupted at 2001-08-14 01:45:46 PDT
DEBUG: CheckPoint record at (0, 768826048)
DEBUG: Redo record at (0, 766174000); Undo record at (0, 723411228); Shutdown FALSE
DEBUG: NextTransactionId: 167461; NextOid: 816519
DEBUG: database system was not properly shut down; automatic recovery in progress...
DEBUG: redo starts at (0, 766174000)
DEBUG: open(logfile 0 seg 48) failed: No such file or directory
DEBUG: redo done at (0, 805306308)
FATAL 2: ZeroFill(/var/pgsql/data/pg_xlog/xlogtemp.29872) failed: No such file or
directory
/usr/local/pgsql/bin/postmaster: Startup proc 29872 exited with status 512 - abort
--- postgresql log from VACUUM ANALYZE
DEBUG: XLogWrite: new log file created - consider increasing WAL_FILES
DEBUG: MoveOfflineLogs: remove 0029
DEBUG: MoveOfflineLogs: remove 002A
DEBUG: MoveOfflineLogs: remove 0028
DEBUG: XLogWrite: new log file created - consider increasing WAL_FILES
DEBUG: --Relation pg_type--
DEBUG: Pages 3: Changed 0, reaped 1, Empty 0, New 0; Tup 192: Vac 0, Keep/VTL 0/0,
Crash 0, UnUsed 1, MinLen 106, MaxLen 109; Re-using: Free/Avail. Space 2484/0;
EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG: Index pg_type_oid_index: Pages 2; Tuples 192: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG: Index pg_type_typname_index: Pages 4; Tuples 192: Deleted 0. CPU 0.00s/0.00u
sec.
DEBUG: Analyzing...
DEBUG: --Relation pg_attribute--
DEBUG: Pages 20: Changed 0, reaped 1, Empty 0, New 0; Tup 1499: Vac 0, Keep/VTL 0/0,
Crash 0, UnUsed 37, MinLen 98, MaxLen 98; Re-using: Free/Avail. Space 6256/0;
EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG: Index pg_attribute_relid_attnam_index: Pages 21; Tuples 1499: Deleted 0. CPU
0.00s/0.01u sec.
DEBUG: Index pg_attribute_relid_attnum_index: Pages 10; Tuples 1499: Deleted 0. CPU
0.00s/0.00u sec.
DEBUG: Analyzing...
DEBUG: --Relation pg_class--
DEBUG: Pages 4: Changed 0, reaped 1, Empty 0, New 0; Tup 238: Vac 0, Keep/VTL 0/0,
Crash 0, UnUsed 27, MinLen 115, MaxLen 152; Re-using: Free/Avail. Space 3252/0;
EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG: Index pg_class_oid_index: Pages 4; Tuples 238: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG: Index pg_class_relname_index: Pages 8; Tuples 238: Deleted 0. CPU 0.00s/0.00u
sec.
DEBUG: Analyzing...
DEBUG: --Relation pg_group--
DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 1: Vac 0, Keep/VTL 0/0,
Crash 0, UnUsed 0, MinLen 96, MaxLen 96; Re-using: Free/Avail. Space 0/0;
EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG: Index pg_group_name_index: Pages 2; Tuples 1. CPU 0.00s/0.00u sec.
DEBUG: Index pg_group_sysid_index: Pages 2; Tuples 1. CPU 0.00s/0.00u sec.
DEBUG: Analyzing...
DEBUG: --Relation pg_database--
DEBUG: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 17: Vac 0, Keep/VTL 0/0,
Crash 0, UnUsed 22, MinLen 84, MaxLen 84; Re-using: Free/Avail. Space 6588/0;
EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG: Analyzing...
DEBUG: --Relation pg_attrdef--
DEBUG: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 29: Vac 0, Keep/VTL 0/0,
Crash 0, UnUsed 0, MinLen 141, MaxLen 366; Re-using: Free/Avail. Space 0/0;
EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG: Index pg_attrdef_adrelid_index: Pages 2; Tuples 29. CPU 0.00s/0.00u sec.
DEBUG: --Relation pg_toast_1215--
DEBUG: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0,
Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0;
EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG: Index pg_toast_1215_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG: Analyzing...
DEBUG: --Relation pg_trigger--
DEBUG: Pages 5: Changed 0, reaped 0, Empty 0, New 0; Tup 154: Vac 0, Keep/VTL 0/0,
Crash 0, UnUsed 0, MinLen 152, MaxLen 223; Re-using: Free/Avail. Space 0/0;
EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
DEBUG: Index pg_trigger_tgco