Обсуждение: BUG #7986: base backup copy all files from tablespace, not only needed data

Поиск
Список
Период
Сортировка

BUG #7986: base backup copy all files from tablespace, not only needed data

От
eshkinkot@gmail.com
Дата:
The following bug has been logged on the website:

Bug reference:      7986
Logged by:          Sergey Burladyan
Email address:      eshkinkot@gmail.com
PostgreSQL version: 9.2.3
Operating system:   Debian GNU/Linux 7.0 (wheezy)
Description:        =


I have one tablespace dir with multiple versions:
$ ls -la ~/inst/var/l/
=D0=B8=D1=82=D0=BE=D0=B3=D0=BE 16
drwx------ 4 seb seb 4096 =D0=9C=D0=B0=D1=80 23 18:26 .
drwxr-xr-x 7 seb seb 4096 =D0=9C=D0=B0=D1=80 23 18:28 ..
drwx------ 3 seb seb 4096 =D0=9C=D0=B0=D1=80 23 18:24 PG_9.2_201204301
drwx------ 3 seb seb 4096 =D0=9C=D0=B0=D1=80 23 18:26 PG_9.3_201303201

../pg-dev-master/bin/pg_basebackup -Ft -D backup copy all subdirectorys from
tablespace dir:
$ tar -tf backup/16384.tar =

PG_9.2_201204301/
PG_9.2_201204301/12042/
PG_9.2_201204301/12042/16385
PG_9.3_201303201/
PG_9.3_201303201/12070/
PG_9.3_201303201/12070/16385
PG_9.3_201303201/12070/16390
PG_9.3_201303201/12070/16388

IMHO it must copy only self version dir PG_9.3_201303201

Re: BUG #7986: base backup copy all files from tablespace, not only needed data

От
Heikki Linnakangas
Дата:
On 23.03.2013 16:39, eshkinkot@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      7986
> Logged by:          Sergey Burladyan
> Email address:      eshkinkot@gmail.com
> PostgreSQL version: 9.2.3
> Operating system:   Debian GNU/Linux 7.0 (wheezy)
> Description:
>
> I have one tablespace dir with multiple versions:
> $ ls -la ~/inst/var/l/
> =D0=B8=D1=82=D0=BE=D0=B3=D0=BE 16
> drwx------ 4 seb seb 4096 =D0=9C=D0=B0=D1=80 23 18:26 .
> drwxr-xr-x 7 seb seb 4096 =D0=9C=D0=B0=D1=80 23 18:28 ..
> drwx------ 3 seb seb 4096 =D0=9C=D0=B0=D1=80 23 18:24 PG_9.2_201204301
> drwx------ 3 seb seb 4096 =D0=9C=D0=B0=D1=80 23 18:26 PG_9.3_201303201
>
> ../pg-dev-master/bin/pg_basebackup -Ft -D backup copy all subdirectorys=
 from
> tablespace dir:
> $ tar -tf backup/16384.tar
> PG_9.2_201204301/
> PG_9.2_201204301/12042/
> PG_9.2_201204301/12042/16385
> PG_9.3_201303201/
> PG_9.3_201303201/12070/
> PG_9.3_201303201/12070/16385
> PG_9.3_201303201/12070/16390
> PG_9.3_201303201/12070/16388
>
> IMHO it must copy only self version dir PG_9.3_201303201

Agreed. Fixed, thanks for the report.

- Heikki