Creating a Database Manually

Despite the fact that Atlas Hub has automated PostgreSQL database creation, you may prefer to create your own. This makes more sense for PostgreSQL because there are good tools for database creation.
Database names should:
  • Begin with a letter.
  • Contain letters and numbers only.
  • Not contain spaces.
  • Not be a SQL reserved word such as create, delete, if, then, else, or goto.
Important: The Server Administration database options may fail to run for databases with names that do not follow these guidelines.
To create your own PostgreSQL Server database:
  1. Install PostgreSQL Server.
  2. Install Atlas Hub.
  3. Create an Atlas Hub database. Contact your database administrator about the specifics. Be sure that:
    • The database is owned by an Atlas Hub user.
    • The name of the database follows the conventions explained earlier in this section.
    • The template for the database is template0.
    • The encoding for the database should be: UTF-8. This refers to the physical storage of character strings in the database.
  4. Create and start a server configuration. See Creating a Server Configuration (for an Existing Database)