Re: "Access privileges" is missing after pg_dumpall

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: "Access privileges" is missing after pg_dumpall
Date: 2018-07-04 17:42:58
Message-ID: 66691.1530726178@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com> writes:
> I have taken pg_dumpall in pg-master and after restoring the dump I am not
> able to see the "Access privileges" as below:
> Same is reproducible in back branches as well, is this fine ?

Yes, it is, because the privileges are the same in both states. In
one case you have an explicit representation of the default privileges,
in the other it's just default.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2018-07-04 18:10:33 Re: Speedup of relation deletes during recovery
Previous Message Alvaro Herrera 2018-07-04 17:15:19 Re: pgsql: Fix crash when ALTER TABLE recreates indexes on partitions