Re: Can't import databases with pg_dump. Why?

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: Can't import databases with pg_dump. Why?
Дата
Msg-id m3n0op2hps.fsf@varsoon.wireboard.com
обсуждение исходный текст
Ответ на Can't import databases with pg_dump. Why?  ("Antonio G. - Geotronix" <nightnavigator@libero.it>)
Список pgsql-general
"Antonio G. - Geotronix" <antonio@sunstone.it> writes:

> In your reply you told me that I'm not using pg_dump to restore. But as
> you can see in my previus message I am using pg_dump :-)

Well, it's wrong.  ;)  I phrased my response badly--I meant "You
shouldn't try to use pg_dump to restore, because it won't work."

Try it like this:

psql famiglia <  /mnt/redhat/home/postgres_postgres/famiglia.dump

This assumes your dump is in SQL format, which pg_dump creates by
default.  If you used custom or tar format, you need to use
'pg_restore' instead.  See the documentation for more info...

-Doug

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

Предыдущее
От: Chris Bowlby
Дата:
Сообщение: Re: Inquiry From Form [pgsql]
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Sequence - Use calculated start value?