Thread: BUG #5130: Failed to run initdb:1

The following bug has been logged online:

Bug reference:      5130
Logged by:
Email address:      flamindragon1@gmail.com
PostgreSQL version: any
Operating system:   Win XP Pro SP2
Description:        Failed to run initdb:1
Details:

here's the log of the bug

The files belonging to this database system will be owned by user "SYSTEM".
This user must also own the server process.

The database cluster will be initialized with locale Polish_Poland.1250.
initdb: could not find suitable text search configuration for locale
Polish_Poland.1250
The default text search configuration will be set to "simple".

creating directory C:/Program Files/PostgreSQL/8.3/data ... ok
creating subdirectories ... ok
selecting default max_connections ... Nie moľna odnale«† okre˜lonego
pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
10
selecting default shared_buffers/max_fsm_pages ... Nie moľna odnale«†
okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
Nie moľna odnale«† okre˜lonego pliku.
400kB/20000
creating configuration files ... ok
creating template1 database in C:/Program Files/PostgreSQL/8.3/data/base/1
... ok
initializing pg_authid ... Nie moľna odnale«† okre˜lonego pliku.
child process exited with exit code 1
initdb: removing data directory "C:/Program Files/PostgreSQL/8.3/data"

Nie moľna odnale«† okre˜lonego pliku. = unable to find the file

On Wed, Oct 21, 2009 at 12:51 PM,  <flamindragon1@gmail.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =C2=A0 =C2=A0 =C2=A05130
> Logged by:
> Email address: =C2=A0 =C2=A0 =C2=A0flamindragon1@gmail.com
> PostgreSQL version: any
> Operating system: =C2=A0 Win XP Pro SP2
> Description: =C2=A0 =C2=A0 =C2=A0 =C2=A0Failed to run initdb:1
> Details:
>
> here's the log of the bug
>
> The files belonging to this database system will be owned by user "SYSTEM=
".
> This user must also own the server process.
>
> The database cluster will be initialized with locale Polish_Poland.1250.
> initdb: could not find suitable text search configuration for locale
> Polish_Poland.1250
> The default text search configuration will be set to "simple".
>
> creating directory C:/Program Files/PostgreSQL/8.3/data ... ok
> creating subdirectories ... ok
> selecting default max_connections ... Nie mo=C4=BEna odnale=C2=AB=E2=80=
=A0 okre=CB=9Clonego
> pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> 10
> selecting default shared_buffers/max_fsm_pages ... Nie mo=C4=BEna odnale=
=C2=AB=E2=80=A0
> okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> 400kB/20000
> creating configuration files ... ok
> creating template1 database in C:/Program Files/PostgreSQL/8.3/data/base/1
> ... ok
> initializing pg_authid ... Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=
=9Clonego pliku.
> child process exited with exit code 1
> initdb: removing data directory "C:/Program Files/PostgreSQL/8.3/data"
>
> Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku. =3D unable t=
o find the file

What's interesting to me is that I can't find that string anywhere in
the PostgreSQL 8.3 sources.  I think this must be an operating system
error message.  It looks like initdb is trying to invoke the postgres
executable as a standalone backend, and failing.  There is some code
in initdb.c's main() routine which appears to be intended to prevent
this from happening, or at least throw a less cryptic error message,
but it's evidently not working for you for some reason.  I speculate
that this might be some kind of funky permissions issue, but I am not
a Windows expert...

...Robert

2009/10/22 Robert Haas <robertmhaas@gmail.com>

> On Wed, Oct 21, 2009 at 12:51 PM,  <flamindragon1@gmail.com> wrote:
> >
> > The following bug has been logged online:
> >
> > Bug reference:      5130
> > Logged by:
> > Email address:      flamindragon1@gmail.com
> > PostgreSQL version: any
> > Operating system:   Win XP Pro SP2
> > Description:        Failed to run initdb:1
> > Details:
> >
> > here's the log of the bug
> >
> > The files belonging to this database system will be owned by user
> "SYSTEM".
> > This user must also own the server process.
> >
> > The database cluster will be initialized with locale Polish_Poland.1250.
> > initdb: could not find suitable text search configuration for locale
> > Polish_Poland.1250
> > The default text search configuration will be set to "simple".
> >
> > creating directory C:/Program Files/PostgreSQL/8.3/data ... ok
> > creating subdirectories ... ok
> > selecting default max_connections ... Nie mo=C4=BEna odnale=C2=AB=E2=80=
=A0 okre=CB=9Clonego
> > pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > 10
> > selecting default shared_buffers/max_fsm_pages ... Nie mo=C4=BEna odnal=
e=C2=AB=E2=80=A0
> > okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
> > 400kB/20000
> > creating configuration files ... ok
> > creating template1 database in C:/Program
> Files/PostgreSQL/8.3/data/base/1
> > ... ok
> > initializing pg_authid ... Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=
=9Clonego pliku.
> > child process exited with exit code 1
> > initdb: removing data directory "C:/Program Files/PostgreSQL/8.3/data"
> >
> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku. =3D unable=
 to find the file
