Category

Vasudeva Rao

Procedure for Backup methods in Greenplum Database

Purpose of the Document Procedure for Greenplum Database Backup on any DB versions of Greenplum. Procedure ================================================================ Checking Disk Space Usage ================================================================ Before taking a backup of each schema’s just check the DB size of each schema from Greenplum database. Login in to server as a root user.

Read More »

User and Schema Creation in Greenplum Database

Purpose of the Document Procedure for Creation of User / Database (Schema) on any DB versions of Greenplum. Procedure ================================================================      Create User Accounts ================================================================     Use the following procedure to create user account. (i)Login in to the server as a toot user (ii) switch in to gpadmin user (iii)

Read More »

Checking Greenplum Database Status – Linux

Purpose of the Document Procedure for Greenplum Database Start / Stop / Restart on any DB versions of Greenplum servers on Linux systems. To monitor a Greenplum Database system, you need to know information about the system as well as status information of the individual instances. The gpstate

Read More »