Re: Privilege error with c functions during postgresql upgrade from 11 -> 13

2022-04-28 Thread Adrian Klaver
On 4/28/22 02:08, Dives, Chloe wrote: Thanks for your reply. I am using pg_upgrade to do the upgrade In the Postgres 11 instance using psql what does: \df+ bt_index_check return. In particular under the Access privileges column. Also the output of: \du Going back to your original post, so

RE: Privilege error with c functions during postgresql upgrade from 11 -> 13

2022-04-28 Thread Dives, Chloe
Thanks for your reply. I am using pg_upgrade to do the upgrade -Original Message- From: Adrian Klaver Sent: 27 April 2022 19:00 To: Dives, Chloe ; pgsql-general@lists.postgresql.org Subject: Re: Privilege error with c functions during postgresql upgrade from 11 -> 13 [EXTERNAL EM

Re: Privilege error with c functions during postgresql upgrade from 11 -> 13

2022-04-27 Thread Adrian Klaver
On 4/27/22 7:51 AM, Dives, Chloe wrote: I am doing a test run of upgrading a postgresql instance from v11 to v13 and am hitting the following error: *pg_restore: while PROCESSING TOC:* *pg_restore: from TOC entry 13902; 0 0 ACL FUNCTION "bt_index_check"("index" "regclass") rolename1* *pg_re