Differences

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

--- database:postgresql [2016/03/24 16:02] – [Commands] tmade
+++ database:postgresql [2018/03/31 10:06] (current) – [RESTORE] tmade
@@ Line 94: / Line 94: @@
   psql -f dumpfile postgres               #"postgres" is the owner of the db!
-To restore a DB (created with "pg_dump") you have:
-  dropdb databasename
-  createdb databasename
-Afterwards you have to invoke:
-  pg_restore -d databasename databasename.dump
-  psql dbname < infile.sql
 ==== POINT IN TIME RECOVERY ====
@@ Line 125: / Line 114: @@
   CREATE DATABASE test OWNER test
+==== Roles and Grants ====
+To add role "CREATEDB" to user test:
-ALTER USER db001 CREATEDB;
-sudo -u postgres psql -c 'alter user db001 with createdb' postgres
+  ALTER USER test CREATEDB;
+or
+  sudo -u postgres psql -c 'alter user test with createdb' postgres