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

2010-06-23 Thread Adrian Klaver
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 valu

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

2010-06-23 Thread Raymond O'Donnell
On 23/06/2010 12:21, Raymond O'Donnell wrote: > On 23/06/2010 02:50, Sam Wun wrote: > >> 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 >> databas

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

2010-06-23 Thread Raymond O'Donnell
On 23/06/2010 02:50, Sam Wun wrote: > 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. Something else worth checking is whether pgAdmin h

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

2010-06-23 Thread Guillaume Lelarge
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: permissio

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

2010-06-22 Thread Sam Wun
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 Q

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

2010-06-22 Thread Adrian Klaver
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

[GENERAL] how to create an admin user for restore database.

2010-06-22 Thread Sam Wun
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 p