How do I generate a PostgreSQL DB Dump?

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)

su - postgres
pg_dump -U <USER> -h <HOST> -p <PORT> <DBNAME> | 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 <USER> -h <HOST> -p <PORT> <DBNAME> | gzip > db_dump.sql.gz

The file will be located in the same folder, or

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

Alternatively, you can run (note: please share 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 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 'Connection' tab: Host name/address should contain the DB IP. Port: 5432. Obtain username and password from an administrator or one of the backend developers.
• On 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 username and password from an administrator or one of the backend developers. Press 'Finish'
• Right click on a DB name, select 'Tools' → 'Backup'. Add a PostgreSQL client in a 'Client configuration'. Select 'Objects' → 'public'. Select 'Next' to check the output folder. Press 'Start'