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.