Re: how to create an admin user for restore database. - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: how to create an admin user for restore database.
Date
Msg-id 4C21F09F.4020304@iol.ie
Whole thread Raw
In response to Re: how to create an admin user for restore database.  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
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 database.
>
> Something else worth checking is whether pgAdmin has been told where the
> pg_dump and pg_restore binaries are residing on your local system.... If
> it hasn't, or if the path it has is incorrect, then the "Backup" and
> "Restore" options will be greyed out.
>
> Look in Options -> General for "PG bin path".

Actually, I just tried it myself, and apparently if no value is entered
in "PG bin path" then the backup and restore options disappear
altogether from the right-click menu.... I'm on pgAdmin 1.10.1.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: how to create an admin user for restore database.
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: unexpected effect of FOREIGN KEY ON CASCADE DELETE