Sunday, 15 February 2015

postgresql alter role is not registering -



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