Creating Databases in PostgreSQL

Prerequisites

• Create database owner 
• Log on to the pgAdmin.

Process

1. In the pgAdmin, connect to the database server:

   1. In the Object Explorer, expand Servers. Then click the required server.

      

   2. If password request appears, in the text field of that dialog, enter the password for the user which name appears in the title.

   3. Select Save Password to avoid the dialog in the future.
   4. Click OK.

2. Create a new database:

   1. In the Object Explorer panel, expand Servers → <your PostgreSQL>.

      

   2. Right click Databases, point to Create, then click Database…
      The Create dialog appears.

3. Set up a new database:

   1. In the window that appears, go to the General tab.

      

   2. On the tab, in the Database field, enter the database name.

   3. From the Owner list, select the database owner username.
   4. Set up other parameters as required in your organization.
   5. In the window, click  Save.

Postrequisites

• To apply changes, reload PostgreSQL configuration.
• If unsure if reload is effective, restart the PostgreSQL