Web: https://www.reddit.com/r/aws/comments/s3wzfk/pg_transport/

Jan. 14, 2022, 4:54 p.m. | /u/Maleficent_Visit8517

Amazon Web Services (AWS): S3, EC2, SQS, RDS, DynamoDB, IAM, CloudFormation, Route 53, VPC and more reddit.com


I am trying to transport databases through pg_transport, but I cannot drop the extensions due to the fact that many tables uses the citext extension and are dependent on it. On one hand drop cascade would occur in data loss, on another hand changing the columns types from citext to text would increase significantly the time to execute the transport process.

Is there any work around for transporting the database without removing the extensions?

#databases #rds #postgres #pg_transport

submitted by /u/Maleficent_Visit8517
[link] [comments]


DevOps Software Engineer

@ Sinch | Malmö, Skåne County, Sweden

Senior Staff Engineer, Cloud Systems

@ Life360 | Remote, USA

Junior DevOps Engineer

@ SmartBear | Wrocław, Lower Silesian Voivodeship, Poland

Senior DevOps Engineer - Data Engineering

@ Life360 | Ukraine

DevOps Engineer , Team Lead ( Remote )

@ AssistRx | Remote - Orlando, Florida, United States

Senior DevSecOps

@ Prodigy Education | Oakville, Ontario