Re: PG9.1 migration to PG9.6, dump/restore issues

On 9/12/18 11:30 AM, Scot Kreienkamp wrote:
>> Did you see errors in the restore?
>>
>> In particular about not finding roles(users) for the permissions?
>>
>> I ask because I do not see in the above anything about dumping objects
>> global to the cluster. That would include roles. I use:
>>
>> pg_dumpall -g -f globals.sql
>>
>> See:
>>
>> https://www.postgresql.org/docs/10/static/app-pg-dumpall.html
>>
>
> Nope, no errors in the restore that I could see. As I as discussing with Tom Lane, the -g switch doesn't bring over schema permissions either. I could use the -s switch and

Using pg_dumpall -g is not about permissions it is about transferring
the roles that the permissions depend on. To put it another way roles
are global to a cluster and permissions are tied to objects in a database.

just re-create the databases as empty again after that's applied. That
brings over everything except data.
>
>
> Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate
> One La-Z-Boy Drive| Monroe, Michigan 48162 | Office: 734-384-6403 | | Mobile: 7349151444 | Email: Scot(dot)Kreienkamp(at)la-z-boy(dot)com
>
> This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by e-mail or by telephone at the above number. Thank you.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com