Originally created by: antonin....@gmail.com
Hi,
at first point I want to thank you for very usefull program for postgres
archiving.
Please I'm trying now use pg_rman for creating incremental backups of
postgres 8.3 and I've got some errors.
Scenario:
1. postgresql.conf was configured (archive_mode=on,archive_command = 'cp "%
p" /sdb1/zaloha/"%f"')
2. pg instance was restarted
3. folder for backup files was created (/sdb1/zaloha)
4. configuration file /sdb1/zaloha/pg_rman.ini was created with following
settings:
ARCLOG_PATH = /sdb1/db/data/testpgskt/pg_xlog/
SRVLOG_PATH = /sdb1/db/data/testpgskt/pg_log/
BACKUP_MODE = F
COMPRESS_DATA = YES
KEEP_ARCLOG_FILES = 10
KEEP_ARCLOG_DAYS = 10
KEEP_DATA_GENERATIONS = 3
KEEP_DATA_DAYS = 120
KEEP_SRVLOG_FILES = 10
KEEP_SRVLOG_DAYS = 10
note: /sdb1/db/data/testpgskt/ is $PG_DATA directory
5.I run 'pg_rman backup --backup-mode=full --with-serverlog -
B /sdb1/zaloha' and this is output:
INFO: database backup start
ERROR: can't open destination
file "/sdb1/zaloha/20100311/094918/arclog/archive_status/000000010000000000
00000E.000000A0.backup.done": No such file or directory
We finished with this error meassage, but when I searched for this path
and file I found that there exists only path
/sdb1/zaloha/20100311/094918/arclog/archive_status/
where are these files:
-rw------- 1 postgres postgres 3207619 Mar 11 09:57
00000001000000000000000E
-rw------- 1 postgres postgres 140 Mar 11 09:57
00000001000000000000000E.000000A0.backup
But if I change path of arclog_path to for example /sdb1/arclog (which I
created as new empty directory) I have different behavior:
- When I run 'pg_rman backup --backup-mode=full -B /sdb1/zaloha' it
created full backup and all looks correct
- Incremental backup 'pg_rman backup --backup-mode=incremental -
B /sdb1/zaloha' created backup, but without WAL files
Can you help me with this?
My enviroment is:
Centos 5.3 with Postgresql 8.3 and pg_rman 1.1.2.
Regards
Anthony
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: itagaki....@gmail.com
This might be the same issue with another thread for DST.
Please see the trunk.
Status: Started