Hi all,

by mistake i executed delete query on live server(production server).
on live server a backup of the database is taken through the script to
run and update the backup on stand by database server.

I know if a get the .backup file i can resolve the issue to some extent.

I got the file too..but it is only a single backup file.Now the problem is how
can i restore a backup having multiple database on my pc where postsgres is
installed.
Do i need to make a blank database having the same name as on production server ?

if yes then what will be the next step to restore it

Thanks in advance to take me out of this...

The backup file is text, correct?
search the file for the 'INSERT INTO yourtablename' statements, & copy/paste these lines into a new SQL file. Then, run the new SQL file with pgAdmin or PSQL