#21 Validate throwing errors - even though pg_rman generated the right backup files and name. Validate is not able to read the directory.

[Anonymous]

Originally created by: bsde...@gmail.com

Hello There,

1. Installed pg_rman and created a full backup.
2. Trying to validate backup and getting below error message as "no such
file or directory"
3. I am using the latest release from the site pg_rman v1.1.2.

The file name that pg_rman backup created was 151651, but when i try to
validate it is looking for file 161651.

------------------------------------------
[postgres@fdbr-res0000 pg_rman]$ pg_rman validate -B /dba_area/fanrr/pg_bk
INFO: validate: 2010-05-24 16:16:51
ERROR: can't open
"/dba_area/fanrr/pg_bk/20100524/161651/file_database.txt": No such file or
directory

[postgres@fdbr-res0000 pg_rman]$ cd /dba_area/fanrr/pg_bk/20100524/
[postgres@fdbr-res0000 20100524]$ ls -lthr
total 4.0K
drwx------ 5 postgres 26 4.0K May 24 15:17 151651

Any fix for this problem
---
Thanks
Deepak

[Anonymous]

Originally posted by: scheu.po...@gmail.com

Hi

It seems to be the same issue that I had a few weeks ago
I have submitted issue n°20 for that :
http://code.google.com/p/pg-rman/issues/detail?id=20&colspec=ID%20Status%20Summary%20Type%20Priority%20Owner

If you have a difference of 1 hour between time of backup and time displayed in
"validate" commande, it is probably caused by daylight issue (summer time)

If you read my issue entirely, I have proposed at the end some workarounds that you
could use to fix it :
- modify C files to add "tm.tm_isdst = -1;" for all time structures (check in any C
file and not only pgut/pgut.c file)
- or set TZ Unix parameter (example : Europe/Paris) before running any pg_rman command

Hope it will help you

Regards

[Anonymous]

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

Thanks. I applied "tm_isdst = -1" for each place struct tm is used to trunk.

Status: Started