CODEWITHSUNDEEP
amazon-web-servicesamazon-rds
Mr.DevEng
Mr.DevEng

Reputation: 2421

Creation of multiple databases from one RDS DB instance

I am trying to design distributed databases using AWS RDS instances. Now I created a PostgreSQL database instance using AWS RDS service. And I am trying to create multiple databases by using that created instances.

Is it possible to create multiple databases by using one RDS DB instance? If so, how can I do this?

Is there any implementation documentation for this?

Upvotes: 0

Views: 3065

Answers (1)

John Rotenstein
John Rotenstein

Reputation: 269091

Amazon RDS provides you with a normal PostgreSQL database. You can use standard PostgreSQL commands:

CREATE DATABASE name
    [ [ WITH ] [ OWNER [=] user_name ]
           [ TEMPLATE [=] template ]
           [ ENCODING [=] encoding ]
           [ LC_COLLATE [=] lc_collate ]
           [ LC_CTYPE [=] lc_ctype ]
           [ TABLESPACE [=] tablespace_name ]
           [ ALLOW_CONNECTIONS [=] allowconn ]
           [ CONNECTION LIMIT [=] connlimit ]
           [ IS_TEMPLATE [=] istemplate ] ]

See: PostgreSQL CREATE DATABASE documentation

Upvotes: 2

Related Questions