PostgreSQL Backup and Restore
Este projeto permite realizar backup e restore de um banco de dados PostgreSQL.
Use o comando: java -jar backup-postgresql-1.0.jar databaseName databasePassword type
type = backup or restore
Esquema para criação de um banco de teste:
-- Create database ----------------------------------------------------------------
CREATE DATABASE bycar;
-- Create table car and insert values ---------------------------------------------
CREATE TABLE IF NOT EXISTS cars ( id BIGSERIAL PRIMARY KEY, _name CHARACTER VARYING(50) NOT NULL, color CHARACTER VARYING(50) NOT NULL, _value REAL );
INSERT INTO cars (_name, color, _value) VALUES ('GM Prisma Maxx', 'Silver', 25000); INSERT INTO cars (_name, color, _value) VALUES ('Ford Ka SE', 'Black', 35000); INSERT INTO cars (_name, color, _value) VALUES ('VW Fox TSI', 'White', 55000); INSERT INTO cars (_name, color, _value) VALUES ('Toyota Corolla XEI', 'Red', 65000);
-- Show data -----------------------------------------------------------------------
SELECT * FROM cars;