Copying database without killing DB connections

Hello,

I need to copy database 1:1. I found it feasible with CREATE DATABASE dbname TEMPLATE templatename command but issue is, that this requires me to close all existing connections with exception of my own. I need to somehow avoid this and still be able to copy my database.

Can you give me some advice on how to do it or how to go around it?

Thanks a lot,

Tom.

You will need to use pg_dump / pg_restore to achieve this then.