Skip to content

Instantly share code, notes, and snippets.

@sujaypillai

sujaypillai/Postgres DB Create

Created August 10, 2015 16:11
Show Gist options
  • Save sujaypillai/3a1ecd28424cf1e27f6c to your computer and use it in GitHub Desktop.
Save sujaypillai/3a1ecd28424cf1e27f6c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Postgres DB Create
./psql -U alfresco -d alfrescoreporting
CREATE DATABASE alfrescoreporting WITH OWNER=alfresco ENCODING='UTF8' CONNECTION LIMIT=-1;
GRANT CONNECT, TEMPORARY ON DATABASE alfrescoreporting TO PUBLIC;
GRANT ALL ON DATABASE alfrescoreporting TO alfresco;
@sujaypillai
Copy link
Author

tar zcf ~/backup/alf_data_$(date +%Y%m%d%H%M%S).tar alf_data

@sujaypillai
Copy link
Author

pg_dump -Ft alfresco > ~/backup/original/alf_db_$(date +%Y%m%d%H%M%S).tar

@sujaypillai
Copy link
Author

CREATE DATABASE alfresco WITH OWNER=alfresco ENCODING='UTF8' CONNECTION LIMIT=-1;
GRANT CONNECT, TEMPORARY ON DATABASE alfresco TO PUBLIC;
GRANT ALL ON DATABASE alfresco TO alfresco;
pg_restore -c -i -U postgres -d alfresco -v "/opt/alfresco_backup/20150809/alfresco_db_20150809012011.tar" -W

@sujaypillai
Copy link
Author

Go to alf_data folder delete folders - solr4 contentstore.deleted contentstore solr4Backup

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment