SHARE
TWEET

db restore

a guest Jan 11th, 2017 121 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # Restoring database dump
  2.  
  3. $ sudo service alfresco stop
  4. $ sudo /opt/alfresco/postgresql/scripts/ctl.sh start
  5.  
  6. $ sudo su - postgres
  7. $ cd /opt/alfresco/postgresql/bin
  8. $ ./psql
  9. postgres=# drop database alfresco;
  10. DROP DATABASE
  11.  
  12. postgres=# CREATE DATABASE alfresco
  13. postgres-# WITH OWNER = alfresco
  14. postgres-# ENCODING = 'UTF8'
  15. postgres-# TABLESPACE = pg_default
  16. postgres-# CONNECTION LIMIT = -1
  17. postgres-# TEMPLATE template0;
  18. CREATE DATABASE
  19.  
  20. postgres-# \q
  21.  
  22. $ exit
RAW Paste Data
Top