[GENERAL] Permission Denied Error on pg_xlog/RECOVERYXLOG file

Hi Folks, We reported a bug last month (#14119) related to receiving a permission denied error on the pg_xlog/RECOVERYXLOG file when performing a database recovery (PostgreSQL versions 9.2.16 and 9.2.17). The bug report was for version 9.2.16 but we also are having the same problem with 9.2.17

Re: [GENERAL] Permission denied error - best way to fix?

On Tuesday, February 08, 2011 2:44:51 pm Mike Christensen wrote: > >> Here's the error: > >> > >> pg_dump: SQL command failed > >> pg_dump: Error message from server: ERROR: permission denied for > >> relation pantryitems > >> pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHAR

Re: [GENERAL] Permission denied error - best way to fix?

On 02/08/11 2:44 PM, Mike Christensen wrote: Here's the error: pg_dump: SQL command failed pg_dump: Error message from server: ERROR: permission denied for relation pantryitems pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE MODE Does the user need to be a superuser, or

Re: [GENERAL] Permission denied error - best way to fix?

>> Here's the error: >> >> pg_dump: SQL command failed >> pg_dump: Error message from server: ERROR:  permission denied for >> relation pantryitems >> pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE >> MODE >> >> Does the user need to be a superuser, or is there some way to

Re: [GENERAL] Permission denied error - best way to fix?

On 02/08/2011 10:57 AM, Mike Christensen wrote: Here's the error: pg_dump: SQL command failed pg_dump: Error message from server: ERROR: permission denied for relation pantryitems pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE MODE Does the user need to be a superuser,

Re: [GENERAL] Permission denied error - best way to fix?

2011/2/8, Mike Christensen : > Here's the error: > > pg_dump: SQL command failed > pg_dump: Error message from server: ERROR: permission denied for > relation pantryitems > pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE MODE > > Does the user need to be a superuser, or is

[GENERAL] Permission denied error - best way to fix?

Here's the error: pg_dump: SQL command failed pg_dump: Error message from server: ERROR: permission denied for relation pantryitems pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE MODE Does the user need to be a superuser, or is there some way to GRANT this permission (if

[GENERAL] Permission denied error

Getting recurring lines in log of ERROR: permission denied for relation logs Is there a way to tell from which DB this error is coming from? Or even what user? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTE