Database import failed in postgresql

[winzip]

sample database import to PostgreSQL DB failed.

This sample database file “dellstore2” is basically available here Link

Here is the my db details
Database : postgresql 9.4.7
Host : AWS RDS postgresql
data Import tool : pgadmin 4
database file. https://github.com/srconline/database

Here is the issue I faced during database import.( screen captured in video)

Video_pgsql

Can anyone please tell what is going wrong with this ?

I tried with databse restore and psql command line also but there was no success.

Is there any way to upload this sample database in postgresql ?

[r937]

vimeo link is b0rk3n

[winzip]

please see this (see in fullscreen )

Video_pgsql

[r937]

thanks… had never seen that before

not sure how COPY ... FROM STDIN is supposed to work, sorry

have you checked the manual?

[winzip]

This is probably supposed to work from command line ( stdin ).

I did this import from command line stdin also like below from my windows box

psql -f dellstore2-normal-1.0.sql --host xxxxxxx-postgresql.xxxxxx.xx-xxx-1.rds.amazonaws.com --port 5432 --username xxxxxxx --password xxxxxxx --dbname dellstore2

did not work either.

Could you please give it a try and let me know if you have any luck to the import to your local postgresql db

This sample database file “dellstore2” is basically available here Link

here is the same sql file in github also https://github.com/srconline/database

thanks