Modify database name using psql

[Admin]

1 - See if open connections

Código:


SELECT * FROM pg_stat_activity WHERE datname = 'DATABASE_NAME_TOBE_RENAMED'


2 - Kill open sessions

Código:


SELECT pg_terminate_backend(procpid)
FROM pg_stat_activity
WHERE
    -- don't kill own connection
    procpid <> pg_backend_pid()
    -- don't kill the connections to other databases
    AND datname = 'DATABASE_NAME_TOBE_RENAMED';


3 - Rename the database.

Using pgadmin (right button on the database you want => properties => change name => OK