Tablespace and filespace 5.X to 6.X.

44 views
Skip to first unread message

Maciej Wawrzyniak

unread,
Mar 8, 2021, 6:06:29 AM3/8/21
to Greenplum Users
Hi, 

I'm migrating from 5.X to 6.X, and we came across to inconvenient tablespace migration.
Our servers have local disk mounted in [/disk1, /disk2, /disk3, /disk4, /disk5, /disk6]. In 5.X version we have made filespace "data_disks" on the above-mentioned paths. In 6.X version we have to make 6 TABLESPACE in 6 paths. It makes more work in migration topic and further db administration.

Is there any workaround, to do this like in 5.X v ?

Nirali Sura

unread,
Mar 8, 2021, 1:33:40 PM3/8/21
to Maciej Wawrzyniak, Greenplum Users

Hi,

We have an in-place upgrade tool called “gpupgrade” that could help you in this case.

 

The Greenplum Database upgrade utility migrates data stored in a Greenplum Database 5.28 to a latest 6.x Greenplum Database major release, without requiring the time and space consuming migration options typically used for major version upgrades.
Documentation: https://gpdb.docs.pivotal.io/upgrade/1-0/index.html
Release: https://github.com/greenplum-db/gpupgrade/releases/tag/1.0.0

 

Best,
Nirali Sura

Linux Polska Sp. z o.o.

Al. Jerozolimskie 100, 00-807 Warszawa

tel. +48 22 213 95 71, fax +48 22 213 96 71

KRS 00000326158, Sąd Rejonowy dla M. St. Warszawy w Warszawie, XII Wydział Gospodarczy KRS

Kapitał zakładowy 1 000 500 PLN wpłacony w całości, NIP 7010181018, REGON 141791601

 

www.linuxpolska.pl |    

_________________________________________________________________________

  

This message may contain confidential information that is covered by legal privilege. If you are not the intended recipient or if you have received this message by mistake, please notify the sender immediately and delete this e-mail and its attachments from your system. Any unauthorized copying, disclosure or distribution of the material in this e-mail and its attachments is strictly forbidden.




Image removed by sender.

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+...@greenplum.org.
To view this discussion on the web visit https://groups.google.com/a/greenplum.org/d/msgid/gpdb-users/e2c0575d-bbae-4c26-9a23-190437d5097fn%40greenplum.org.

Maciej Wawrzyniak

unread,
Mar 9, 2021, 5:44:44 AM3/9/21
to Greenplum Users, nir...@vmware.com, Maciej Wawrzyniak
Hi,

my question was related more about "is there a way to make tablespace on multiple paths in GP 6.X ? ".

Thank you in advance for your help :)

Joe Manning

unread,
Mar 9, 2021, 9:32:29 AM3/9/21
to Maciej Wawrzyniak, Greenplum Users

Hi.

 

The syntax to create a tablespace is given in the Documentation

 

CREATE TABLESPACE tablespace_name [OWNER username]  LOCATION '/path/to/dir'

   [WITH (contentID_1='/path/to/dir1'[, contentID_2='/path/to/dir2' ... ])]

 

So you could create tablespace ts01 with:

CREATE TABLESPACE ts01 LOCATION ‘/data1’ WITH (

content0=’/data1’,

content1=’/data2’,

content2=’/data3’,

content3=’/data4’,

content4=’/data5’,

content5=’/data6’,

content6=’/data1’,

content7=’/data2’,

content8=’/data3’,

  :

 :

;

 

So you put the tablespace for particular segments on different filesystem.

The above would presume that you have 6 or a multiple of 6 segments on each segment server to get an even spread across the different filesystems.

 

Why not use the different filesystems/directories to create the segments when initializing the DB?

Or is there another set of filesystems for the initialization?

 

Regards,

joe.

 

From: Maciej Wawrzyniak <maciej.w...@linuxpolska.pl>
Date: Tuesday 9 March 2021 at 10:44
To: Greenplum Users <gpdb-...@greenplum.org>
Cc: Nirali Sura <nir...@vmware.com>, Maciej Wawrzyniak <maciej.w...@linuxpolska.pl>
Subject: Re: [gpdb-users] Tablespace and filespace 5.X to 6.X.

 

Hi,

 

my question was related more about "is there a way to make tablespace on multiple paths in GP 6.X ? ".

 

Thank you in advance for your help :)

 

poniedziałek, 8 marca 2021 o 19:33:40 UTC+1 nir...@vmware.com napisał(a):

Hi,

We have an in-place upgrade tool called “gpupgrade” that could help you in this case.

 

The Greenplum Database upgrade utility migrates data stored in a Greenplum Database 5.28 to a latest 6.x Greenplum Database major release, without requiring the time and space consuming migration options typically used for major version upgrades.
Documentation: https://gpdb.docs.pivotal.io/upgrade/1-0/index.html
Release: https://github.com/greenplum-db/gpupgrade/releases/tag/1.0.0

 

Best,
Nirali Sura

From: Maciej Wawrzyniak <maciej.w...@linuxpolska.pl>
Date: Monday, March 8, 2021 at 3:06 AM
To: Greenplum Users <gpdb-...@greenplum.org>
Subject: [gpdb-users] Tablespace and filespace 5.X to 6.X.

 

Hi, 

 

I'm migrating from 5.X to 6.X, and we came across to inconvenient tablespace migration.

Our servers have local disk mounted in [/disk1, /disk2, /disk3, /disk4, /disk5, /disk6]. In 5.X version we have made filespace "data_disks" on the above-mentioned paths. In 6.X version we have to make 6 TABLESPACE in 6 paths. It makes more work in migration topic and further db administration.

 

Is there any workaround, to do this like in 5.X v ?

 

 

Linux Polska Sp. z o.o.

Al. Jerozolimskie 100, 00-807 Warszawa

tel. +48 22 213 95 71, fax +48 22 213 96 71

KRS 00000326158, Sąd Rejonowy dla M. St. Warszawy w Warszawie, XII Wydział Gospodarczy KRS

Kapitał zakładowy 1 000 500 PLN wpłacony w całości, NIP 7010181018, REGON 141791601

 

_________________________________________________________________________

  

This message may contain confidential information that is covered by legal privilege. If you are not the intended recipient or if you have received this message by mistake, please notify the sender immediately and delete this e-mail and its attachments from your system. Any unauthorized copying, disclosure or distribution of the material in this e-mail and its attachments is strictly forbidden.

 

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+...@greenplum.org.
To view this discussion on the web visit https://groups.google.com/a/greenplum.org/d/msgid/gpdb-users/e2c0575d-bbae-4c26-9a23-190437d5097fn%40greenplum.org.

 

Linux Polska Sp. z o.o.

Al. Jerozolimskie 100, 00-807 Warszawa

tel. +48 22 213 95 71, fax +48 22 213 96 71

KRS 00000326158, Sąd Rejonowy dla M. St. Warszawy w Warszawie, XII Wydział Gospodarczy KRS

Kapitał zakładowy 1 000 500 PLN wpłacony w całości, NIP 7010181018, REGON 141791601

 

www.linuxpolska.pl |    

_________________________________________________________________________

  

This message may contain confidential information that is covered by legal privilege. If you are not the intended recipient or if you have received this message by mistake, please notify the sender immediately and delete this e-mail and its attachments from your system. Any unauthorized copying, disclosure or distribution of the material in this e-mail and its attachments is strictly forbidden.




--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+...@greenplum.org.

Reply all
Reply to author
Forward
0 new messages