From: | Hari Babu <haribabu(dot)kommi(at)huawei(dot)com> |
---|---|
To: | "'PostgreSQL-development'" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | pg_basebackup is taking backup of extra files inside a tablespace directory |
Date: | 2012-11-28 06:55:31 |
Message-ID: | 007301cdcd35$5c086ff0$14194fd0$@kommi@huawei.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
pg_basebackup is taking backup of extra files other than database related
files in side a TABLESPACE directory.
Scenario:
1) Create tablespace in existing directory '/opt/tblspc' having
some extra files and folders.
create tablespace tbs1 location '/opt/tblspc';
2) Now execute the pg_basebackup command;
We can see it will copy the extra files in '/opt/tblspc'
directory
I think backup should be done only files and folders present inside
'/opt/tblspc/PG_*' directory (TABLESPACE_VERSION_DIRECTORY).
Not all the files and folders in side '/opt/tblspc.' directory.
Is it ok to fix in the following way?
In function perform_base_backup,
while sending the tablespaces one by one we can send the header for
Linkpath/TABLESPACE_VERSION_DIRECTORY
as separate header and sendDir for "Linkpath/TABLESPACE_VERSION_DIRECTORY "
as path.
Regards,
Hari babu.
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2012-11-28 07:12:30 | Re: pg_basebackup is taking backup of extra files inside a tablespace directory |
Previous Message | Shigeru Hanada | 2012-11-28 06:42:02 | Re: FDW for PostgreSQL |