| From: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Dump & restore in directory format and permissions are largely lost? |
| Date: | 2021-06-16 01:52:53 |
| Message-ID: | CAOC+FBVd=VbHJ_sCR+OVDN8M_aXy6rgE=ue91WjN5U6-=rY4uA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
That worked, I piped all the GRANTs into a file and ran it against the DB
and permissions have been restored, but it remains puzzling to me why they
were absent after the restore.
On Tue, Jun 15, 2021 at 6:45 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Wells Oliver <wells(dot)oliver(at)gmail(dot)com> writes:
> > Ah, I'm sorry, is there a way to see grants contained in a dump?
>
> I'd try "pg_restore -s -f - archive.file | grep GRANT" or so.
>
> regards, tom lane
>
--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikhil Shetty | 2021-06-16 06:26:46 | Re: vacuumdb idle processes |
| Previous Message | Tom Lane | 2021-06-16 01:45:52 | Re: Dump & restore in directory format and permissions are largely lost? |