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

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?

Thanks
sam


On Wed, Jun 23, 2010 at 12:24 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
> On Tuesday 22 June 2010 6:50:28 pm Sam Wun wrote:
>> Hi,
>>
>> With PG 8.4, I can't find a documentation to show me how to create a
>> super user or admin user for the PGSQL.
>>
>> I have crated a user called "liferayadmin" and a database "liferay".
>>
>> then executed the following command:
>>
>> GRANT ALL PRIVILEGES ON DATABASE liferay to liferayadmin;
>>
>> When I launched pgadmin in windows and login as user liferayadmin,
>> from the tools menu, the restore command is disabled.
>> I think the user "liferayadmin" does not have the privilege to restore
>> database.
>>
>> How can I enable a user with restore permission?
>>
>> Your help is very much appreciated
>>
>> Thanks
>> Sam
>
> You do say how you installed Postgres. Generally by the default there is a super
> user created with name of postgres. Also generally by default there is a local
> connection set up with an authentication of trust. You should be able to log in
> as postgres and have the necessary permissions.
>
> --
> Adrian Klaver
> adrian.klaver@gmail.com
>