Purge database

Jump to bottom Edit New page

Pedro Bernáldez Torres edited this page Mar 20, 2019 · 2 revisions

To purge the backend database the following steps must be followed:

Log in as postgres user: sudo su - postgres.
Open PostgreSQL console: psql.
Delete the old database: DROP DATABASE IF EXISTS soundgo;.
Recreate the database: CREATE DATABASE soundgo;.
Give privileges to admin: GRANT ALL PRIVILEGES ON DATABASE soundgo TO admin;
Exit PostgreSQL console: \q.
Log out: exit.

Copyright © 2019 SoundGo. Listen what's next.