babelfish_extensions icon indicating copy to clipboard operation
babelfish_extensions copied to clipboard
verified publisher icon babelfish-for-postgresql

Create multiple babelfish databases for each database from sql server

Open madanparedla opened this issue 1 year ago • 5 comments

How to create multiple databases in babelfish

madanparedla avatar May 15 '24 12:05 madanparedla

Sounds like your cluster was created in "single-db" mode? If you want to create more than one database, the cluster must be created in "multi-db" mode. You cannot change the migration mode, so you'd have to create a new cluster. See https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/babelfish-architecture.html and https://babelfishpg.org/docs/installation/single-multiple/

robverschoor avatar May 15 '24 14:05 robverschoor

can you please share steps how to create new cluster and in multi-db enabled.

madanparedla avatar May 16 '24 11:05 madanparedla

See the documentation: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/babelfish-create.html

robverschoor avatar May 16 '24 12:05 robverschoor

i am setting up in physical server not in aurora RDS

madanparedla avatar May 16 '24 14:05 madanparedla

See the other link which I posted above for the standalone setup procedure

robverschoor avatar May 16 '24 17:05 robverschoor