This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
deployment:postgresql [2018/02/28 05:19] asok |
deployment:postgresql [2018/02/28 19:09] (current) asok |
||
---|---|---|---|
Line 53: | Line 53: | ||
<code> | <code> | ||
+ | |||
+ | -- Recreate Schema | ||
+ | |||
+ | DROP SCHEMA public CASCADE; | ||
+ | CREATE SCHEMA public; | ||
+ | GRANT ALL ON SCHEMA public TO postgres; | ||
+ | GRANT ALL ON SCHEMA public TO public; | ||
+ | |||
-- Show Running Queries -- Look for active ones | -- Show Running Queries -- Look for active ones | ||