1. How to check POstgresql version. [root@BMDB-02 ~]# psql –version psql (PostgreSQL) 8.1.11 ================= 2. How to create postgreSQL USER…