PostgreSQL Installation Guide on Ubuntu

Installation environment: Ubuntu10.04-desktop-i386PostgreSQL8.41. Installation PostgreSQL enter the following command sudoapt-getinstallpostgresql system will prompt to install the required disk space, enter "y", the installer will be completed automatically. After the installation is complete, the system will create a database superuser "postgres" with a blank password. This user is not allowed to log on

Installation environment:

Ubuntu 10.04-desktop-i386

PostgreSQL 8.4

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 Linux User's postgres Password

Enter the following command

Sudo passwd ipvs

3. Modify the password of database superuser S

1) switch to postgres user in Linux

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 (8.4.4)

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 "exit" to return to the Linux Command Line.