Correct Syntax For Restore after This Pg_Dump

[cuoredisardegna]

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

1.) It was made the following pg_dump:

Code: Select all

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.

[Adelo Herrero]

Hi all:

1 & 2) Yes from psql console:

Code: Select all

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

Best regards.

[cuoredisardegna]

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.

[cuoredisardegna]

Sorry,
but the command goes on without :
1) returning error message;
2) restoring data.
Tanks,
Gianni Pinna