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

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

查看更多关于its hot ,postgresql 9 install on ubuntu lucid 10.0的详细内容...

声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did43827