Install and uninstall Ubuntu-PostgreSQL

Installation:

Sudo apt-Get install PostgreSQL set the password Sudo-u Postgres Psql Postgres = # alter User Login s with password 'login s '; postgres = # \ qsudo passwd-D unzip ssudo-u Postgres passwd change configuration file sudo Vim/etc/PostgreSQL/8.4/main/PostgreSQL. conflisten_addresses = '*' password_encryption = onsudo Vim/etc/PostgreSQL/8.4/main/pg_assist.conf host all 0.0.0.0/0 md5sudo/etc/init. d/PostgreSQL restart test connection Psql-u Postgres -H 127.0.0.1postgres = # Install the GUI management tool sudo apt-Get install pgadmin3 uninstall dpkg -- list | grep PostgreSQL dpkg -- purge <insert packagehere> and then reinstall and use aptitude to install PostgreSQL, you can obtain all the configuration files again. Reference: http://www.cnblogs.com/ctou45/archive/2011/05/26/2057852.html http://zh-cn.w3support.net/index.php? DB = Su & id = 76495