POSTGRES GUIDE INSTALLING

Uninstall Postgres GUIDE
https://medium.com/@bitadj/completely-uninstall-and-reinstall-psql-on-osx-551390904b86

Swtiching Postgres Version GUIDE
https://apple.stackexchange.com/questions/304024/how-do-you-install-an-older-version-of-postgres-9-6-using-homebrew

Dropping PUBLIC Schema
https://stackoverflow.com/questions/3327312/drop-all-tables-in-postgresql


MISMATCH VERSION

https://stackoverflow.com/questions/12836312/postgresql-9-2-pg-dump-version-mismatch


LINK the new Version if version Mismatch

`sudo ln -s /usr/pgsql-9.6/bin/pg_dump /usr/bin/pg_dump --force`
`sudo ln -s /usr/pgsql-9.6/bin/pg_restore /usr/bin/pg_restore --force`
`sudo ln -s /usr/pgsql-9.6/bin/psql /usr/bin/psql --force` 


PUBLIC 
https://stackoverflow.com/questions/3327312/how-can-i-drop-all-the-tables-in-a-postgresql-database


PUBLIC ROLE NOT EXIST  ERROR ON RESTORING A DUMP FILE
ALTER DATABASE sanin_staging OWNER TO  root;
GRANT ALL PRIVILEGES ON DATABASE sanin_staging to root;
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
GRANT ALL ON SCHEMA public TO root;
GRANT ALL ON SCHEMA public TO public;
COMMENT ON SCHEMA public IS 'standard public schema';