Is there a way to add another Spatial DataBase in PostGIS in the same SERVER?

enter image description here

enter image description here

Becuse it gives me this ERROR, when i´m trying to do ...

enter image description here

I disconnected the DB postgis_23_Sample and create my new DB using advice from @Vesanto.

  • >kill the postgres sessions stackoverflow.com/questions/5108876/…
    – Mapperz
    Mar 7 '17 at 18:00
  • Do you actually need the postgis_23_template? Usually if you need a fresh database, you don't need this. Templates were useful up until 2010, but they are not relevant anymore.
    – Mike T
    Mar 7 '17 at 19:23

It's not a case of second (third ...) spatial database but as your error said your template database is in use.

Following documentation:

The principal limitation is that no other sessions can be connected to the source database while it is being copied.

  • 1
    So the way to solve the issue is to right-click on the postgis_23_template database and choose "Disconnect server". Although there may also be other users using it, based on "5 other sessions using it". Mar 13 '17 at 10:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.