[EMAIL PROTECTED] wrote:
>
> Here is the latest issue, to verify that the pg_dump works, I'm going
> to do dump and restore on the same host/cluster.
>
> Source:
> DB_source:
> Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
> psql 8.2.4
> Destination:
> same machine different db name
On 9/5/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Thanks all for the quick replies.
>
> SET client_encoding = 'UTF8';
>
> Results, same error. Now I'm really concerned.
How / where are you setting the client_encoding? I'm wonder if it's
really set when the pg_dump / pg_restore commands ar
Thanks all for the quick replies.
Here is the latest issue, to verify that the pg_dump works, I'm going
to do dump and restore on the same host/cluster.
Source:
DB_source:
Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
psql 8.2.4
Destination:
same machine different db name
echo $LAN
On 9/4/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Trying to do pg_restore from one UTF8 encoded db to another UTF8 encoded db
> DB_source:
> Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
> psql 8.2.4
>
> DB Destination:
> Debian GNU/Linux 4.0
> psql 8.1.9
>
> I've tried:
> p
On Sep 4, 2007, at 14:48 , [EMAIL PROTECTED] wrote:
Trying to do pg_restore from one UTF8 encoded db to another UTF8
encoded db
DB_source:
Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
psql 8.2.4
DB Destination:
Debian GNU/Linux 4.0
psql 8.1.9
UTF8 to UTF8 and everything in
Trying to do pg_restore from one UTF8 encoded db to another UTF8 encoded db
DB_source:
Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
psql 8.2.4
DB Destination:
Debian GNU/Linux 4.0
psql 8.1.9
I've tried:
pg_dump from the source box & from destination box
from destination server
