how to install GPCC after installing GPDB open sourced version?

[ben]

Hi guys, I'm just starting to learn about GPDB and have already installed GPDB by building the GPDB source code.

I know that the commercial GPDB is equipped with the GPCC  and has also provided a script called gpperfmon_install

to install it. But since I didn't use the commercial binary or rpm package to install GPDB, I don't have

the script to install GPCC. Does anyone know how to install GPCC after installing the GPDB open sourced version?

One more thing about this GPCC install, I checked the GPDB github readme.md file and it seems that I need to build

GPDB with the parameter --enable-gpperfmon. It has also mentioned that gpperfmon is dependent on several libraries like apr, apu, and libsigar.

It has provided a link about how to install libsigar but doesn't provide ways to install apr and apu. Does anyone know how to install apr and apu

with proper versions(I build GPDB with its tag 5.8.0)? Thanks

Regards,

Ben

[Bill Bailey]

Hi Ben

I'm in a similar position where we are starting to take the open source version of Greenplum into use.

if you check the release notes you will see a section describing the difference between the Pivotal commercial release and the open source version

One of them listed is "Support for managing Greenplum Database using Pivotal Greenplum Command Center"

My understanding of this is that Command Center cannot be installed without a license

I have yet to find a suitable open source alternative

Regarding those libraries which operating system are you building on ?

regards,  Bill Bailey

[Robert Eckhardt]

> ***** Email confidentiality notice *****
>
> Xanadu Consultancy Limited is a limited company registered in Ireland with
> registered number 500416 and VAT registered number IE 9793319P. Our
> registered office is at Floor 2, River House, Blackpool Retail & Business
> Park, Cork, Ireland. We have a branch office registered in England and Wales
> with company number FC030315, whose address is at Unit 710 Highgate Studios,
> 53-79 Highgate Road, London, NW5 1TL.
>
> This message is intended solely for the addressee and may contain
> confidential information. If you have received this message in error, please
> send it back to us, and immediately and permanently delete it. Do not use,
> copy or disclose the information contained in this message or in any
> attachment. Xanadu Consultancy Limited cannot accept liability for any
> statements made which are clearly the sender’s own and not expressly made on
> behalf of Xanadu Consultancy Limited.
>
> --
> 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 post to this group, send email to gpdb-...@greenplum.org.
> Visit this group at
> https://groups.google.com/a/greenplum.org/group/gpdb-users/.
> For more options, visit https://groups.google.com/a/greenplum.org/d/optout.

[Robert Eckhardt]

On Mon, May 14, 2018 at 5:46 AM, Bill Bailey <bba...@xanadu.ie> wrote:

> Hi Ben
>
> I'm in a similar position where we are starting to take the open source
> version of Greenplum into use.
> if you check the release notes you will see a section describing the
> difference between the Pivotal commercial release and the open source
> version
> One of them listed is "Support for managing Greenplum Database using Pivotal
> Greenplum Command Center"
> My understanding of this is that Command Center cannot be installed without
> a license
> I have yet to find a suitable open source alternative

GPCC is closed source so in order to use it you need a license.

wrt an open source alternative. pgAdmin 4 works with Greenplum 5.x it
has some management features. What in particular are you looking for,
perhaps others can suggest things.

-- Rob

>
> Regarding those libraries which operating system are you building on ?
>
> regards, Bill Bailey
>
> On Monday, 14 May 2018 05:53:42 UTC+1, ben wrote:
>>
>> Hi guys, I'm just starting to learn about GPDB and have already installed
>> GPDB by building the GPDB source code.
>> I know that the commercial GPDB is equipped with the GPCC and has also
>> provided a script called gpperfmon_install
>> to install it. But since I didn't use the commercial binary or rpm package
>> to install GPDB, I don't have
>> the script to install GPCC. Does anyone know how to install GPCC after
>> installing the GPDB open sourced version?
>>
>> One more thing about this GPCC install, I checked the GPDB github
>> readme.md file and it seems that I need to build
>> GPDB with the parameter --enable-gpperfmon. It has also mentioned that
>> gpperfmon is dependent on several libraries like apr, apu, and libsigar.
>> It has provided a link about how to install libsigar but doesn't provide
>> ways to install apr and apu. Does anyone know how to install apr and apu
>> with proper versions(I build GPDB with its tag 5.8.0)? Thanks
>>
>> Regards,
>> Ben
>
>

[Bill Bailey]

I think that for Centos it was simply a case of installing the apr-util-devel package - "yum install apr-util-devel"
I didn't need to install any apu library and perfmon worked OK

On Monday, 14 May 2018 05:53:42 UTC+1, ben wrote:

[Dmitry Dorofeev]

On 14/05/2018 17:21 PM, Bill Bailey wrote:

I think that for Centos it was simply a case of installing the apr-util-devel package - "yum install apr-util-devel"

You might need more packages, I used saltstack for building GPDB, it is not completed yet, but might be useful even as reference, please check here:
https://github.com/luxms/greenplum-salt/blob/dev/salt/gp/build-pkg-deps.sls

