Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Restoring database dump
- $ sudo service alfresco stop
- $ sudo /opt/alfresco/postgresql/scripts/ctl.sh start
- $ sudo su - postgres
- $ cd /opt/alfresco/postgresql/bin
- $ ./psql
- postgres=# drop database alfresco;
- DROP DATABASE
- postgres=# CREATE DATABASE alfresco
- postgres-# WITH OWNER = alfresco
- postgres-# ENCODING = 'UTF8'
- postgres-# TABLESPACE = pg_default
- postgres-# CONNECTION LIMIT = -1
- postgres-# TEMPLATE template0;
- CREATE DATABASE
- postgres-# \q
- $ exit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement