#45 Files owner are not kept when restoring

[Anonymous]

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

What steps will reproduce the problem?
1. backup with root (full-backup, validate)
2. restore with root

What is the expected output? What do you see instead?
Although the restore process was made by root, files should be restored with original owner (user and group postgres in my case).

But this is not the case since all the files are restored with "root" as owner. So postgres cluster can't be launch until doing some chown in $PGDATA and in the WAL log archive folder.

What version of the product are you using? On what operating system?
1.2.1

Please provide any additional information below.
You may ask why restoring these postgres files with root?
This is because I'm using pg_rman on a Debian Lenny. And postgres in this distribution use some SSL files only writable by root (and not postgres). So if I try to restore the backup with the postgres user it fails because of this SSL cert file which can't be erazed by the postgres user.

You should arguee that this is a Debian particular problem and you don't want to take care of it. But fondamentaly, such a restore process make sense being done by root and it then make sense to take care of original owner.

I even want going further and arguee than such a restore process should not be done by another user than root.

Regards,
nm