Re: backup & Restore Newgenlib

Posted by Darshangera on Nov 15, 2010; 10:21am
URL: http://ngl.70.s1.nabble.com/backup-Restore-Newgenlib-tp5739218p5739452.html

Hi, When I tried restoring from plain backup, the file generated from backup has extension .backup. Its not a sql file.

C:\Program Files\PostgreSQL\8.0\bin>psql -d newgenlib -U postgres
Password:
Welcome to psql 8.0.1, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

Warning: Console code page (437) differs from Windows code page (1252)
         8-bit characters may not work correctly. See psql reference
         page "Notes for Windows users" for details.

newgenlib=# \i \\internetimaging\d$\Newgenlib\25_oct_2010NewGenlIb.backup
\i: missing required argument
newgenlib=# \i \\internetimaging\d$\Newgenlib\25_oct_2010NewGenlIb.backup
\i: missing required argument
newgenlib=# \i \\internetimaging\d$\Newgenlib\13Nov2010-1.backup
\i: missing required argument
Could guide exact steps? We have a working newgenlib set up. I have taken backups using pgadminIII tool. I want to restore using this back up on a new setup so that when  live server fails, i can immediately recover.

Thanks