title: Copy database in postgres
body: <p>I have a requirement in which I need to take a snapshot of a database and restore it in the same machine with some other predefined name in postgres.
  I have tried to achieve the above task with the following command.</p>
  
  <pre><code>CREATE DATABASE destniationDb TEMPLATE sourceDb;
  </code></pre>
  
  <p>But this option fails when the connection/session to the sourceDb exists.So I need to truncate this option as there is high possibility of user doing read operation.
  All command line options like restore_db,backup_db doest suit my requirement.Hence,I need some console command/function/store procedure to achieve it i.e, I need to connect to the database and call some command/function/store procedure that achieves this objective.</p>
  
  <p>Can anyone of you suggest some kind of solution to my requirement?</p>