Dear All,
I have a backup plain text file. It was created with Windows PgAdminIII
1.2.2 from the Linux server. Now Linux server does not functioning. I am
trying to restore it in Windows PostgreSQL. If I use PgAdmin's restore
tool then OK is stays always disabled. Somewhere was mentioned that
while backuping one should select COMPRESS option in backup tool but it
is not possible now. I tried to execute backup file using SQL tool but
I am getting a lot of errors. I tried to edit backup file manually,
I am getting errors "syntax error at or near "\" in the line:
COPY becken_varianten (becken_variante_id, knoten, becken_layout_id)
FROM stdin;
\.
may I comment "\." ?
Next problem "syntax error at or near "0"" in the line:
COPY def_becken_layout (becken_layout_id, knoten, beschreibung) FROM stdin;
0 5 keine Beckensimulation
Is there a possibility to restore backup under Windows?
Under Windows PostgreSQL 8.0 is installed. Do you thing installing
PostgreSQL 8.1 will solve the problem?
Thanks a lot in advance
Oleg