O restaurar um backup feito via o barman e iniciar o postgresql aparece a
seguinte mensagem "could not open file", a mensagem continua sempre que
inicio o banco.
PostgreSQL: 9.2.4
2013-04-15 17:24:08 BRT LOG: database system was interrupted; last known
up at 2013-04-15 16:22:29 BRT
2013-04-15 17:24:08 BRT LOG: redo starts at 0/13000080
2013-04-15 17:24:08 BRT LOG: consistent recovery state reached at
0/130000A8
2013-04-15 17:24:21 BRT LOG: could not open file
"pg_xlog/00000001000000000000001F" (log file 0, segment 31): No such file
or directory
2013-04-15 17:24:21 BRT LOG: redo done at 0/1EFFDAA8
2013-04-15 17:24:21 BRT LOG: last completed transaction was at log time
2013-04-15 17:19:00.167965-03
2013-04-15 17:24:24 BRT LOG: database system is ready to accept connections
2013-04-15 17:24:24 BRT LOG: autovacuum launcher started
SO: Ubuntu Server 12.10
Dados do barman:
Versão: 1.2.0
Comando executado para recuperar o backup:
barman recover main 20130415T162230 /var/lib/barman/rec/
Starting local restore for server main using backup 20130415T162230
Destination directory: /var/lib/barman/rec/
Copying the base backup.
Copying required wal segments.
The archive_command was set to 'false' to prevent data losses.
Your PostgreSQL server has been successfully prepared for recovery!
barman show-backup main 20130415T162230
Backup 20130415T162230:
Server Name : main
Status : DONE
PostgreSQL Version: 90204
PGDATA directory : /var/lib/postgresql/9.2/main
Base backup information:
Disk usage : 19.0 MiB
Timeline : 1
Begin WAL : 000000010000000000000013
End WAL : 000000010000000000000013
WAL number : 1
Begin time : 2013-04-15 16:22:30.830248
End time : 2013-04-15 16:22:37.501990
Begin Offset : 32
End Offset : 168
Begin XLOG : 0/13000020
End XLOG : 0/130000A8
WAL information:
No of files : 11
Disk usage : 8.0 MiB
Last available : 00000001000000000000001E
Catalog information:
Retention Policy: VALID
Previous Backup : - (this is the oldest base backup)
Next Backup : - (this is the latest base backup)
Como o ultimo arquivo copiado foi 00000001000000000000001E, entao nao
existe mesmo 00000001000000000000001F, seria correto executar o
pg_resetxlog ?
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
