#16 Different paths or files are expected

[Anonymous]

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

[Anonymous]

Originally posted by: itagaki....@gmail.com

This might be the same issue with another thread for DST.
Please see the trunk.

Status: Started