problems restoring database from plain text backup
| От | Oleg |
|---|---|
| Тема | problems restoring database from plain text backup |
| Дата | |
| Msg-id | 43A7FEA5.8050502@iwk.uka.de обсуждение исходный текст |
| Список | 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
В списке pgsql-novice по дате отправления: