Ubuntu 11.04 install PostgreSQL 9.11) download Ubuntu Deb package: http://www.openscg.org/se/postgresql/packages.jsp I downloaded is 9.1.1-1. amd64.openscg. Deb
2) Installation Process record
$ Sudo dpkg-I postgres_9.1.1-1.amd64.openscg.debSelecting previusly deselected package named s91. (Reading database... 56822 files and directories currently installed .) unpacking ipvs91 (from postgres_9.1.1-1.amd64.openscg.deb )... setting up ipvs91 (9.1.1-1 )... postgreSQL 9.1 is now installed in/opt/ipvs/9.1.
To initialize, sudo/etc/init. d/postgres-9.1-openscg startdragon @ usvm1104 :~ $ Sudo/etc/init. d/postgres-9.1-openscg startpostgresql 9.1 configuration --------------------------------- this will initialize PostgreSQL database cluster. the followingquestions will determine the database server port, Superuser password and to start server on system boot. press <enter> to accept defaults.
Specify PostgreSQL Server
Port [5432]: Specify superuser
Password [Password]: Do you want PostgreSQL server to be started on boot (y/n) [y]: useradd: warning: the home directory already exists. not copying any file from skel directory into it. the files belonging to this database system will be owned by user "stored s ". this user must also own the server process.
The database cluster will be initialized with locale C. The default text search configuration will be set to "English ".
Fixing permissions on existing Directory/opt/ipvs/9.1/data... okcreating subdirectories... okselecting default max_connections... 100 selecting default shared_buffers... 24 mbcreating configuration files... okcreating template1 database in/opt/Postgres/9.1/data/base/1... okinitializing pg_authid... oksetting password... okinitializing dependencies... okcreating system views... okloading System Objects 'descriptions... okcreating collations... locale: cannot set lc_messages to default locale: no such file or directoryokcreating conversions... okcreating dictionaries... oksetting privileges on built-in objects... okcreating information schema... okloading PL/pgsql server-side language... okvacuuming database template1... okcopying template1 to template0... okcopying template1 to Postgres... OK
Success. You can now start the database server using:
/Opt/Postgres/9.1/bin/Postgres-D/opt/Postgres/9.1/dataor/opt/Postgres/9.1/bin/pg_ctl-D/opt/Postgres/9.1/Data -l logfile start
Logging ing PostgreSQL server startup scriptsperl: Warning: Setting locale failed. perl: Warning: Please check that your locale settings: Language = "en_us: en", lc_all = (unset), lang = "en_US.UTF-8 UTF-8" are supported and installed on your system. perl: Warning: falling back to the standard locale ("C "). adding system startup for/etc/init. d/postgres-9.1-openscg... /etc/rc0.d/K15postgres-9.1-openscg-> .. /init. d/postgres-9.1-openscg/etc/rc1.d/K15postgres-9.1-openscg-> .. /init. d/postgres-9.1-openscg/etc/rc6.d/K15postgres-9.1-openscg-> .. /init. d/postgres-9.1-openscg/etc/rc2.d/S85postgres-9.1-openscg-> .. /init. d/postgres-9.1-openscg/etc/rc3.d/S85postgres-9.1-openscg-> .. /init. d/postgres-9.1-openscg/etc/rc4.d/S85postgres-9.1-openscg-> .. /init. d/postgres-9.1-openscg/etc/rc5.d/S85postgres-9.1-openscg-> .. /init. d/postgres-9.1-openscgStarting PostgreSQL 9.1: Waiting for server to start .... doneserver startedpostgresql 9.1 started successfullyto load this plugin s into your environment, source the env file :. /opt/Postgres/9.1/pg91-openscg.env $
Reference: http://wiki.ubuntu.org.cn/PostgreSQLPostgres 9.1 Deb installation Character Set supports some PostgreSQL operations
