Create Database

Overview

You can create a new empty PostGIS database or create a PostGIS database from a data file or backup.

You can also connect to any existing PostGIS database you may have.

Create Empty Database

To create an empty PostGIS database, click the Create button

_images/db-create.png

Give your database a name and check the “Database Only” check box.

_images/db-create-db-only.png

The PostGIS database has now been created.

_images/new-db-created.png

Create Database From File

To create an empty PostGIS database, click the Create button

_images/db-create.png

Give your database a name and select the file to import.

_images/db-create-from-file.png

The PostGIS database has now been created.

_images/db-from-file-created.png

Create Connection

To add a connection to a remote or existing PostGIS database, click the “Add New” button at top.

_images/db-create-add-new.png

Populate the required fields for your PostgreSQL connection

_images/db-create-new-1.png

Under Database, click the “Load Database Names” icon

_images/db-load-names.png

The list of available databases will appear. Select the database you wish to connect to.

_images/db-load-names-select.png

Select the Group(s) that will have permission to the Store

_images/db-create-new-final.png

Click Save. Your Store has been created.

_images/db-created-final.png

Connection Information

To view the Connection information for a PostGIS database, click the Connection icon at right.

_images/db-show-conn-1.png

The conneciton information is displayed in Modal format

_images/db-show-conn-2.png