pg_restore error - Mailing list pgsql-general

From Partners - Majolee InfoTech
Subject pg_restore error
Date
Msg-id 002201c5c4c6$fcc2ca00$0100a8c0@MI11
Whole thread Raw
Responses Re: pg_restore error
List pgsql-general
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

pgsql-general by date:

Previous
From: "Rafael Montoya"
Date:
Subject: Re: Hardware requirements
Next
From: "A. Kretschmer"
Date:
Subject: Re: Hardware requirements