I had a file with name "dump_live" which contains all the dump using "pg_dumpall > dump_live". Now, I need to restore it to another schema "schema2". How can I restore the data from that file to specified empty schema2. (This schema is created with out any objects). Pls advice me how to handle.
You dumped the entire database cluster...data, schema definitions, user/group data, etc. You're going to have to specify options for dumping and restoring data to do what you wish. This is well-documented in the list archives, the website, man pages, and many, many other places. Please read them.
