|
I forgot to include the specific error message related to the archival process not finding the file.
From: Sailer, Denis
(YBUSA-CDR) [mailto:Denis.Sailer@xxxxxxxxxxxxxx]
In my development system the file system where $PGDATA resides filled up.
cp: writing `/usr/local/pgsql/archlog/ybcdrdbd01/data/000000010000004300000076': No space left on device could not copy /usr/local/pgsql/data/pg_xlog/000000010000004300000076 to archive 2005-10-23 08:46:29 CDTLOG: archive command "yblogger /usr/local/pgsql/data/pg_xlog/000000010000004300000076 </dev/null" failed: return code 25088 cp: overwrite `/usr/local/pgsql/archlog/ybcdrdbd01/data/000000010000004300000076'? 2005-10-23 08:46:30 CDTLOG: archived transaction log file "000000010 000004300000076" 2005-10-23 08:46:31 CDTLOG: could not close temporary statistics file "/usr/local/pgsql/data/global/pgstat.tmp.27235": No space left on device cp: writing `/usr/local/pgsql/archlog/ybcdrdbd01/data/000000010000004300000077': No space left on device could not copy /usr/local/pgsql/data/pg_xlog/000000010000004300000077 to archive 2005-10-23 08:47:46 CDTLOG: archive command "yblogger /usr/local/pgsql/data/pg_xlog/000000010000004300000077 </dev/null" failed: return code 25088 cp: overwrite `/usr/local/pgsql/archlog/ybcdrdbd01/data/000000010000004300000077'? 2005-10-23 08:47:47 CDTLOG: archived transaction log file "000000010 000004300000077" 2005-10-23 08:47:48 CDTLOG: could not close temporary statistics file "/usr/local/pgsql/data/global/pgstat.tmp.27235": No space left on device cp: writing `/usr/local/pgsql/archlog/ybcdrdbd01/data/000000010000004300000078': No space left on device could not copy /usr/local/pgsql/data/pg_xlog/000000010000004300000078 to archive 2005-10-23 08:49:49 CDTLOG: archive command "yblogger /usr/local/pgsql/data/pg_xlog/000000010000004300000078 </dev/null" failed: return code 25088 cp: overwrite `/usr/local/pgsql/archlog/ybcdrdbd01/data/000000010000004300000078'? 2005-10-23 08:49:51 CDTLOG: archived transaction log file "000000010 000004300000078" 2005-10-23 08:49:52 CDTLOG: could not close temporary statistics file "/usr/local/pgsql/data/global/pgstat.tmp.27235": No space left on device cp: writ
At this point in time postgres had gone away. I tried to restart Postgres, but received these messages. Postgres would not start.
2005-10-24 08:28:04 CDTLOG: database system was interrupted at 2005-10-23 10:01:14 CDT 2005-10-24 08:28:04 CDTLOG: could not open file "/usr/local/pgsql/data/pg_xlog/000000010000004300000043" (log file 67, segment 67): No such file or dir ectory 2005-10-24 08:28:04 CDTLOG: invalid checkpoint record 2005-10-24 08:28:04 CDTPANIC: could not locate required checkpoint record 2005-10-24 08:28:04 CDTHINT: If you are not restoring from a backup, try removing the file "/usr/local/pgsql/data/backup_label". 2005-10-24 08:28:04 CDTLOG: startup process (PID 13345) was terminated by signal 6 2005-10-24 08:28:04 CDTLOG: aborting startup due to startup process failure 2005-10-24 08:28:04 CDTLOG: logger shutting down
Since this is development I used “pg_resetxlog -f /usr/local/pgsql/data”. I then tried to start Postgres, but received the same messages as above. I removed the backup in progress file as stated in the message. Postgres was able to start after that, but now it keeps trying to archive log files that don’t exist.
How can I tell postgres to move to the point in time where log file truncation occurred where the log files now start?
|
