it's hot ,postgresql 9 install on ubuntu lucid 10.04

September 28, 2010

Installing PostgreSQL 9.0 on Ubuntu

Filed under: HowTo,ubuntu — devdude @ 8:49 am
Tags: install, ubuntu, postgresql, lucid

Thanks to Martin Pitt , who maintains the packages for Ubuntu, nstalling the latest version of PostgreSQL on Ubuntu (Lucid) is nothing more than updating your /etc/apt/sources.list with

deb http://ppa.launchpad.net/pitti/postgresql/ubuntu lucid main

deb-src http://ppa.launchpad.net/pitti/postgresql/ubuntu lucid main

plus

apt-get update

and

apt-get installpostgresql-9.0

I recommend reading the release notes and he outstanding good postgresql documentation.

Ads by Google

SSL Installation
Free Trustwave Support Docs Apache and other popular servers
ssl.trustwave.com/Install

GPG签名验证错误： http://ppa.launchpad.net hardy Release: 由于没有公钥，下列签名无法进行验证： NO_PUBKEY

Ubuntu添加新的软件源的时候，update报这个错误

GPG签名验证错误： http://ppa.launchpad.net hardy Release: 由于没有公钥，下列签名无法进行验证： NO_PUBKEY 6AF0E1940624A220

找了下原因，虽然不知道原理，不过大概意思还是能才出来的，解决方法如下：

gpg --keyserver subkeys.pgp.net --recv 99B656EA8683D8A2

gpg --export --armor 99B656EA8683D8A2 | sudo apt-key add -

然后sudo apt-get update就OK了

20090723补充：subkeys.pgp.net尽然提示找不到了，换成keyserver.ubuntu.com即可

gpg --keyserver keyserver.ubuntu.com --recv 99B656EA8683D8A2

gpg --export --armor 99B656EA8683D8A2 | sudo apt-key add -

http://www.mndu.cn/html/y2010/331.html

add new user

execute these as the postgres user:

su - postgres

One option is to create a super-user with something like:

postgres$ createuser -d -a -P jeoff

then:

jeoff$ createdb ibmadb

then do administrative things with that user. I would advise *NOT* using root. If this is a tightly controlled (non-shared) machine, you could make a super user as your normal unix login (which hopefull is not root). Ideally you'll only need root to start the postgres service.

sudo passwd postgres

su postgres

createuser -P -d -a -e mlzboy

dropuser mlzboy

reference:

http://www.linuxsir.org/main/?q=node/275