Обсуждение: problems restoring database from plain text backup from psql

One more thing to mention is that this database is PostGIS enabled. So I
had to remove all CREATE FUNCTION commands in the backup file.
In the mean time I tried to restore with psql:
psql mydb < mybackup.sql -U postgres
Unfortunately I have no possibility to enter my password
Somehow password is entered automatically and prompt jumps over the
place where password should be entered. I am getting:
"psql: FATAL: password authentication failed for user "postgres""
Best regards
Oleg

Oleg <evdakov@iwk.uka.de> writes:
> One more thing to mention is that this database is PostGIS enabled. So I
> had to remove all CREATE FUNCTION commands in the backup file.

Don't remove them; instead, load an up-to-date version of PostGIS into
the database before you try to restore the dump.  You'll then get
"duplicate function" complaints during the restore, but you can ignore
those.  This avoids the risk of introducing errors into the dump by
manual editing.

> In the mean time I tried to restore with psql:
> psql mydb < mybackup.sql -U postgres
> Unfortunately I have no possibility to enter my password

On Windows you must use "-f mybackup.sql" --- if you use "<" then that
commandeers stdin entirely and so there's no way to enter a password
from the keyboard.  Alternatively, start psql normally and then read
the dump file with "\i mybackup.sql".

            regards, tom lane