January 24th, 2013, 09:21 AM
Copying database without killing DB connections
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,
January 25th, 2013, 04:12 AM
You will need to use pg_dump / pg_restore to achieve this then.
I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
Tips on how to ask better questions: