Re: backing up Query Editor files

Hi, On Mon, May 13, 2019 at 7:53 PM Derek Ealy wrote: > cool thanks. > > It would be nice if there was an easy way to make backups or for an admin > to download those files via the GUI. > We have feature request for that - https://redmine.postgresql.org/issues/3318 and will be considered for fut

Re: Can't start 4.6

Hi, On Mon, May 13, 2019 at 7:17 PM Durumdara wrote: > Hello! > > Aditya Toshniwal ezt írta (időpont: > 2019. máj. 13., H, 8:55): > >> Hi, >> >> On Mon, May 13, 2019 at 12:21 PM Durumdara wrote: >> >>> Hello! >>> >>> I tried to find any files with "pgadm*.log" in all drives. >>> >> The files s

Re: default role privileges

default privileges can be applied to roles (and, it appears, only to roles) https://www.postgresql.org/docs/10/sql-alterdefaultprivileges.html ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } *target_role* [, ...] ] [ IN SCHEMA *schema_name* [, ...] ] *abbreviated_grant_or_revoke* On

Re: backing up Query Editor files

cool thanks. It would be nice if there was an easy way to make backups or for an admin to download those files via the GUI. Derek On Sun, May 12, 2019 at 10:57 PM Khushboo Vashi < khushboo.va...@enterprisedb.com> wrote: > > > On Fri, May 10, 2019 at 8:23 PM Derek Ealy > wrote: > >> Hi >> >> We

Re: Can't start 4.6

Hello! Aditya Toshniwal ezt írta (időpont: 2019. máj. 13., H, 8:55): > Hi, > > On Mon, May 13, 2019 at 12:21 PM Durumdara wrote: > >> Hello! >> >> I tried to find any files with "pgadm*.log" in all drives. >> > The files start with a "." dot. Try search again with ".pgAdmin*" > >> >> Firstly th

Re: default role privileges

On Mon, May 13, 2019 at 3:06 PM Michael Shapiro wrote: > I ran this in one of my databases > > ALTER DEFAULT PRIVILEGES FOR ROLE some_role REVOKE EXECUTE ON FUNCTIONS > FROM PUBLIC: > > I can not see this default privilege anywhere in PgAdmin4 (nor in > PgAdmin3). > I see no default privileges f

Re: default role privileges

I ran this in one of my databases ALTER DEFAULT PRIVILEGES FOR ROLE some_role REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC: I can not see this default privilege anywhere in PgAdmin4 (nor in PgAdmin3). I see no default privileges for roles on the SQL for the role. I do see default privileges on the SQ