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 globa
...@sss.pgh.pa.us]
Sent: Wednesday, September 12, 2018 10:40 AM
To: Scot Kreienkamp
Cc: pgsql-general@lists.postgresql.org
Subject: Re: PG9.1 migration to PG9.6, dump/restore issues
Scot Kreienkamp writes:
Restore completes successfully, but I noticed that the schema
permissions are missing
: Ron [mailto:ronljohnso...@gmail.com]
Sent: Wednesday, September 12, 2018 10:40 AM
To: pgsql-general@lists.postgresql.org
Subject: Re: PG9.1 migration to PG9.6, dump/restore issues
On 09/12/2018 08:55 AM, Scot Kreienkamp wrote:
Hi Everyone,
I am working on a migration from PG9.1 to PG9.6. Hoping
> 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.p
September 12, 2018 10:40 AM
> To: Scot Kreienkamp
> Cc: pgsql-general@lists.postgresql.org
> Subject: Re: PG9.1 migration to PG9.6, dump/restore issues
>
> Scot Kreienkamp writes:
> > Restore completes successfully, but I noticed that the schema
> > permissions are missi
On 09/12/2018 08:55 AM, Scot Kreienkamp wrote:
Hi Everyone,
I am working on a migration from PG9.1 to PG9.6. Hoping some people can
chime in on my plans as I am running into some restore issues.
We are upgrading to a new version of PG and migrating to new hardware with
RHEL 7, so I am plan
Scot Kreienkamp writes:
> Restore completes successfully, but I noticed that the schema
> permissions are missing, possibly others as well (Is this a known
> issue?).
If you're talking about custom modifications you made to the permissions
of the "public" schema in particular, then yeah, that won
On 9/12/18 6:55 AM, Scot Kreienkamp wrote:
Hi Everyone,
I am working on a migration from PG9.1 to PG9.6. Hoping some people can
chime in on my plans as I am running into some restore issues.
We are upgrading to a new version of PG and migrating to new hardware
with RHEL 7, so I am planning
Hi Everyone,
I am working on a migration from PG9.1 to PG9.6. Hoping some people can chime
in on my plans as I am running into some restore issues.
We are upgrading to a new version of PG and migrating to new hardware with RHEL
7, so I am planning on doing a dump and restore to get moved to th
