Re: how to create an admin user for restore database.

On Wednesday 23 June 2010 12:45:14 am Guillaume Lelarge wrote:
> Le 23/06/2010 05:17, Sam Wun a écrit :
> > With user liferayadmin on db liferay, I got the following errors:
> >
> > 03:14:50,558 WARN  [DBUtil:474] ERROR: permission denied for relation
> > quartz_locks: insert into QUARTZ_LOCKS values('TRIGGER_ACCESS');
> > 03:14:50,567 WARN  [DBUtil:474] ERROR: permission denied for relation
> > quartz_locks: insert into QUARTZ_LOCKS values('JOB_ACCESS');
> > 03:14:50,582 WARN  [DBUtil:474] ERROR: permission denied for relation
> > quartz_locks: insert into QUARTZ_LOCKS values('CALENDAR_ACCESS');
> > 03:14:50,593 WARN  [DBUtil:474] ERROR: permission denied for relation
> > quartz_locks: insert into QUARTZ_LOCKS values('STATE_ACCESS');
> > 03:14:50,608 WARN  [DBUtil:474] ERROR: permission denied for relation
> > quartz_locks: insert into QUARTZ_LOCKS values('MISFIRE_ACCESS');
> >
> > ...
> >
> > How can I assigne admin permission to liferayadmin user?
>
> ALTER ROLE liferayadmin SUPERUSER;
>
> as the fine manual says (see
> http://www.postgresql.org/docs/8.4/interactive/sql-alterrole.html).
>
>
> --
> Guillaume
>  http://www.postgresql.fr
>  http://dalibo.com

True, but you have to be the superuser to do this. See my previous post on how
to become the superuser and then do the above.

--
Adrian Klaver
adrian.klaver@gmail.com