Skip to content

Instantly share code, notes, and snippets.

@malkab

malkab/postgresql-set_up_database_for_production.sql

Created January 4, 2021 12:08
Show Gist options
  • Save malkab/76f733cd73c0db9e6684cb64d39fe693 to your computer and use it in GitHub Desktop.
Save malkab/76f733cd73c0db9e6684cb64d39fe693 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL - Set Up Database for Production
Raw
postgresql-set_up_database_for_production.sql
/**
Configure a new database for production, cutting
default permissions from public to the postgres
default database.
*/
\c postgres
-- Drop default privileges
revoke all privileges on database postgres
from public;
revoke all privileges on schema public
from public;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment