开发者

Local postgresql server and creating new user on linux

I installed postgresql via synaptic on ubuntu.

开发者_JS百科

Now I dont know how to create new user, run server and create it in pgAdmin3.


Use this to create a postgres user called $USER:

sudo -u postgres createuser --superuser $USER

Creating a DB with the same name as your user name makes things easier. It becomes your default DB.

createdb $USER

Use this to set a password for USER. This must be done for pgadmin3 to work.

sudo -u postgres psql
postgres=# \password USER
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