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
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 |