Re: problems restoring database from plain text backup from psql

Oleg <evdakov(at)iwk(dot)uka(dot)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