How to create copy of local postgres db

postgres_db_copy

CREATE DATABASE newdb WITH TEMPLATE originaldb OWNER dbuser;  # newdb and originaldb are names of the new database and old database

# getting an error ?
ERROR:  source database "originaldb" is being accessed by other users

# run this query to stop error before running create data base query

SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity 
WHERE pg_stat_activity.datname = 'originaldb' AND pid <> pg_backend_pid();  # change originaldb with name of old database

# ref  https://stackoverflow.com/a/876565/851056