Обсуждение: pg_restore error

Поиск

Список

Период

Сортировка

pg_restore error

От

"Partners - Majolee InfoTech"

Дата:

29 сентября 2005 г., 04:25:49

Hello,

We use i686 based linux RH9.0 system and our postgresql is 8.0.3

We use following command

su -c '/usr/local/pgsql/bin/pg_dump -d -O -x [DBNAME] > [file withpath]' postgres

to generate dump.

But while restoring it gives too many errors and that is because it uses $_$ for plpgsql function body separator which the pg_restore and psql [dbname] < [file] both does not seem to understand.

Any solution to this..??

Regards,

Biren Shah
Mihir Darji

Re: pg_restore error

От

Richard Huxton

Дата:

29 сентября 2005 г., 05:35:38

Partners - Majolee InfoTech wrote:
> Hello,
>
> We use i686 based linux RH9.0 system and our postgresql is 8.0.3

> But while restoring it gives too many errors and that is because it
> uses $_$ for plpgsql function body separator which the pg_restore and
> psql [dbname] < [file] both does not seem to understand.

Are you sure that BOTH versions are 8.0?

--
   Richard Huxton
   Archonet Ltd

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: pg_restore error

pg_restore error

Re: pg_restore error