Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search

Page History

Versions Compared

Old Version 1

changes.mady.by.user Philippe

Saved on May 12, 2014

compared with

New Version 2

changes.mady.by.user Philippe

Saved on May 12, 2014

Key

This line was added.
This line was removed.
Formatting was changed.

...

Code Block

language	bash

gunzip -c ${BACKUP} | pg_restore -h localhost --username=${USER} -d ${DB} -W

The user's password (entered just previously) needs to be entered again.

Remove the superuser

...

privileges

Code Block

language	bash

 sudosudo -u postgres psql << EOF
ALTER ROLE ${USER} NOSUPERUSER;
EOF