Re: Dump & restore in directory format and permissions are largely lost?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Wells Oliver <wells.oliver@xxxxxxxxx>
Subject: Re: Dump & restore in directory format and permissions are largely lost?
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Tue, 15 Jun 2021 21:45:52 -0400
Cc: "David G. Johnston" <david.g.johnston@xxxxxxxxx>, pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
Comments: In-reply-to Wells Oliver <wells.oliver@xxxxxxxxx> message dated "Tue, 15 Jun 2021 18:32:55 -0700"
In-reply-to: <CAOC+FBWCXatLexA5cqG+BEkPyeyNO4eHj8VaEcDOsU2Ub7eu+g@mail.gmail.com>
References: <CAOC+FBUk6FGOa0NGaFKX_jJTmOgN-xLTWFKm5MsdnDRqoQ9p-g@mail.gmail.com> <CAKFQuwYHezea03kxRTcHg3Jo8+c-xQo8TXdDipHj6woaKacGCw@mail.gmail.com> <CAOC+FBVYfA9y=QL2rvW751t3FffryTTyCJF40-phG5wEomOc9g@mail.gmail.com> <591499.1623806357@sss.pgh.pa.us> <CAOC+FBUuZ6gvhtxZknn_NbH0eMh3CTS8bf1Toq+XxPp7E4c5yg@mail.gmail.com> <592237.1623807036@sss.pgh.pa.us> <CAOC+FBWCXatLexA5cqG+BEkPyeyNO4eHj8VaEcDOsU2Ub7eu+g@mail.gmail.com>

Wells Oliver <wells.oliver@xxxxxxxxx> 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

Follow-Ups:
- Re: Dump & restore in directory format and permissions are largely lost?
  - From: Wells Oliver

References:
- Dump & restore in directory format and permissions are largely lost?
  - From: Wells Oliver
- Re: Dump & restore in directory format and permissions are largely lost?
  - From: David G. Johnston
- Re: Dump & restore in directory format and permissions are largely lost?
  - From: Wells Oliver
- Re: Dump & restore in directory format and permissions are largely lost?
  - From: Tom Lane
- Re: Dump & restore in directory format and permissions are largely lost?
  - From: Wells Oliver
- Re: Dump & restore in directory format and permissions are largely lost?
  - From: Tom Lane
- Re: Dump & restore in directory format and permissions are largely lost?
  - From: Wells Oliver

Prev by Date: Re: Dump & restore in directory format and permissions are largely lost?
Next by Date: Re: Dump & restore in directory format and permissions are largely lost?
Previous by thread: Re: Dump & restore in directory format and permissions are largely lost?
Next by thread: Re: Dump & restore in directory format and permissions are largely lost?
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]