Installation of Ubuntu PostgreSQL

1. sudo apt-get install PostgreSQL

2. Sudo su postgres

3, change the password (PostgreSQL installed after a default user and the default database, the name is Postgres, we need to set a password before you can connect)

　　

4. Connection

Psql-u postgres-d postgres-h 127.0.0.1-p 5432

You need to specify the user name and the data that will be used, then you will be prompted for the password, enter the password for the 3rd step change

Installation of Ubuntu PostgreSQL