Search found 732 matches

by id10t
Tue Dec 06, 2016 1:16 am
Forum: Vertica Database Administration
Topic: Hyper threading BIOS setting?
Replies: 2
Views: 1617

Re: Hyper threading BIOS setting?

Hi. In general recommended HT system(it depends on your needs), but you need to understand what is HT vs "not HT"(or ST - single threaded). --- Vertica is optimized for HT (but sometimes ST will give you a better performance). Vertica will response better if you have a lot of simple and small querie...
by id10t
Wed Jan 20, 2016 4:55 pm
Forum: Vertica Database Administration
Topic: Upgrade Vertica 7.1.2 to 7.2.1
Replies: 14
Views: 5179

Re: Upgrade Vertica 7.1.2 to 7.2.1

Hi! * /srv - isn't important for installer, its maybe important for Vertica catalog/data, but not for installer. * RPM uses in /opt, /etc directories and their root is /, where only have "Avial - 1.1G". * LVM isn't recommended, so I`m afraid you will fail on next step also. --- Good luck to you and ...
by id10t
Tue Jan 19, 2016 8:31 pm
Forum: Vertica Database Administration
Topic: Upgrade Vertica 7.1.2 to 7.2.1
Replies: 14
Views: 5179

Re: Upgrade Vertica 7.1.2 to 7.2.1

Hi!

Code: Select all

$ du -bs *
1805840095	unpacked_rpm
425954132	vertica-7.2.1-0.x86_64.RHEL6.rpm
RPM itself about 426Mb and unpacked about 1.806Gb => about 2 GBytes free storage(copy RPM + unpack archive).

(426 megabytes) + (1.806 gigabytes) = 2.232 gigabytes
by id10t
Wed Jan 13, 2016 4:17 pm
Forum: Vertica Database Administration
Topic: Upgrade Vertica 7.1.2 to 7.2.1
Replies: 14
Views: 5179

Re: Upgrade Vertica 7.1.2 to 7.2.1

Hi!
chenshaulian wrote:but I'm really lost ...
As I told you before: package upgrade didn't work. Read the message from terminal:

needs 1396MB on the / filesystem

And if you still don't understand I will show you how it should be(doesn't matter the version):
Image
by id10t
Tue Jan 12, 2016 6:03 pm
Forum: Vertica Database Administration
Topic: Upgrade Vertica 7.1.2 to 7.2.1
Replies: 14
Views: 5179

Re: Upgrade Vertica 7.1.2 to 7.2.1

Hi! After I installed the new HP Vertica Server RPM, by command: rpm -Uvh /home/dbadmin/vertica-x86_64.RHEL6.rpm [...] vertica-7.1.2-0.x86_64 (same on all 3 nodes) So upgrade didn't work, that why you got message: "RPM must be upgraded locally, first." From community forum : the command is: rpm -Uvh...
by id10t
Mon Jan 11, 2016 11:23 am
Forum: Vertica Database Administration
Topic: Upgrade Vertica 7.1.2 to 7.2.1
Replies: 14
Views: 5179

Re: Upgrade Vertica 7.1.2 to 7.2.1

Shalom! https://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/InstallationGuide/InstallingVertica/UpgradingHPVerticaToANewVersion.htm [...] 3. On each host that you have an additional package installed, such as the R Language Pack, uninstall the package. For example: rpm -e vertica-R-lang . [...]...
by id10t
Sun Jan 10, 2016 4:26 pm
Forum: General
Topic: Creating django based REST API with Vertica
Replies: 3
Views: 1645

Re: Creating django based REST API with Vertica

Hi! I know that in release 7.2.x "The Management API is a REST API that you can use to view and manage Vertica databases with scripts or applications that accept REST and JSON. After some tests v7.2.1-x still isn't recommended(unfortunately not stable). I am at a loss on how to create a django based...

Go to advanced search