Creating New Databases
Creating a New Database
Creating a new database in PostgreSQL is very easy.
If you have to do is specify a "template" database to be copied to create your new database. This database must contain the "spatial_ref_sys" table which includes the spatial reference systems defined by PostGIS.
- Right click on "Databases" and select "New Database"
- Give the database a good, descriptive, and unique name.
- You'll need to select an existing database that includes the "spatial_ref_sys" table as the "template" on the "Definition" tab. This makes the table a "PostGIS" table.
- Click "OK" and the table should be created.
- If you recieve an error it is probably because the template database is currently in use. One way to avoid this is to create a new database from one like the "Natural Earth" database, remove all the tables except the "spatial_ref_sys" table and make this a template you use only to create other PostGIS tables.