本文介绍 Memo

Memo

This article was original written by Jin Tian, welcome re-post, first come with https://jinfagang.github.io . but please keep this copyright info, thanks, any question could be asked via wechat: jintianiloveu

postgres

to add a new user to postgres, most of case it is root, we using:

1
2
3
4
5
# the first muten
su postgres
createuser root
psql postgres
#postgres  alter user root with password 'password';

so you have a user and a password of that user.