User Tools

Site Tools


deployment:postgresql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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
  
/srv/www/htdocs/wiki/data/attic/deployment/postgresql.1519795173.txt.gz · Last modified: 2018/02/28 05:19 by asok