Answers for "postgres duplicate database in same server while other session is using source database"

SQL
0

postgres duplicate database in same server while other session is using source database

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = '[Database to copy]'
AND pid <> pg_backend_pid();
CREATE DATABASE [Database to create]
WITH TEMPLATE [Database to copy]
OWNER [Your username];
Posted by: Guest on March-04-2021

Code answers related to "postgres duplicate database in same server while other session is using source database"

Code answers related to "SQL"

Browse Popular Code Answers by Language