Skip to content

Instantly share code, notes, and snippets.

View shivaKhat23's full-sized avatar

Shiva khatri shivaKhat23

View GitHub Profile
@shivaKhat23
shivaKhat23 / backup_restore.sh
Created September 15, 2019 18:13 — forked from DTailor/backup_restore.sh
Backup/Restore PostgreSQL Database
# List all databases
sudo -u postgres psql --list
# Create backup file
sudo -u postgres pg_dump [database_name] > dumpl.sql
# Drop the database
sudo -u prostgres dropdb [database_name]
# Create a new database
/*
JPA (Java Persistence API)
Transaction Management with an Entity-Mananger:
---
entityManager.getTransaction().begin();
entityManager.persist(<some-entity>);
entityManager.getTransaction().commit();
entityManager.clear();