Re: Disabling/Enabling index before bulk loading

From: Ravi Krishna <srkrishna(at)yahoo(dot)com>
To: Vick Khera <vivek(at)khera(dot)org>
Cc: PG mailing List <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Disabling/Enabling index before bulk loading
Date: 2018-07-10 19:25:53
Message-ID: ACDA191F-CF08-4CAA-9569-41F5CB437A55@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
>
> https://fle.github.io/temporarily-disable-all-indexes-of-a-postgresql-table.html <https://fle.github.io/temporarily-disable-all-indexes-of-a-postgresql-table.html>

This does not work in RDS. In order to update system catalog tables (pg_index), one needs privileges which is
denied in RDS. In RDS terminology, the user must belong to role rdsadmin and that role is reserved only for AWS
internal users.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nikolay Samokhvalov 2018-07-10 20:18:39 Re: Disabling/Enabling index before bulk loading
Previous Message Vick Khera 2018-07-10 18:38:11 Re: Disabling/Enabling index before bulk loading