Correct Syntax For Restore after This Pg_Dump

Classic Servoy
1

Hi to All,
excuse for the disturbe.
Could SomeOne resolve this problem?

1.) It was made the following pg_dump:

pg_dump -h localhost -U user -c -d -R -v db_name >file.sql

2.) Then in another computer was created the Postgres empty db_name.

3.) Then from Servoy was imported the solution (with no sample or raw) wich uses the db_name.

At this point:

  1. Is it possible to restore file.sql?
    2.) With wich exact syntax command?

Tanks in advance.
Gianni Pinna.

2

Hi all:

1 & 2) Yes from psql console:

psql -h localhost -U user -W -e -d bbdd_db_name -f file.sql

Best regards.

3

Hi All ,

Tank You very much Adelo for Your promt replay.
I am going to execute it.

Hope You will find time and the kindness You spent in Your answer a hundredfold.
Best Rgrds, Adelo.

Gianni Pinna.

4

Sorry,
but the command goes on without :

  1. returning error message;
  2. restoring data.
    Tanks,
    Gianni Pinna