Re: pg_restore -L reordering of the statements does not work

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Sat, Oct 28, 2023, 18:37 Aditya D <dsaditya91@xxxxxxxxx> wrote:

Thanks a lot Tom for the detailed info. Few queries -

1. Is there any way I can create my own list file?

2. For Alter table <<table name>> owner to <<role name>> statement, what is the equivalent line in the list file?

3. Was using List file to achieve the following, i.e. executing the following lines in this order -

* Restoring the dump file using list file with role <<user1>>

* create table schema1.table1

* grant all on schema1 to user2

* alter table schema1.table1 to user2

Is the above possible using list file, if not what is the best alternative as we would like to automate.

PS: Don't have super user privileges on the target.

Why can you not create a role on the target that is a member of every other role and thus can create and reassign delegated permissions and ownership to any of them.  In short, a role that behaves as superuser within this limited context even if they are not a true superuser.

David J.