Thread: 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
From
eshkinkot@gmail.com
Date:
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
From
Heikki Linnakangas
Date:
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