Cannot Load the Database in PostgreSQL

Question

I'm following the tutorial of loading a dvdrental database as shown in the link below: http://www.postgresqltutorial.com/load-postgresql-sample-database/

I have done the first step successfully but when I came to the step 2 and 3 which navigating the bin folder and loading the data I was stuck. It keeps prompt me with the invalid command message as shown in the picture below.

enter image description here

Anyone know how to solve this issue? Thanks in advance for all the help!

Hy, please don't upload text, table or error message as image. Edit your question to contain all the information in text form - consider to use the editor's formatting options. Also see How to Ask — Daxelarne
– Daxelarne, Commented Jun 27, 2023 at 11:39

mu is too short · Accepted Answer · 2013-10-01 04:01:31Z

1

You should be running pg_restore from the shell, not from inside psql. pg_restore is a separate command line program, not a psql command.

answered Oct 1, 2013 at 4:01

mu is too short

436k71 gold badges863 silver badges822 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

green Over a year ago

what meant..hmm..means that how should I type in the command window

mu is too short Over a year ago

You're still inside psql prompt when you type pg_restore -U ..., you need to run that from a normal command line prompt.

green Over a year ago

hmm how can I run it from a normal command line prompt...sorry I'm totally new to this software

mu is too short Over a year ago

Open a terminal window or console or cmd.exe window and type the pg_restore command from there.

mu is too short Over a year ago

I dont know what "invalid command" means or who is saying that. Start by opening a plain old command prompt and then fix your PATH environment variable or use the full path to pg_restore.

|

Monish K V · Accepted Answer · 2023-06-27 11:23:58Z

0

yes i have one solution check the your file path and before that extract the file.

answered Jun 27, 2023 at 11:23

Monish K V

1

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Daxelarne · Accepted Answer · 2023-06-27 12:09:19Z

0

Just type exit.

Your are actually inside psql server and are executing command you should execute on windows.

Typing exit will close the psql connection and put you back on the windows terminal

answered Jun 27, 2023 at 12:09

Daxelarne

17813 bronze badges

Collectives™ on Stack Overflow

Cannot Load the Database in PostgreSQL

3 Answers 3

8 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

8 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related