Ubuntu 11.04 安装 PostgreSQL 9.1

1) 下载 PostgreSQL 9.1 的Ubuntu deb包

下载地址：http://www.openscg.org/se/postgresql/packages.jsp

 

 

 

我下载的是 9.1.1-1.amd64.openscg.deb

2) 安装过程记录

$ sudo dpkg -i postgres_9.1.1-1.amd64.openscg.deb 

Selecting previously deselected package postgres91.

(Reading database ... 56822 files and directories currently installed.)

Unpacking postgres91 (from postgres_9.1.1-1.amd64.openscg.deb) ...

Setting up postgres91 (9.1.1-1) ...

PostgreSQL 9.1 is now installed in /opt/postgres/9.1.

To initialize, sudo /etc/init.d/postgres-9.1-openscg start

dragon@usvm1104:~$ sudo /etc/init.d/postgres-9.1-openscg start

PostgreSQL 9.1 Configuration

---------------------------------

This will initialize PostgreSQL database cluster. The following

questions 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 "postgres".

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/postgres/9.1/data ... ok

creating subdirectories ... ok

selecting default max_connections ... 100

selecting default shared_buffers ... 24MB

creating configuration files ... ok

creating template1 database in /opt/postgres/9.1/data/base/1 ... ok

initializing pg_authid ... ok

setting password ... ok

initializing dependencies ... ok

creating system views ... ok

loading system objects' descriptions ... ok

creating collations ... locale: Cannot set LC_MESSAGES to default locale: No such file or directory

ok

creating conversions ... ok

creating dictionaries ... ok

setting privileges on built-in objects ... ok

creating information schema ... ok

loading PL/pgSQL server-side language ... ok

vacuuming database template1 ... ok

copying template1 to template0 ... ok

copying template1 to postgres ... ok

Success. You can now start the database server using:

    /opt/postgres/9.1/bin/postgres -D /opt/postgres/9.1/data

or

    /opt/postgres/9.1/bin/pg_ctl -D /opt/postgres/9.1/data -l logfile start

Configuring PostgreSQL server startup scripts

perl: 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-openscg

Starting PostgreSQL 9.1: 

waiting for server to start.... done

server started

PostgreSQL 9.1 started successfully

To load this postgres into your environment, source the env file:

. /opt/postgres/9.1/pg91-openscg.env

$ 

参考：

http://wiki.ubuntu.org.cn/PostgreSQL

Postgres 9.1 DEB 安装

字符集支持

一些PostgreSQL的操作