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

Solutions on MaxInterview for postgres duplicate database in same server while other session is using source database by the best coders in the world

showing results for - "postgres duplicate database in same server while other session is using source database"

1SELECT pg_terminate_backend(pg_stat_activity.pid)
2FROM pg_stat_activity
3WHERE pg_stat_activity.datname = '[Database to copy]'
4AND pid <> pg_backend_pid();
5CREATE DATABASE [Database to create]
6WITH TEMPLATE [Database to copy]
7OWNER [Your username];
8

similar questions

enlever les doubles espaces dans les tables postgresql postgresql remove duplicate rows 2 columns postgres copy table from one schema to another postgresql copy backup table create duplicate table postgres postgres grep entire database query to remove duplicate records in postgresql server postgres select duplicate columns copy table postgres postgres switch between databases postgresql not in alternative copy column from one table to another without column duplicate postgres copy from one table to another postgres using matching column aqua data studio postgresql ssl postgresql inheritance postgres docs 2fcopy metacomand query postgres delete duplicates copy postgres table from one schema into another postgres multiple left join causing duplicates jsonb agg postgres copy command postgresql transaction discard all duplicate key value violates unique constraint in postgresql copy data from one postgres container to another copy value from one column to another postgres

queries leading to this page

postgres conf duplicate database to another server duplicate postgres database from external server postgres duplicate database in same server while other session is using source database