PostgreSQL Discussion - pg

Author

pg_restore error

Partners - Majolee InfoTech

2005-09-29, 3:23 am

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

Richard Huxton

2005-09-29, 7:24 am

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Sponsored Links