From: Alexey A. Britchko <beholder@roaddep.ru>
To: pgsql-admin@postgresql.org
Subject: encoding problem
Date: Tue, 25 Mar 2003 11:07:59 +0500
Message-ID: <14060489484.20030325110759@roaddep.ru> (raw)
Hi there
How did upgrade from pgsql 6.x to pgsql 7.x:
1. Dumped database
2. ./configure --enable-locale --enable-multibyte=WIN; make; make
install;
3. Killed postmaster daemon
3. rm -rf /usr/local/pgsql/data; mkdir /usr/local/pgsql/data; chown
postgres /usr/local/pgsql/data;
4. /usr/local/pgsql/bin/initdb -E WIN -D /usr/local/pgsql/data
5. Started postmaster daemon
6. Restored database from dbdump file.
What i've got now:
$ /usr/local/pgsql/bin/psql -l
List of databases
Name | Owner | Encoding
-----------+----------+-----------
dcl | raven | SQL_ASCII
dragons | raven | SQL_ASCII
postgres | postgres | SQL_ASCII
template0 | postgres | WIN
template1 | postgres | WIN
test | postgres | SQL_ASCII
(6 rows)
The default encoding for 4 of databases is SQL_ASCII. Well, that's OK.
The database encoding is shure to be described in the dump file. And
it seems to be restored correctly.
But now when I make selections, I get data in the SQL_ASCII (a think
so) encoding instead of WIN (WIN1251). Before PostgreSQL upgrade
everything were working correctly.
The questions:
1. What happens with the database encoding when I do pg_dumpall ?
2. How can I permanently switch database encoding without
database re-initialization? If I can't, how can I do that with DB
re-initialization?
--
Best regards,
Alexey mailto:beholder@roaddep.ru
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: beholder@roaddep.ru
Subject: Re: encoding problem
In-Reply-To: <14060489484.20030325110759@roaddep.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox