How to restore PostgreSQL Database from Veeam backup without a Dump ( flat file )

January 28, 2016
Research
0 Comments
paris

postgresql_1[1] Unzip your backup dir somewhere convenient where you have full read/write permission as your normal user account.

Source code

Assuming that the c:\users\myusername\desktop\postgresql folder contains the folders named bin, data, lib, etc:
 
Open a cmd shell
 
cd C:\ManageEngine\OpsManager\postgresql
 
bin\pg_ctl start -D C:\ManageEngine\OpsManager\postgresql\data
 
psql -U postgres -h127.0.0.1 -p13306 OpManagerDB
 
#for other Postgres DB you might not need to list the port/ip ( no -h -p )

If psql connects OK disconnect with the \q command then promptly make a dump of the database:
 
bin\pg_dump -Fc -U postgres -h127.0.0.1 -p13306 OpManagerDB -f mydb.dbbackup mydb

(2 votes, average: 1.00 out of 5)