incorrect restore from pg_dumpall

Поиск
Список
Период
Сортировка
От Tomas Lanczos
Тема incorrect restore from pg_dumpall
Дата
Msg-id 1259367099.2471.24.camel@thor
обсуждение исходный текст
Ответы Re: incorrect restore from pg_dumpall
Список pgsql-general
Hello,

I am trying to restore my databases stored by a pg_dumpall command in
the Karmic Koala box. The restore command is the following:

psql -f /media/disk/.../backup -U postgres

I have a PostsgreSQL 8.4 installed from repositories with postgis1.4.1.
I recognized that the tables with spatial geometries were not restored
but at the moment I am almost sure  that it's caused by that the older
version of postgis in the stored database. What is a kind of mystery for
me that data in several tables were not restored, although the table
definitions did (it means that I got several tables without data)
althoug the data are there in the backup file (I checked physically). I
really don't understand what's going on there, I did the same many times
before, without any problem.

Tomas




В списке pgsql-general по дате отправления:

Предыдущее
От: "bbhe"
Дата:
Сообщение: return value for PQbinaryTuples
Следующее
От: Paul Ramsey
Дата:
Сообщение: Re: incorrect restore from pg_dumpall