postgresql- restoring .dump file

Question

Hi,

I am new for psql. i got from my server data.dump file. I need to restore it in my local. i tried these commands.

i) psql -U postgres dbname -f servicedb.dump

Error:
      psql: warning: extra command-line argument "-f" ignored
      psql: warning: extra command-line argument "servicedb.dump" ignored

ii) psql -U postgres dbname < servicedb.dump

 Error:
              ^
 ERROR:  syntaxe error at or near "☺"
 LINE 1: ☺☺

Any one please help me what is this ".dump" file and how to restore it.

Thanks a lot in advance. By mugesh

Answer 1

Have a look at the pg_restore command.