Hi All ,
I am having a postgres backupfile with name x.sqlc. I want to restore it . It is using an user with name "Postgres" . I have created the user postgres . I have added the user in the database. But still during the restore i am getting the following exception.Please help
C:\Program Files\pgAdmin III\1.12\pg_restore.exe --host localhost --port 5432 --username "DBA" --dbname rfs --verbose "C:\Users\ashutosl\Desktop\RFS Info\rfs11.07.2011_23.00.sqlc"
pg_restore: connecting to database for restore
pg_restore: creating SCHEMA public
pg_restore: creating COMMENT SCHEMA public
pg_restore: creating PROCEDURAL LANGUAGE plpgsql
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 404; 2612 11574 PROCEDURAL LANGUAGE plpgsql postgres
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "PROCEDURAL"
LINE 2: CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql;
Thanks in advance . Waitng for your feedback.