Postgres

Remvoing Postgres

iitn@iitn-OptiPlex-9010:~$ dpkg -l | grep postgres

CHECK THE DIFFERENT POSTGRES YOU WANT TO REMOVE

iitn@iitn-OptiPlex-9010:~$ apt-get --purge remove

iitn@iitn-OptiPlex-9010:~$ sudo apt-get --purge remove postgresql-12 postgresql-client-12 postgresql-client-common postgresql-common

iitn@iitn-OptiPlex-9010:~$ sudo rm -rf /var/lib/postgresql

iitn@iitn-OptiPlex-9010:~$ sudo rm -rf /var/log/postgresql

iitn@iitn-OptiPlex-9010:~$ sudo rm -rf /etc/postgresql

Removing Table in Dspace Postgres Sql. Dspace tables are in a single schema, and the name of schema is public

DROP SCHEMA public CASCADE;

CREATE SCHEMA public;

GRANT ALL ON SCHEMA public TO postgres;

GRANT ALL ON SCHEMA public TO public;