Drop PostgreSql DB from php

Question

Is there any way to write DROP DATABASE [ IF EXISTS ] name from php script? Seems that I need something similar to mysql_drop_db just for Postrge.

How my $connStr in $conn = pg_connect($connStr) must look like to have rights to do this command? What db I must be connected?

DROP DATABASE is a query so you can use pg_query($conn, 'DROP DATABASE') — Hamza Abdaoui
– Hamza Abdaoui, Commented Jan 18, 2018 at 8:09
Should I always set db name in pgconnect? How my $connStr in $conn = pg_connect($connStr) must look like? Should I connect to db which I want to drop? — GuessWho
– GuessWho, Commented Jan 18, 2018 at 8:34

Vao Tsun · Accepted Answer · 2018-01-18 09:02:47Z

1

You have to be connected to a different db on same cluster as superuser role or db owner

https://www.postgresql.org/docs/current/static/sql-dropdatabase.html

It can only be executed by the database owner. Also, it cannot be executed while you or anyone else are connected to the target database. (Connect to postgres or any other database to issue this command.)

Have to pg_terminate_backend(pid) other connections on the db you want to drop before you drop it:

select pg_terminate_backend(pid) from pg_stat_activity where pid <> pg_backend_pid() and datname = 'db_to_drop';

answered Jan 18, 2018 at 9:02

Vao Tsun

52.5k13 gold badges114 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

GuessWho Over a year ago

So I can drop one database while I connected to the ANY other... Thanks, I will try

Collectives™ on Stack Overflow

Drop PostgreSql DB from php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related