Author: 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. Switch the user to gpadmin    :    su…
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) Run the command :  psql postgres (iv)…
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 utility provides status information about a Greenplum…
Read more