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

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

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

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

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

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

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us