注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

拥有自己的梦想,跟随心的召唤

平凡是福

 
 
 

日志

 
 

Ubuntu 11.04 安装 PostgreSQL 9.1  

2011-12-19 19:19:23|  分类: Ubuntu |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
Ubuntu 11.04 安装 PostgreSQL 9.1
1) 下载 PostgreSQL 9.1 的Ubuntu deb包
我下载的是 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

PostgreSQL 允许远程访问设置方法
  评论这张
 
阅读(1905)| 评论(0)
推荐 转载

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017