Unable to drop database in Postgres

Question

I'm new to databases in general and Postgres in particular. I'm doing something wrong as I'm unable to drop a database.

Command line capture

I've searched for similar issues, but it's always someone that has lost or does not know an id/password. In this case the owner & superuser is postgres but I still can't drop my test databases.

test is an empty database, test_creation is has one table.

Please edit your post and show the data as text, not as an image. Also, your user fmavianemac is in no group and has no permissions. So as that user you cannot do anything with the test database. What is your exact quesstion? Maybe you want to ask how to recover/reset the root/postgres password of a database? — Corion
– Corion, Commented Jan 7, 2019 at 12:02

Abdul Baig · Accepted Answer · 2019-01-07 12:23:35Z

1

You need to connect to psql using following:

PGPASSWORD=your_password_here psql -h localhost -U your_usename;

And then try to delete database. For UI you can use any software like pgAdmin III that will be much easier for you because you are new to Postgres

edited Jan 7, 2019 at 12:23

user330315

answered Jan 7, 2019 at 12:13

Abdul Baig

3,7413 gold badges23 silver badges48 bronze badges

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

Comments

Laurenz Albe · Accepted Answer · 2019-01-07 12:11:24Z

0

Only a superuser or the owner of a database can drop it.

Your prompt shows that you are not connected as superuser, and you are obviously not the database owner.

To drop a database, you must also make sure that nobody is connected to it.

answered Jan 7, 2019 at 12:11

Laurenz Albe

256k21 gold badges310 silver badges386 bronze badges

5 Comments

Treizh Over a year ago

I don't understand. I'm connected as postgress which is labeled as superuser in the roles.

Treizh Over a year ago

Now I get it '>' for user '#' for root

user330315 Over a year ago

@Treizh: psql postgres connects you to the database named postgres, not as the user postgres. To connect as the superuser you need to use psql -U postgres ...

Treizh Over a year ago

@a_horse_with_no_name: Thanks, so if a type psql postgres as which user im I connected?

Laurenz Albe Over a year ago

If you don't specify a database user, the default will be taken from the PGUSER environment variable, and if that is not set, the name of the operating system user is used

Collectives™ on Stack Overflow

Unable to drop database in Postgres

2 Answers 2

Comments

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Linked

Related