topic Re: PostgreSQL - EGDB - Branch Versioned Data Migration in Geodatabase Questions

PostgreSQL - EGDB - Branch Versioned Data Migration

a-j-campbell — Wed, 20 May 2026 16:49:53 GMT

Has anyone had success in migrating Branch Versioned Datasets to a new database instance while maintaining branch history?

We are working through a migration from a Windows Server 2019 hosted PostgreSQL 15 instance into a PostgreSQL 15 RDS instance in AWS and have had some trouble maintaining branch history with cross-database copy workflows.

Ultimately we are looking to maintain the ability to rollback to a historical moment in our new database, but would prefer to keep things in the same active table. We are aware of this lovely article outlining the ability to do so from a dedicated archive table which we could migrate to the instance as a net-new table but wanted to confirm if our desired workflow was possible.

Things we've tried:

Full ArcGIS-based Copy/Paste (ArcGIS Pro) -- no historical rows brought over
Truncate/Append into a branch-version-enabled copy of the table in the RDS instance (ArcGIS Pro) -- no historical rows brought over
Append of Archive table records into destination table in RDS (ArcGIS Pro) -- Resulted in all clients showing a total of all records AND their respective historical moments

Thanks in advance for any insight!

Re: PostgreSQL - EGDB - Branch Versioned Data Migration

MarceloMarques — Wed, 20 May 2026 16:58:10 GMT

Restore an on-premises PostgreSQL database backup into the AWS RDS PostgreSQL database.

Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices

 How to Move the PostgreSQL Enterprise Geodatabase with pg_dump and pg_restore

 How to Upgrade the PostgreSQL and PostGIS version for the Ent. Geodatabase on Windows

 How to Upgrade the PostgreSQL and PostGIS version for the Ent. Geodatabase on Linux

AWS Documentation

Backing up, restoring, and exporting data - Amazon Relational Database Service

PostgreSQL pg_dump and pg_restore utility - Database Migration Guide

Best practices for migrating PostgreSQL databases to Amazon RDS and Amazon Aurora | AWS Database Blog

Note: you will need an EC2 instance with pgAdmin or PostgreSQL installed to be able to run the pg_dump and pg_restore commands.

Re: PostgreSQL - EGDB - Branch Versioned Data Migration

MarceloMarques — Wed, 20 May 2026 17:11:08 GMT

Branch Version One-way feature service-to-feature service sync
https://www.esri.com/arcgis-blog/products/arcgis-enterprise/data-management/one-way-feature-service-to-feature-service-sync

Re: PostgreSQL - EGDB - Branch Versioned Data Migration

a-j-campbell — Wed, 20 May 2026 17:27:25 GMT

Awesome. Thanks @MarceloMarques! I'll see where we get with the server-to-service sync.