problems restoring database from plain text backup

From: Oleg <evdakov(at)iwk(dot)uka(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: problems restoring database from plain text backup
Date: 2005-12-20 12:52:53
Message-ID: 43A7FEA5.8050502@iwk.uka.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message John DeSoi 2005-12-20 13:37:00 Re: Login problem
Previous Message Danjel Jungersen 2005-12-20 07:33:31 Re: Login problem