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:
- 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'
Comments
0 comments
Please sign in to leave a comment.