New databases
PgDog's strategy for resharding Postgres databases is to create a new, independent cluster of machines and move data over to it in real-time. Creating new databases is environment-specific, and PgDog doesn't currently automate this step.
Requirements
New databases should be empty: don't migrate your table definitions or data. These will be taken care of automatically by PgDog.
Database users
Since PgDog was built to work in cloud-managed environments, like AWS RDS, we don't usually have access to the pg_shadow view, which contains password hashes. Therefore, tools like pg_dumpall aren't able to operate correctly, and we can't automatically migrate users to the new database.
For this reason, migrating users to the new database cluster is currently not supported and is the responsibility of the operator.
Make sure to create all the necessary Postgres users and roles before proceeding to the next step.
Multiple Postgres databases
If you are operating multiple Postgres databases on the same database server, they will need to be resharded separately. Logical replication, which PgDog uses to move data, operates on a single Postgres database level only.