>
> What's interesting to me is that I can't find that string anywhere in
> the PostgreSQL 8.3 sources.  I think this must be an operating system
> error message.  It looks like initdb is trying to invoke the postgres
> executable as a standalone backend, and failing.  There is some code
> in initdb.c's main() routine which appears to be intended to prevent
> this from happening, or at least throw a less cryptic error message,
> but it's evidently not working for you for some reason.  I speculate
> that this might be some kind of funky permissions issue, but I am not
> a Windows expert...
>
> ...Robert
>
So, do you have any suggestions how to solve this or where I could get any
help?

On Thu, Oct 22, 2009 at 10:47 AM, flamin dragon <flamindragon1@gmail.com> w=
rote:
>
>
> 2009/10/22 Robert Haas <robertmhaas@gmail.com>
>>
>> On Wed, Oct 21, 2009 at 12:51 PM, =C2=A0<flamindragon1@gmail.com> wrote:
>> >
>> > The following bug has been logged online:
>> >
>> > Bug reference: =C2=A0 =C2=A0 =C2=A05130
>> > Logged by:
>> > Email address: =C2=A0 =C2=A0 =C2=A0flamindragon1@gmail.com
>> > PostgreSQL version: any
>> > Operating system: =C2=A0 Win XP Pro SP2
>> > Description: =C2=A0 =C2=A0 =C2=A0 =C2=A0Failed to run initdb:1
>> > Details:
>> >
>> > here's the log of the bug
>> >
>> > The files belonging to this database system will be owned by user
>> > "SYSTEM".
>> > This user must also own the server process.
>> >
>> > The database cluster will be initialized with locale Polish_Poland.125=
0.
>> > initdb: could not find suitable text search configuration for locale
>> > Polish_Poland.1250
>> > The default text search configuration will be set to "simple".
>> >
>> > creating directory C:/Program Files/PostgreSQL/8.3/data ... ok
>> > creating subdirectories ... ok
>> > selecting default max_connections ... Nie mo=C4=BEna odnale=C2=AB=E2=
=80=A0 okre=CB=9Clonego
>> > pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > 10
>> > selecting default shared_buffers/max_fsm_pages ... Nie mo=C4=BEna odna=
le=C2=AB=E2=80=A0
>> > okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku.
>> > 400kB/20000
>> > creating configuration files ... ok
>> > creating template1 database in C:/Program
>> > Files/PostgreSQL/8.3/data/base/1
>> > ... ok
>> > initializing pg_authid ... Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=
=CB=9Clonego pliku.
>> > child process exited with exit code 1
>> > initdb: removing data directory "C:/Program Files/PostgreSQL/8.3/data"
>> >
>> > Nie mo=C4=BEna odnale=C2=AB=E2=80=A0 okre=CB=9Clonego pliku. =3D unabl=
e to find the file
>>
>> What's interesting to me is that I can't find that string anywhere in
>> the PostgreSQL 8.3 sources. =C2=A0I think this must be an operating syst=
em
>> error message. =C2=A0It looks like initdb is trying to invoke the postgr=
es
>> executable as a standalone backend, and failing. =C2=A0There is some code
>> in initdb.c's main() routine which appears to be intended to prevent
>> this from happening, or at least throw a less cryptic error message,
>> but it's evidently not working for you for some reason. =C2=A0I speculate
>> that this might be some kind of funky permissions issue, but I am not
>> a Windows expert...
>>
>> ...Robert
>
> So, do you have any suggestions how to solve this or where I could get any
> help?

Well, I'm sort of hoping one of the Windows folks will chime in
here...  but I would start by checking that PostgreSQL is in your path
exactly once and that the permissions are set right.

...Robert

Robert Haas wrote:

> Well, I'm sort of hoping one of the Windows folks will chime in
> here...  but I would start by checking that PostgreSQL is in your path
> exactly once and that the permissions are set right.

It could also be a character coding issue or an issue caused by the
localization of Windows paths.

Robert: does your system actually have a directory called "C:\Program
Files" ?

If you open the Run dialog in the Start menu, paste in:

  "C:\Program Files"

including the quotes, and press enter, does any folder open? (Note that
even if no "program files" folder is visible in C:\ in Windows Explorer
it might still open; Windows virtualises some paths).

--
Craig Ringer

2009/10/23 Craig Ringer <craig@postnewspapers.com.au>

> Robert Haas wrote:
>
> > Well, I'm sort of hoping one of the Windows folks will chime in
> > here...  but I would start by checking that PostgreSQL is in your path
> > exactly once and that the permissions are set right.
>
> It could also be a character coding issue or an issue caused by the
> localization of Windows paths.
>
> Robert: does your system actually have a directory called "C:\Program
> Files" ?
>
> If you open the Run dialog in the Start menu, paste in:
>
>  "C:\Program Files"
>
> including the quotes, and press enter, does any folder open? (Note that
> even if no "program files" folder is visible in C:\ in Windows Explorer
> it might still open; Windows virtualises some paths).
>
> --
> Craig Ringer
>
Yes it does have, and when I paste in Run dialog
 "C:\Program Files" it opens