postgresql alter role is not registering -
importing via pgdump database server 9.3.5 installation, nail number of errors in accessing postgresql's command line.
for example:
sudo su - postgres psql -d template1 allows me view users \du \list databases, if state, according documentation:
create user michaelrodent or
create role donatoquack login password 'spltfrzspltrz' \du lists default user or role. if state bash prompt
sudo -u postgres createuser michaelrodent \du shows role name. stupid me did not assign role attribute superuser, when importing via psql, i'm getting errors like:
error: must owner of extension plpgsql error: must owner of relation accbiadesivolumes go in postgres user , cannot:
alter role michaelrodent superuser ...at loss understand why postgresql command language failing register , how utilize shortcut syntax of sudo -u postgres [...] alter role...
did add together semicolon end of command line, like:
alter role michaelrodent superuser; the reply/result should be:
krant=# alter role dba replication; alter role krant=# postgresql
No comments:
Post a Comment