Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_restore error

pg_restore error

From
"Partners - Majolee InfoTech"
Date:
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

From
Richard Huxton
Date:
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