dropuser yby
createuser -s yby
变身 superuser 了,却一直提示我密码不对
FATAL: password authentication failed for user "yby"
FATAL: password authentication failed for user "yby"
折腾来折腾去设置来设置去没弄成功……
想再 dropuser 一次,重新设置个带密码版本的吧,竟然还不让
yby@yby:~/YBY/r$ sudo su - postgres
postgres@yby:~$ dropuser yby
dropuser: removal of role "yby" failed: ERROR: role "yby" cannot be dropped because some objects depend on it
DETAIL: owner of function pg_logfile_rotate()
owner of function pg_file_length(text)
owner of function pg_file_read(text,bigint,bigint)
owner of function pg_logdir_ls()
owner of function pg_file_unlink(text)
owner of function pg_file_rename(text,text)
owner of function pg_file_rename(text,text,text)
owner of function pg_file_write(text,text,boolean)
owner of extension adminpack
#33 楼 @Kabie #34 楼 @blacktulip 我现在用的就是 14.04, 什么坑什么坑?我要提防什么不?
原来可以这样干!那我也求 ruby 高手合租!
#21 楼 @blacktulip 算了,明日再战,今晚又崩溃了……试了好几个方法都不行……
#8 楼 @messiahxu 话说,你这句是在什么语境下啊?
yby@yby:~/YBY/rc$ sudo su - postgres
postgres@yby:~$ create role yby with createdb login password 'xxxxxx'
No command 'create' found, did you mean:
Command 'pcreate' from package 'python-pyramid' (universe)
Command 'pcreate' from package 'pbuilder-scripts' (universe)
create: command not found
我用 pgAdmin 好像是创建了个用户来着, 反正现在左边如图:
#8 楼 @messiahxu 我没有设置过 password 哦!我先试试哈~