3. tar is required to unpack the source distribution, in addition to either gzip or bzip2.. Apart from these, there are two additional pre-requisites libraries which are recommended to have. It has the ability to run an entire script of commands, known as a “Bash shell script”. Start the primary database shell, psql, where you can do all your creation of databases/tables, deletion, set permissions, and run raw SQL commands.Use the -d option to connect to the database you created (without specifying a database, psql will try to access a database that matches your username). google_ad_height = 600; Tables are identified by unique names and hold data in a row and column (record) structure. Become the postgres user. # … To access the psql terminal as the user you are currently logged in, simply type psql. //-->,