Also, building sigar is not straightforward, note that it is quite outdated library, try this:

env CMAKE_C_FLAGS=-fgnu89-inline CFLAGS=-fgnu89-inline cmake3 ..


more hints are here: https://github.com/luxms/greenplum-salt/blob/dev/salt/gp/build/sigar.sls

-Dmitry.

I didn't need to install any apu library and perfmon worked OK

On Monday, 14 May 2018 05:53:42 UTC+1, ben wrote:

One more thing about this GPCC install, I checked the GPDB github readme.md file and it seems that I need to build

GPDB with the parameter --enable-gpperfmon. It has also mentioned that gpperfmon is dependent on several libraries like apr, apu, and libsigar.

It has provided a link about how to install libsigar but doesn't provide ways to install apr and apu. Does anyone know how to install apr and apu

with proper versions(I build GPDB with its tag 5.8.0)? Thanks

[Vishal Patel]

Another useful tool is Aginity Workbench for Greenplum (http://www.aginity.com/workbench/greenplum/). Provides some features around viewing data distribution etc. 

To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+unsubscribe@greenplum.org.

To post to this group, send email to gpdb-...@greenplum.org.
Visit this group at https://groups.google.com/a/greenplum.org/group/gpdb-users/.
For more options, visit https://groups.google.com/a/greenplum.org/d/optout.

--
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+unsubscribe@greenplum.org.

[ben]

Thanks guys for your help, I'm using CentOS 7 in an openstack environment. I just need a tool so that I could manage the GPDB with a UI, 

I'm actually choosing GPDB and its utilities as data warehouse tool for my team and it would be much easier for the testing and deployment guy to maintain  GPDB with a UI.

I was trying to build GPDB from source code and install its utilities(GPCC) with binary or rpm packages.

I did install the apr-util-devel package after some time of search on google(it was really hard to find greenplum open source build reference on google) and I saw the script gpperfmon_install created.

I then tried to follow pivotal's document about creating the gpperfmon database with gpperfmon_install, but it failed without logging any failure reason, it just showed createdb gpperfmon error.

Hi Bill & Robert, about the license problem you mentioned, do you mean that I need to pay pivotal to get a license for the GPCC packages to be delivered to my customers? 

If this is the case, I may have to use the free and open sourced tool as you have mentioned like pgAdmin and Aginity Workbench.

/Ben

[Michael Schubert]

On Mon, May 14, 2018 at 9:14 PM, ben <batm...@gmail.com> wrote:

Thanks guys for your help, I'm using CentOS 7 in an openstack environment. I just need a tool so that I could manage the GPDB with a UI, 

I'm actually choosing GPDB and its utilities as data warehouse tool for my team and it would be much easier for the testing and deployment guy to maintain  GPDB with a UI.

I was trying to build GPDB from source code and install its utilities(GPCC) with binary or rpm packages.

I did install the apr-util-devel package after some time of search on google(it was really hard to find greenplum open source build reference on google) and I saw the script gpperfmon_install created.

I then tried to follow pivotal's document about creating the gpperfmon database with gpperfmon_install, but it failed without logging any failure reason, it just showed createdb gpperfmon error.

Hi Bill & Robert, about the license problem you mentioned, do you mean that I need to pay pivotal to get a license for the GPCC packages to be delivered to my customers? 

If this is the case, I may have to use the free and open sourced tool as you have mentioned like pgAdmin and Aginity Workbench.

Yes. GPCC is closed source, commercial software. It is not licensed separately but included with the commercial version of Greenplum.

 

/Ben

On Monday, May 14, 2018 at 12:53:42 PM UTC+8, ben wrote:

Hi guys, I'm just starting to learn about GPDB and have already installed GPDB by building the GPDB source code.

I know that the commercial GPDB is equipped with the GPCC  and has also provided a script called gpperfmon_install

to install it. But since I didn't use the commercial binary or rpm package to install GPDB, I don't have

the script to install GPCC. Does anyone know how to install GPCC after installing the GPDB open sourced version?

One more thing about this GPCC install, I checked the GPDB github readme.md file and it seems that I need to build

GPDB with the parameter --enable-gpperfmon. It has also mentioned that gpperfmon is dependent on several libraries like apr, apu, and libsigar.

It has provided a link about how to install libsigar but doesn't provide ways to install apr and apu. Does anyone know how to install apr and apu

with proper versions(I build GPDB with its tag 5.8.0)? Thanks

Regards,

Ben

--

[ben]

Hi Michael, do you mean that I need to pay pivotal to get the license to use the commercial GPDB? Thanks.

/Ben

To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+...@greenplum.org.

[Jasper Li]

For production, it is true.

It looks that you are redistributing open source Greenplum. Then if your customer could pay for the license, it can use both GPCC and Pivotal Greenplum instead of open source one.

Best wishes

Jasper

--

To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+unsubscribe@greenplum.org.

[ben]

Thanks Jasper, then I will go with the open sourced gpdb.