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.
Obtain DB details (including DB name, username, and password) by accessing the backend of the JetPatch server. Run
cat intigua.properties | grep db
Then, use one of the following three methods:
- Via pg_dump Linux utility
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
where "" = the password found in intigua.properties
PGPASSWORD="" pg_dump -U <USER> -h <HOST> -p <PORT> <DBNAME> | gzip > db_dump.sql.gz
If you're already connected to the DB server you can run -
pg_dump -U <USER> -h localhost -p 5432 <DBNAME>| gzip > /tmp/db_dump.gz
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'