This article is designed to be a simple how-to for Jive Hosted customers who wish to export a data dump of their entire Jive instance, or query a dump of their Jive databases directly. It will guide you through the full process of requesting, downloading, and then restoring your Postgres database (DB).
If you are a Jive Cloud customer, please read the article Procedure for Jive Cloud Customers to Request a Database Dump.
The article also has a section explaining the general method for querying the restored database using Structured Query Language (SQL) using both the GUI and CLI, and assumes that you have already downloaded and installed PostgreSQL on your local machine with the default settings.
The information in this document is provided to help empower customers to work with their database dumps. However, please note that Jive Software does not support issues with installing or using PostgreSQL.
- This article is valid for all versions of Jive Hosted Instances
- Commands in this article (and cross-reference articles) were written using PostgreSQL version 9.2.6
Step 1: Obtaining a Database Dump
Any Jive Hosted customer may request a one-time dump of their Application, EAE (Enterprise Activity Engine) or
Analytics(if applicable) databases (DB) from any Production instance (UAT and Cloud are not supported) from our hosting team.
Customers can also request regular database dumps for their Production instances on a weekly or daily basis. The dumps will then be made available for download via the Jive Cloud Admin (JCA) tool.
Please Grant JCA Accessand a list of the URLs of each site you need JCA access to.
Requesting Database Dumps
Firstly, log in to Jive Cloud Admin, and verify that there are not any dumps available via the Downloads icon. You can request either a one-time dump or regular dumps (Production only).
If you do not see any databases in the list of downloads, see the message 'Your installation has not been configured to allow Database downloads', or if the files are present but are empty (size 0 KB) then file a new support case, with the following details:
A title similar to
Please provide one-time DB dumpor
Please enable regular DB dumps.
- Detail of the error/issue that you are seeing along with a screenshot of any errors.
The URL(s) for the site(s) you wish to obtain dumps from.
The list of which databases you would like dumped (
<supportagent>Refer article Database Dumps Not Available in JCA (Hosted) for further action. </supportagent>
Downloading the Database Dump
Once database dumps have been enabled and at least one dump created, log in to Jive Cloud Admin, then click Download next to the snapshot you want to download. Your browser will prompt you to download or save it.
- You can also contact the Jive Support team in case you need further assistance on downloading the database dump.
Step 2: Restoring a Database Download
Now that you have your DB download, you will need to restore it in order to use it and access any information contained within. You can use either of the following methods interchangeably, i.e., just because you use PG Admin to restore a database, does not mean you cannot use the CLI later to do so.
Step 3: Querying the Database
This section shows you how to execute SQL statements against your newly restored database:
Refer to the following articles for step-by-step instructions: