-1

I'm trying to import sql file in pgadmin4 using psql command in windows but it returns "The system cannot find the path specified." I tried to restore database by using pgadmin but it does not work.

Please help me.

error image

error image error image

Prabina
  • 127
  • 8
  • That screenshot has nothing to do with either `psql` or `pg_restore`. And it has absolutely nothing to do with pgAdmin which is a GUI tool, not a command line tool. –  Aug 03 '19 at 14:16
  • Sorry! I mistakenly uploaded wrong image. @a_horse_with_no_name – Prabina Aug 03 '19 at 14:18
  • `psql` is also not "pgAdmin" - but apparently there is no file `d:\backup8.sql`. What does `dir d:\b*` show you? –  Aug 03 '19 at 14:19
  • Yes, there is backup8.sql file in D drive but still it returns there is no file. @a_horse_with_no_name – Prabina Aug 03 '19 at 14:24
  • I have added image of contents od d drive. @a_horse_with_no_name – Prabina Aug 03 '19 at 14:28
  • That screenshot shows a file `backup8`, not a file named `backup8.sql` –  Aug 03 '19 at 14:33
  • That is sql file.@a_horse_with_no_name – Prabina Aug 03 '19 at 14:38

1 Answers1

1

Maybe... 1. Remove the "cd" command from beginning 2. Put the backup file other than root dir 3. Try to run your command in the terminal 4. Show me the terminal's substance

kjt
  • 11
  • 3
  • I removed the cd but it still gave me same error. I have changed the image in the question.@kjt – Prabina Aug 04 '19 at 16:13