More on Vertica Database Tutorials

(We marked visited pages blue)
  • How to measure the Size of your HP Vertica Database Catalog
  • How to Change HP Vertica Cluster Spread messaging Type
  • How to Change HP Vertica Data Locations and Drop Old Storage Location
  • Vertica Database Script to monitor Data Load Streams
  • HP Vertica 8 "Frontloader" Released
  • Learn how to manage your Vertica Data load Streams
  • How to remove Storage Location in HP Vertica database
  • Fix for Vertica ERROR 2035 COPY Invalid integer format
  • Easy procedure to clone a Vertica Database User
  • How to Disable Vertica Data Collector
  • Vertica database System Tables Lock Down
  • How to Create Vertica Schema on the Fly
  • Vertica Management Console Upgrade 7.2.1 to 7.2.2
  • Fix of Error ERROR AHM must lag behind the create epoch of unrefreshed projection
  • Vertica Dimension Wars and Initial database tunning
  • Welcome Inheritence
  • Dropping Sequences headache
  • Quick and Dirty HP Vertica Schema Clone
  • How to Recover a lost node in Vertica database
  • What about that Vertica WRITE ONCE stuff !
  • Solution for error vsql FATAL 5273 Unsupported frontend protocol 3.5 server supports 3.0 to 3.4
  • How Partition Pruning work in Vertica
  • Transform data during load in Vertica - use variable with COPY
  • How to Skip a column when loading data in Vertica
  • How to Export the Catalog in Vertica
  • How to Skip data when loading data in Vertica Database
  • HP Vertica database validation Scripts
  • Vertica JDBC connection string
  • How to create a Linked Server from SQL Server to HP Vertica
  • Live Documentation in Vertica using comment on
  • Vertica Stock Schema Example Database
  • How to Generate a Stock Schema Example for Vertica Database
  • Vertica Profile Management
  • Fix for Vertica ERROR Join did not fit in memory
  • What are the User Privileges in Vertica database
  • Privileges required for Table operations in HP Vertica
  • How to Manage users accounts in HP Vertica Database
  • How to change the owner of a table in Vertica
  • Vertica Tiered Storage Policies
  • Setting the purge policy in Vertica
  • Managing the Vertica database parameters
  • Migrate entire Schema in Vertica
  • How to Manage and Work with Data Collector in Vertica
  • Create new storage location in HP Vertica database.
  • Understanding Vertica Storage Mechanism
  • How to get the raw size of your data in HP Vertica
  • Working with Merge in Vertica
  • How to work External Tables in Vertica
  • Vertica Superuser(Dbadmin)
  • How to optimize Vertica Merge statement performance
  • How to ignore or avoid a projection to be used in Vertica
  • Uninstall and cleanup an old HP Vertica installation
  • How to Import data from MySQL into Vertica with one single line of code
  • Export data into cvs format from Vertica using the vsql Meta-Commands
  • Working with Vertica TRUST Authentication method
  • Migrate SQL Server to HP Vertica in a single step
  • How to fix HP Vertica Installation FAILED with errors
  • HP Vertica installation error FAIL (S0310) fix
  • HP Vertica installation error FAIL (S0300) fix
  • HP Vertica installation error FAIL (S0150) fix
  • HP Vertica installation error FAIL (S0020) fix
  • Tutoriais Vertica
  • Script to Extract Roles atribution Definition in Vertica
  • Working with HP Vertica Flex Tables
  • Vertica SHOW command
  • Vertica Export & Import a single table
  • How to upgrade the license_key in Vertica database
  • How to Monitor Mergeout in Vertica ?
  • HP Vertica Lock Types and Conflicts Management
  • HP Vertica compute_flextable_keys() function
  • HP Vertica build_flextable_view () function
  • HP Vertica Backup and Recover with examples
  • How to create a Full HP Vertica database backup
  • Find used resources plus the used pool details of a single Vertica statement
  • How to recover a Vertica node from a failed start
  • Vsql command line options in Vertica
  • Vertica Vsql command line examples
  • Vertica troubleshooting teqniques
  • Vertica SHOW command
  • Vertica Segmentation
  • Vertica Management Console Tutorials
  • Vertica Drop Schema command
  • Vertica Database Projections Types
  • Vertica database Export and Import a single table
  • Vertica Database Create User command
  • Vertica Create Schema command
  • Vertica "Copy From" command
  • Vertica Backup and Recover step by step
  • Vertica Alter Schema
  • Vertica admintools options
  • Replication Concepts used in Vertica Database
  • Export and Import a Table in Vertica
  • Drop User in Vertica
  • How delete process works in Vertica database
  • Data Type we can use in Vertica
  • Create Profile in Vertica Database
  • Changing Currency Format in Vertica
  • How to change Vertica Cluster IP address step by step
  • Alter User in Vertica
  • Vertica Projection structure
  • Vertica installation on Linux step by step
  • Vertica hybrid storage model
  • Vertica database Storage Concepts
  • Vertica database Logical and physical schema concepts
  • Vertica database K-safety
  • What are the Data compression and encoding types in Vertica
  • Get your HP Vertica Administrator certification
  • Vertical Cluster Prerequisite Installation
  • Vertica Pos-Installation Tasks
  • Vertica and PHP connector
  • Vertica currency format change
  • Vertica client install on Windows
  • What is HP Vertica Architecture Type Like
  • Upgrade HP Vertica database from 6.1 to 7.0
  • How to Uninstall Vertica Database
  • How to uninstall Vertica database
  • How to start and stop Vertica from admintools comand line
  • How to setup restart policy of our Vertica database using the admintools command line
  • How to recover a Vertica node from a failed start
  • How to re-balance data on Vertica using the admintools command line
  • How to measure disk IO speed in Vertica
  • How to list all Vertica database nodes using the admintools command line
  • Installing Vertica ODBC on Windows
  • Install .NET provider for Vertica
  • How to install a HP Vertica Database Cluster
  • How to find installed packages on Vertica server using the admintools command line
  • How to extract day from timestamp in Vertica
  • How to Export/Import object DDL and data in Vertica
  • How to export data from Vertica to MS Excel
  • What is different in Vertica
  • How to connect to the Vertica database using the admintools command line
  • Change Vertica cluster ip address
  • How to change the LOCALE on Vertica database
  • Change Language in Vertica
  • How to Alter DateStyle in Vertica
  • Vertica Database Replication Concepts
  • What is the Execution model of a HP Vertica query
  • 9 - HP Vertica Database Intro Series
  • 8 - HP Vertica Database Intro Series
  • 7 - HP Vertica Database Intro Series
  • 5 - HP Vertica Database Intro Series
  • HP Vertica Database Key Components
  • 3 - HP Vertica Database Intro Series
  • 2 - HP Vertica Database Intro Series
  • 1 - HP Vertica Database Intro Series
  • HP Vertica Backup Fix for Error RSYNC error in rsync protocol data stream (code 12)

     During the build of a HP Vertica Object backup script i have faced the following error when trying to initiate the backup location. 

    [[email protected] vbr]$ /opt/vertica/bin/vbr.py --task init -c /home/dbadmin/scripts/dba/vbr/Datatbl15_months.ini
    Initializing backup locations.
    Error: Error accessing remote storage: failed to get remote files: rsync: read error: Connection reset by peer (104)
    rsync error: error in rsync protocol data stream (code 12) at io.c(760) [Receiver=3.0.7]
    Init FAILED.
    Solution for this error:
    • it appears that the rsync process was using port 50000  already with a process that was running on my OS.
    • after i have terminated this process Vertica init command completed with success.
    [dbadmin@aodba vbr]$ ps aux | grep rsync | grep -v grep | grep daemon | grep port=50000
    dbadmin  25540  0.0  0.0 101428   368 ?        Ss   Mar17   0:00 /opt/vertica/bin/rsync --daemon --config=/tmp/vbr_rsyncd/vbr_rsyncd.conf --port=50000
    [dbadmin@aodba vbr]$ kill -9 25540
     Completed Vertica VBR init task.
    [[email protected] vbr]$ /opt/vertica/bin/vbr.py --task init -c /home/dbadmin/scripts/dba/vbr/Datatbl15_months.ini
    Initializing backup locations.
    Backup locations initialized.
    I hope this was helpful.


    Leave a comment or a question in the comment area bellow if you fell like


    Be a sport and

    Search

    Loading... Please wait

    Subscribe to our Newsletter

    Be a sport and

    x