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) 507 240 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?
Exactly same problem !! I use postgres V 8.2.4 on windows vista.
Have you found a response since ?
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.
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?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
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