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