By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

How can I change the value of lo_compat_privileges parameter?

0

I need to migrate some large object data from pg_catalog and for that I need lo_compat_privileges to be set to ON but I can't do this as it is not modifiable. Is there a way to modify this?

Thanks

Topics
DatabaseAnalytics
Tags
Aurora PostgreSQLAmazon Aurora
Language
English
prabhu_axm
asked 10 months ago434 views
1 Answer
0

Unfortunately, "lo_compat_privileges" is a parameter that cannot be changed by the user.
The "Modifiable" column is set to false, which basically means that the parameters cannot be modified by the user.
para

profile picture
EXPERT
Riku_Kobayashi
answered 10 months ago
profile picture
EXPERT
Govind Kumar
reviewed 10 months ago
  • prabhu_axm
    10 months ago

    Can we raise a support ticket to modify this temporarily, let's say for an hour or two?

  • Riku_Kobayashi EXPERT
    10 months ago

    It would be worth checking, but if you open a support ticket with AWS, they will probably reply that they cannot change it.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content