Обсуждение: 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