Checking the Availability of the Database

Perform basic database-related operations, including starting the database, logging in to the default database, and creating tables, to check whether the database is available. Perform the operations in this section on the master node.

1. Start the database.

   gpstart -a

2. Log in to the default database postgres.

   psql -d postgres

   If the following information is displayed, the database is successfully accessed and the Greenplum cluster is successfully installed:

   psql (9.4.24)
   Type "help" for help.
   
   postgres=#

3. Creates tables.

   To ensure that KAEzip can be enabled, all tables created in the database must be in Zlib compression format. That is, WITH (appendonly=true, orientation=column, compresstype=zlib, compresslevel=5) must be added to the end of the table creation statement.

   Example of the table creation statement:

   CREATE TABLE REGION(R_REGIONKEY NUMERIC(15,2), R_NAME CHAR(25), R_COMMENT VARCHAR(152)) WITH (appendonly=true, orientation=column, compresstype=zlib, compresslevel=5) DISTRIBUTED BY (R_REGIONKEY);