Moving to Postgres

This topic provides some points worth considering as you plan your migration from Postgres Shared-NR to Postgres-2.0.

The Postgres Shared-NR plan is a free cloud-based service allowing you to create as many service instances (as created with cf create service) as you need for your application. Each service instance contains a single database on a shared database instance. When you need another database, you must create another service instance. Further, there was only one user per service instance, and it did not have Super User privileges. You could not create new users or new databases on demand.

Migrating to Postgres-2.0 service introduces you to a robust computing infrastructure where a service instance corresponds to a single database instance that can hold all of your databases (as created with the CREATE DATABASE SQL command). As Predix charges by the service instance, this represents a considerable savings for implementations that were using tens or hundreds of service instances with Shared-NR plan. In this environment, as the Super User, you can create additional databases and users as needed, and manage their privileges.

To create additional databases or users you can use the `CREATE DATABASE` or `CREATE USER` SQL commands. Additional information about ad-hoc SQL commands and pgStudio in available at KB0010829.