Обсуждение: beta2, I can't set UTF-8 for czech locales on win
Hello I would to initdb with UTF8 encoding. But after installation, I had cp1250 encoding lc_collate | Czech_Czech Republic.1250 he collation order locale.lc_ctype | Czech_Czech Republic.1250 he character classification and case conversion locale.lc_messages | Czech_Czech Republic e language in which messages are displayed.lc_monetary | Czech_Czech Republic Installation protocol is on http://www.pgsql.cz/data/postgresql-8.3-beta2.zip When I try manually rebuild cluster I had second problem: C:\PostgreSQL\bin>initdb -D ../data The program "postgres" is needed by initdb but was not found in the same directory as "C:\PostgreSQL\bin/initdb". Check your installation. but: 29.10.2007 10:24 69 632 clusterdb.exe 29.10.2007 10:24 69 632 createdb.exe 29.10.2007 10:24 61 440 createlang.exe 29.10.2007 10:24 73 728 createuser.exe 29.10.2007 10:24 56 320 dropdb.exe 29.10.2007 10:24 62 976 droplang.exe 29.10.2007 10:24 56 320 dropuser.exe 29.10.2007 10:08 106 496 initdb.exe 29.10.2007 10:25 30 208 oid2name.exe 19.10.2007 13:24 9 314 304 pgAdmin3.exe 19.10.2007 13:18 700 416 pgAgent.exe 29.10.2007 10:25 61 440 pgbench.exe 29.10.2007 10:08 38 912 pg_config.exe 29.10.2007 10:08 39 424 pg_controldata.exe 29.10.2007 10:23 65 536 pg_ctl.exe 29.10.2007 10:23 262 144 pg_dump.exe 29.10.2007 10:24 143 360 pg_dumpall.exe 29.10.2007 10:09 53 248 pg_resetxlog.exe 29.10.2007 10:24 131 072 pg_restore.exe 29.10.2007 10:10 34 304 pg_standby.exe 29.10.2007 10:23 4 009 984 postgres.exe 29.10.2007 10:23 299 008 psql.exe 29.10.2007 10:24 69 632 reindexdb.exe 15.10.2007 08:28 1 400 832 StackBuilder.exe 29.10.2007 10:24 43 008 vacuumdb.exe 29.10.2007 10:26 28 672 vacuumlo.exe 26 File(s) 17 282 048 bytes 0 Dir(s) 507240 448 bytes free What I did wrong? Regards Pave Stehule
"Pavel Stehule" <pavel.stehule@gmail.com> writes:
> When I try manually rebuild cluster I had second problem:
> C:\PostgreSQL\bin>initdb -D ../data
> The program "postgres" is needed by initdb but was not found in the
> same directory as "C:\PostgreSQL\bin/initdb".
> Check your installation.
Do you have the same problem previously reported that "postgres -V"
doesn't work? If so, maybe taking out libxml2 will help?
regards, tom lane
On 01/11/2007, Tom Lane <tgl@sss.pgh.pa.us> wrote: > "Pavel Stehule" <pavel.stehule@gmail.com> writes: > > When I try manually rebuild cluster I had second problem: > > > C:\PostgreSQL\bin>initdb -D ../data > > The program "postgres" is needed by initdb but was not found in the > > same directory as "C:\PostgreSQL\bin/initdb". > > Check your installation. > > Do you have the same problem previously reported that "postgres -V" > doesn't work? If so, maybe taking out libxml2 will help? > > regards, tom lane > No, it is different problem. It was my beginner mistake :(. I run initdb as Administrator. It needs maybe some hint message. With runas initdb works. It was false alarm. I am sorry. All is correct. Misunderstanding is from name of czech locales, that is same for utf8 and 1250 encoding. So I tested it, and it looks well. Regards Pavel Stehule
On 1 nov, 19:30, t...@sss.pgh.pa.us (Tom Lane) wrote: > "Pavel Stehule" <pavel.steh...@gmail.com> writes: > > When I try manually rebuild cluster I had second problem: > > C:\PostgreSQL\bin>initdb -D ../data > > The program "postgres" isneededbyinitdbbutwas not found in the > > same directory as "C:\PostgreSQL\bin/initdb". > > Check your installation. > > Do you have the same problem previously reported that "postgres -V" > doesn't work? If so, maybe taking out libxml2 will help? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org Exactly same problem !! I use postgres V 8.2.4 on windows vista. Have you found a response since ?
On 02/11/2007, bruno.gaudin@gmail.com <bruno.gaudin@gmail.com> wrote: > On 1 nov, 19:30, t...@sss.pgh.pa.us (Tom Lane) wrote: > > "Pavel Stehule" <pavel.steh...@gmail.com> writes: > > > When I try manually rebuild cluster I had second problem: > > > C:\PostgreSQL\bin>initdb -D ../data > > > The program "postgres" isneededbyinitdbbutwas not found in the > > > same directory as "C:\PostgreSQL\bin/initdb". > > > Check your installation. > > > > Do you have the same problem previously reported that "postgres -V" > > doesn't work? If so, maybe taking out libxml2 will help? > > > > regards, tom lane > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Have you searched our list archives? > > > > http://archives.postgresql.org > > Exactly same problem !! I use postgres V 8.2.4 on windows vista. > Have you found a response since ? > > > use runas and run initdb as user postgres Regards Pavel Stehule
"Pavel Stehule" <pavel.stehule@gmail.com> writes:
> On 02/11/2007, bruno.gaudin@gmail.com <bruno.gaudin@gmail.com> wrote:
>> Exactly same problem !! I use postgres V 8.2.4 on windows vista.
>> Have you found a response since ?
>>
> use runas and run initdb as user postgres
Doesn't sound like that will fix it. The root check doesn't happen until
after we check for -V (look in backend/main/main.c). Whatever libxml2
is doing to break things must be something that affects the earlier
steps in main() ... and there aren't that many. Maybe it's a locale
thing? Anyway I think someone has to reproduce this under a debugger
on Windows to find out where it's failing.
regards, tom lane
Pavel Stehule wrote: > On 01/11/2007, Tom Lane <tgl@sss.pgh.pa.us> wrote: > > "Pavel Stehule" <pavel.stehule@gmail.com> writes: > > > When I try manually rebuild cluster I had second problem: > > > > > C:\PostgreSQL\bin>initdb -D ../data > > > The program "postgres" is needed by initdb but was not found in the > > > same directory as "C:\PostgreSQL\bin/initdb". > > > Check your installation. > > > > Do you have the same problem previously reported that "postgres -V" > > doesn't work? If so, maybe taking out libxml2 will help? > No, it is different problem. It was my beginner mistake :(. I run > initdb as Administrator. It needs maybe some hint message. With runas > initdb works. IMHO we should check for an Administrator user and reject it explicitely. The error message is way too obscure. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
Alvaro Herrera wrote: > Pavel Stehule wrote: >> On 01/11/2007, Tom Lane <tgl@sss.pgh.pa.us> wrote: >>> "Pavel Stehule" <pavel.stehule@gmail.com> writes: >>>> When I try manually rebuild cluster I had second problem: >>>> C:\PostgreSQL\bin>initdb -D ../data >>>> The program "postgres" is needed by initdb but was not found in the >>>> same directory as "C:\PostgreSQL\bin/initdb". >>>> Check your installation. >>> Do you have the same problem previously reported that "postgres -V" >>> doesn't work? If so, maybe taking out libxml2 will help? > >> No, it is different problem. It was my beginner mistake :(. I run >> initdb as Administrator. It needs maybe some hint message. With runas >> initdb works. > > IMHO we should check for an Administrator user and reject it > explicitely. The error message is way too obscure. We used to do that, and got a lot more complaints then... Note that running initdb as administrator works in the vast majority of cases. It's only if you have some permissions that means you access a file only using the Administrators or PowerUsers group that it fails (because we drop those permissions) //Magnus