I got large size database dump from client. To restore it in original fromat on my db server I am using,
pg_restore -v -C -Fc -h host -p port db_dump_name
As its in verbose mode, it issues create database command and new database is also created. Also running process show somthing like this:
insert into account values ........
The restore process is not yet completed.
But when I am trying to connect to newly created database,
I canot see any table except system tables. Even account table is in use, I cannot see it too. On the otherhand, disk available space is decreasing continiously. It means pg_restore process is writing somewhere.
So how can I retrive the entire database in original state?
Any suggestion to try...?