"Phillip Smith" <[EMAIL PROTECTED]> writes:
> How has the software been misinformed and how can we avoid it then? :)
Well, if that were entirely clear then we could fix it.
> The start of the pgdump sets the client encoding, so shouldn't that tell PG
> that things could get strange?
The problems
> "Phillip Smith" <[EMAIL PROTECTED]> writes:
> > I've been thinking about this, and while I don't agree it's a bug, I
> think
> > that perhaps PostgreSQL should raise a notice or warning that the
> > destination database has different encoding than the file being
> restored...?
>
> If Postgres ac
"Phillip Smith" <[EMAIL PROTECTED]> writes:
> I've been thinking about this, and while I don't agree it's a bug, I think
> that perhaps PostgreSQL should raise a notice or warning that the
> destination database has different encoding than the file being restored...?
If Postgres actually *knows* t
> > Are you sure that the destination database has the same encoding
> > declaration as the source did?
>
> That's what I'd be looking at - I had similar problems a few weeks ago.
> See
> this thread:
> http://archives.postgresql.org/pgsql-admin/2007-12/msg00235.php
I've been thinking about this,
> Are you sure that the destination database has the same encoding
> declaration as the source did?
That's what I'd be looking at - I had similar problems a few weeks ago. See
this thread:
http://archives.postgresql.org/pgsql-admin/2007-12/msg00235.php
THINK BEFORE YOU PRINT - Save paper if you
"Mikel Lindsaar" <[EMAIL PROTECTED]> writes:
> If you have bad character encodings in your data, you can not backup
> and restore that data using pg_dump and pg_restore, on Windows Server
> 2003, using compress or plain text modes. Both modes fail on the bad
> encoding when you try to restore.
Ar
Hello List,
I have done some searching and looking at all the documentation I
could find, and I have found a (what i consider) a bug in pg_dump
pg_restore that I wanted to bounce off the list to find their
solutions.
I have a database which gets updated from many locations and it looks
like we ha
