How to Erase PostgreSQL Database Using psql

postgresqlpsql

I have psql installed in my Ubuntu system. There is a database named tmpdb in it. I want to delete it but get an error message:

must be owner of database tmpdb".

I open psql with

  $psql postgres
  psql (9.5.6)
  Type "help" for help.

  postgres=>DROP DATABASE tmpdb;
  ERROR:  must be owner of database tmpdb
  postgres=>

How can I see owner, change it, so I can delete the database?

Best Answer

You don't have to do any of that if you want to delete it the simple way is to use dropdb as a database super-user. Assuming that postgres is still a database super-user.

sudo -u postgres dropdb tmpdb;

See man dropdb for more information.

Related Solutions

Postgresql – psql denies access to file when using COPY FROM

drwxr--r-- 6 peter peter 4096 2011-04-14 14:03 phm

postgres@dexter:/home/peter/PyPacks$ cd phm

bash: cd: phm: Permission denied

Directories need to be executable to be able to cd into them (or use files within them). All the sub-directory from / to the /home/peter/PyPacks/phm need to be executable by the user you want to use for this to work.

Try at least chmod 711 phm (which should give you rwx--x--x), or perhaps chmod 755 phm (rwxr-xr-x). r for directories is the ability to list their content, not to go into them (or use files/directories within them).

Postgresql – Ensure correct username when using pg_restore

If you want to create the plpgsql extension I believe you have to be Superuser. My recommendation is to make app_user temporarily a superuser and then revert this. Superusers also are treated as owners of everything.

ALTER USER app_user WITH SUPERUSER;

run the restore, then when you are done

ALTER USER app_user WITH NOSUPERUSER;

This should avoid any other permissions issues but still leave you with the permissions you want.

Best Answer

Related Solutions

Postgresql – psql denies access to file when using COPY FROM

Postgresql – Ensure correct username when using pg_restore

Related Question