PostgreSQL is installed on Ubuntu, and postgresqlubuntu

PostgreSQL is installed on Ubuntu, and postgresqlubuntu

Installation environment:

Ubuntu 64bit

PostgreSQL 9.0

 

1. Install PostgreSQL

Enter the following command

Sudo apt-get install postgresql

 

The system prompts you to install the required disk space. Enter "y". The installation program is automatically completed. After the installation is complete, the system will create a database superuser "postgres" with a blank password. This user is both an Unlogged operating system user and a database user.

 

2. Modify the ubuntu user's postgres Password

Enter the following command

Sudo passwd ipvs

3. Modify the password of database superuser S

1) switch to ubuntu postgres user

Sudo su postgres

2) log on to the ipvs Database

 

Psql postgres

In this way, you will see the following prompt message for S:

Psql (9.0.0)

Type "help" for help.

The command line prompt symbol of ipvs is displayed:

Postgres = #

3) enter the following command:

Alter user Login s with PASSWORD 'Password'

Type "\ q" to return to the ubuntu command line.