How do I generate a PostgreSQL DB Dump for JetPatch

If you are experiencing any issues with the JetPatch manager console,  please follow the below steps and send the relevant information to the JetPatch support team. 

Instructions

Obtain DB details (including DB name, username, and password) by accessing the backend of the JetPatch server. Run 

cd /usr/share/tomcat/default/conf/
cat intigua.properties | grep db

Then, use one of the following three methods:

1. Via pg_dump Linux utility (assuming root account)

Log into the database server (assumes a few defaults user=jetpatch, port=5432, dbname=jetpatchdb)

pg_dump -U jetpatch -h localhost -p 5432 jetpatchdb | gzip > db_dump.sql.gz

NOTE: Some deployments may have intigua (user=intigua, port =5432, dbname=intiguadb)

pg_dump -U intigua -h localhost -p 5432 intiguadb | gzip > db_dump.sql.gz

If you get an authentication issue, then start the command with 

PGPASSWORD=""

where "" = the password found in intigua.properties

example:

PGPASSWORD="" pg_dump -U jetpatch -h localhost -p 5432 jetpatchdb | gzip > db_dump.sql.gz

The file will be located in the same folder, or

cd /var/lib/postgresql
or
cd /var/lib/pgsql

In order to SFTP it over, you may need to claim ownership of the same folder with the following command

sudo chown -R $(whoami) /your/current/dir

Alternatively, you can run (note: please share the exact PostgreSQL version if you use this method)

pg_dump -Fc -U <USER> -h <HOST> -p <PORT> <DBNAME>

Notes

For very large databases, you might need to combine split with one of the following approaches, in order to prevent problems with a file size limit on upload

# e.g.1 - split file after 1G
# pg_dump dbname | split -b 1G - filename 

# e.g.2 - # split file after 1G with -FC
pg_dump -Fc dbname | split -b 1G - filename

2. Via pgAdmin:

Given a URL that looks like jdbc:postgresql://30.30.XX.XXX/stakeholder_temp, note that 30.30.XX.XXX is the database IP and the last part ('stakeholder_temp') is a DB name

• Right-click and choose 'Create' → 'Server'.  
• On the 'General' tab name a connection whatever you like.
• On the 'Connection' tab: The hostname/address should contain the DB IP. Port: 5432.
• Obtain a username and password from an administrator or one of the backend developers.
• On the advanced tab under 'DB Restriction' insert a DB name ('stakeholder_temp')
• Press Save.
• Right-click on the newly created server and choose 'Connect Server
• Choose 'Databases'. Right-click on a DB name and select 'Backup'.
• In an opened dialog give a name to a backup and press 'Backup'

   3. Via DBeaver (community edition):

• Install PostgreSQL
• Select 'File' → 'New' → 'Database connection' → 'Popular' → 'PostgreSQL'.
• 'Host': DB IP. Port: 5432. 'Database': DB name.
• Obtain a username and password from an administrator or one of the backend developers.
• Press 'Finish'
• Right-click on a DB name, and select 'Tools' → 'Backup'.
• Add a PostgreSQL client in a 'Client configuration'. Select 'Objects' → 'public'.
• Select 'Next' to check the output folder.
• Press 'Start'