Thread: PGSQL 8.2.3 Installation problem
When I run the setup of PGSQL 8.2.3, it displays error while initializing database cluster. Error displayed is: "Failed to execute initdb. Unable to set file system permissions". I am installing on Windows XP SP2 with "administrator" log in. -- View this message in context: http://www.nabble.com/PGSQL-8.2.3-Installation-problem-tf3221486.html#a8947083 Sent from the PostgreSQL - general mailing list archive at Nabble.com.
hi there same things occurs to me. Any body install win32 version with success??? best regards MDC --- RPK <rohitprakash123@indiatimes.com> escribió: > > When I run the setup of PGSQL 8.2.3, it displays > error while initializing > database cluster. Error displayed is: "Failed to > execute initdb. Unable to > set file system permissions". > > I am installing on Windows XP SP2 with > "administrator" log in. > -- > View this message in context: > http://www.nabble.com/PGSQL-8.2.3-Installation-problem-tf3221486.html#a8947083 > Sent from the PostgreSQL - general mailing list > archive at Nabble.com. > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > __________________________________________________ Preguntá. Respondé. Descubrí. Todo lo que querías saber, y lo que ni imaginabas, está en Yahoo! Respuestas (Beta). ¡Probalo ya! http://www.yahoo.com.ar/respuestas
marcelo Cortez wrote: > hi there > > same things occurs to me. > Any body install win32 version with success??? > > best regards > MDC > > > --- RPK <rohitprakash123@indiatimes.com> escribió: > >> When I run the setup of PGSQL 8.2.3, it displays >> error while initializing >> database cluster. Error displayed is: "Failed to >> execute initdb. Unable to >> set file system permissions". >> >> I am installing on Windows XP SP2 with >> "administrator" log in. >> -- >> View this message in context: >> > http://www.nabble.com/PGSQL-8.2.3-Installation-problem-tf3221486.html#a8947083 >> Sent from the PostgreSQL - general mailing list >> archive at Nabble.com. >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 2: Don't 'kill -9' the postmaster >> > > > > > > > > __________________________________________________ > Preguntá. Respondé. Descubrí. > Todo lo que querías saber, y lo que ni imaginabas, > está en Yahoo! Respuestas (Beta). > ¡Probalo ya! > http://www.yahoo.com.ar/respuestas > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > I've installed it on my WinXP Professional SP2 (32 bit) machine without error. Action start 6:33:07: SetPermissions. 1: Setting filesystem permissions... Action ended 6:33:07: SetPermissions. Return value 1. MSI (s) (F4:44) [06:33:07:312]: Doing action: RunInitdb Action 6:33:07: RunInitdb. Initializing database cluster (this may take a minute or two)... Action start 6:33:07: RunInitdb. 1: Initializing database cluster (this may take a minute or two)... Action ended 6:33:07: RunInitdb. Return value 1. I wasn't installing under administrator, did this under my own account and had the install create the 'postgres' user account. Perhaps something wrong with the default file permissions where you are installing Postgres. I assume Postgres creates directories that inherit the parent directory permissions. If you have given the parent restricted access, the 'postgres' user that PG runs under may not have access to those dirs. Only thing I can think of anyway, if not then I am not sure why you would be having a problem. Regards, Paul. -- Paul Lambert Database Administrator AutoLedgers
Paul, I installed on a Fat32 partition and gave the data directory path to an NTFS partition. I have not set any file permissions. Installing as a default "postgres" user. Paul Lambert-2 wrote: > > marcelo Cortez wrote: >> hi there >> >> same things occurs to me. >> Any body install win32 version with success??? >> >> best regards >> MDC >> >> >> --- RPK <rohitprakash123@indiatimes.com> escribió: >> >>> When I run the setup of PGSQL 8.2.3, it displays >>> error while initializing >>> database cluster. Error displayed is: "Failed to >>> execute initdb. Unable to >>> set file system permissions". >>> >>> I am installing on Windows XP SP2 with >>> "administrator" log in. >>> -- >>> View this message in context: >>> >> http://www.nabble.com/PGSQL-8.2.3-Installation-problem-tf3221486.html#a8947083 >>> Sent from the PostgreSQL - general mailing list >>> archive at Nabble.com. >>> >>> >>> ---------------------------(end of >>> broadcast)--------------------------- >>> TIP 2: Don't 'kill -9' the postmaster >>> >> >> >> >> >> >> >> >> __________________________________________________ >> Preguntá. Respondé. Descubrí. >> Todo lo que querías saber, y lo que ni imaginabas, >> está en Yahoo! Respuestas (Beta). >> ¡Probalo ya! >> http://www.yahoo.com.ar/respuestas >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 3: Have you checked our extensive FAQ? >> >> http://www.postgresql.org/docs/faq >> >> > > I've installed it on my WinXP Professional SP2 (32 bit) machine without > error. > > Action start 6:33:07: SetPermissions. > 1: Setting filesystem permissions... > Action ended 6:33:07: SetPermissions. Return value 1. > MSI (s) (F4:44) [06:33:07:312]: Doing action: RunInitdb > Action 6:33:07: RunInitdb. Initializing database cluster (this may take > a minute or two)... > Action start 6:33:07: RunInitdb. > 1: Initializing database cluster (this may take a minute or two)... > Action ended 6:33:07: RunInitdb. Return value 1. > > I wasn't installing under administrator, did this under my own account > and had the install create the 'postgres' user account. > > Perhaps something wrong with the default file permissions where you are > installing Postgres. I assume Postgres creates directories that inherit > the parent directory permissions. If you have given the parent > restricted access, the 'postgres' user that PG runs under may not have > access to those dirs. > > Only thing I can think of anyway, if not then I am not sure why you > would be having a problem. > > Regards, > Paul. > > -- > Paul Lambert > Database Administrator > AutoLedgers > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > > -- View this message in context: http://www.nabble.com/PGSQL-8.2.3-Installation-problem-tf3221486.html#a8964644 Sent from the PostgreSQL - general mailing list archive at Nabble.com.
The installer is not supported in a fat environment. you need to install the binaries manually for that. /Magnus ------- Original message ------- From: RPK <rohitprakash123@indiatimes.com> Sent: 2-14-'07, 5:14 > > Paul, > > I installed on a Fat32 partition and gave the data directory path to an NTFS > partition. I have not set any file permissions. Installing as a default > "postgres" user. > > > Paul Lambert-2 wrote: > > > > marcelo Cortez wrote: > >> hi there > >> > >> same things occurs to me. > >> Any body install win32 version with success??? > >> > >> best regards > >> MDC > >> > >> > >> --- RPK <rohitprakash123@indiatimes.com> escribió: > >> > >>> When I run the setup of PGSQL 8.2.3, it displays > >>> error while initializing > >>> database cluster. Error displayed is: "Failed to > >>> execute initdb. Unable to > >>> set file system permissions". > >>> > >>> I am installing on Windows XP SP2 with > >>> "administrator" log in. > >>> -- > >>> View this message in context: > >>> > >> http://www.nabble.com/PGSQL-8.2.3-Installation-problem-tf3221486.html#a8947083 > >>> Sent from the PostgreSQL - general mailing list > >>> archive at Nabble.com. > >>> > >>> > >>> ---------------------------(end of > >>> broadcast)--------------------------- > >>> TIP 2: Don't 'kill -9' the postmaster > >>> > >> > >> > >> > >> > >> > >> > >> > >> __________________________________________________ > >> Preguntá. Respondé. Descubrí. > >> Todo lo que querías saber, y lo que ni imaginabas, > >> está en Yahoo! Respuestas (Beta). > >> ¡Probalo ya! > >> http://www.yahoo.com.ar/respuestas > >> > >> > >> ---------------------------(end of broadcast)--------------------------- > >> TIP 3: Have you checked our extensive FAQ? > >> > >> http://www.postgresql.org/docs/faq > >> > >> > > > > I've installed it on my WinXP Professional SP2 (32 bit) machine without > > error. > > > > Action start 6:33:07: SetPermissions. > > 1: Setting filesystem permissions... > > Action ended 6:33:07: SetPermissions. Return value 1. > > MSI (s) (F4:44) [06:33:07:312]: Doing action: RunInitdb > > Action 6:33:07: RunInitdb. Initializing database cluster (this may take > > a minute or two)... > > Action start 6:33:07: RunInitdb. > > 1: Initializing database cluster (this may take a minute or two)... > > Action ended 6:33:07: RunInitdb. Return value 1. > > > > I wasn't installing under administrator, did this under my own account > > and had the install create the 'postgres' user account. > > > > Perhaps something wrong with the default file permissions where you are > > installing Postgres. I assume Postgres creates directories that inherit > > the parent directory permissions. If you have given the parent > > restricted access, the 'postgres' user that PG runs under may not have > > access to those dirs. > > > > Only thing I can think of anyway, if not then I am not sure why you > > would be having a problem. > > > > Regards, > > Paul. > > > > -- > > Paul Lambert > > Database Administrator > > AutoLedgers > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 9: In versions below 8.0, the planner will ignore your desire to > > choose an index scan if your joining column's datatypes do not > > match > > > > > > -- > View this message in context: http://www.nabble.com/PGSQL-8.2.3-Installation-problem-tf3221486.html#a8964644 > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly
Magnus I have NTFS only , i don't have FAT partitions at all. But the problem is not resolved. The install fail at create cluster for me. I set all permisions for user postgres. Binary manual installation .. make sense i try . It has any manual/instructions/links for that? Best regards MDC --- Magnus Hagander <magnus@hagander.net> escribió: > The installer is not supported in a fat environment. > you need to install the binaries manually for that. > > /Magnus > > ------- Original message ------- > From: RPK <rohitprakash123@indiatimes.com> > Sent: 2-14-'07, 5:14 > > > > > Paul, > > > > I installed on a Fat32 partition and gave the data > directory path to an NTFS > > partition. I have not set any file permissions. > Installing as a default > > "postgres" user. > > > > > > Paul Lambert-2 wrote: > > > > > > marcelo Cortez wrote: > > >> hi there > > >> > > >> same things occurs to me. > > >> Any body install win32 version with success??? > > >> > > >> best regards > > >> MDC > > >> > > >> > > >> --- RPK <rohitprakash123@indiatimes.com> > escribió: > > >> > > >>> When I run the setup of PGSQL 8.2.3, it > displays > > >>> error while initializing > > >>> database cluster. Error displayed is: "Failed > to > > >>> execute initdb. Unable to > > >>> set file system permissions". > > >>> > > >>> I am installing on Windows XP SP2 with > > >>> "administrator" log in. > > >>> -- > > >>> View this message in context: > > >>> > > >> > http://www.nabble.com/PGSQL-8.2.3-Installation-problem-tf3221486.html#a8947083 > > >>> Sent from the PostgreSQL - general mailing > list > > >>> archive at Nabble.com. > > >>> > > >>> > > >>> ---------------------------(end of > > >>> broadcast)--------------------------- > > >>> TIP 2: Don't 'kill -9' the postmaster > > >>> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > __________________________________________________ > > >> Preguntá. Respondé. Descubrí. > > >> Todo lo que querías saber, y lo que ni > imaginabas, > > >> está en Yahoo! Respuestas (Beta). > > >> ¡Probalo ya! > > >> http://www.yahoo.com.ar/respuestas > > >> > > >> > > >> ---------------------------(end of > broadcast)--------------------------- > > >> TIP 3: Have you checked our extensive FAQ? > > >> > > >> > http://www.postgresql.org/docs/faq > > >> > > >> > > > > > > I've installed it on my WinXP Professional SP2 > (32 bit) machine without > > > error. > > > > > > Action start 6:33:07: SetPermissions. > > > 1: Setting filesystem permissions... > > > Action ended 6:33:07: SetPermissions. Return > value 1. > > > MSI (s) (F4:44) [06:33:07:312]: Doing action: > RunInitdb > > > Action 6:33:07: RunInitdb. Initializing database > cluster (this may take > > > a minute or two)... > > > Action start 6:33:07: RunInitdb. > > > 1: Initializing database cluster (this may take > a minute or two)... > > > Action ended 6:33:07: RunInitdb. Return value 1. > > > > > > I wasn't installing under administrator, did > this under my own account > > > and had the install create the 'postgres' user > account. > > > > > > Perhaps something wrong with the default file > permissions where you are > > > installing Postgres. I assume Postgres creates > directories that inherit > > > the parent directory permissions. If you have > given the parent > > > restricted access, the 'postgres' user that PG > runs under may not have > > > access to those dirs. > > > > > > Only thing I can think of anyway, if not then I > am not sure why you > > > would be having a problem. > > > > > > Regards, > > > Paul. > > > > > > -- > > > Paul Lambert > > > Database Administrator > > > AutoLedgers > > > > > > ---------------------------(end of > broadcast)--------------------------- > > > TIP 9: In versions below 8.0, the planner will > ignore your desire to > > > choose an index scan if your joining > column's datatypes do not > > > match > > > > > > > > > > -- > > View this message in context: > http://www.nabble.com/PGSQL-8.2.3-Installation-problem-tf3221486.html#a8964644 > > Sent from the PostgreSQL - general mailing list > archive at Nabble.com. > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 1: if posting/reading through Usenet, please > send an appropriate > > subscribe-nomail command to > majordomo@postgresql.org so that your > > message can get through to the mailing list > cleanly > > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will > ignore your desire to > choose an index scan if your joining column's > datatypes do not > match > __________________________________________________ Preguntá. Respondé. Descubrí. Todo lo que querías saber, y lo que ni imaginabas, está en Yahoo! Respuestas (Beta). ¡Probalo ya! http://www.yahoo.com.ar/respuestas
marcelo Cortez wrote: > Magnus > > I have NTFS only , i don't have FAT partitions at > all. > But the problem is not resolved. > The install fail at create cluster for me. > I set all permisions for user postgres. > > Binary manual installation .. make sense i try . > It has any manual/instructions/links for that? > > Best regards > MDC > > > Have you run the setup with the 'write detailed installation log to postgresql-8.2.log in the current directory' checked? Can you paste the relevant bits of that log (which you can find in the same directory as the installation file) into a message so more educated persons can take a look? If it's a file system problem, I'd also suggest going to http://www.sysinternals.com to their file and disk utilities, download ntfilemon and run it to monitor file activity (HINT: Set the filter to include only *postgres*, otherwise you will be flooded with information relating to file system access from everything else on your server - and turn on advanced output) that may show you more information about what the error was from the file system point of view. -- Paul Lambert Database Administrator AutoLedgers
Paul Thanks for your time. the installer log say: fixing permissions on existing directory C:/Archivos de programa/PostgreSQL/8.2/data ... ok creating subdirectories ... initdb: could not create directory "C:/Archivos de programa": File exists initdb: removing contents of data directory "C:/Archivos de programa/PostgreSQL/8.2/data" note path is truncated in message ??? file not exists i delete directory one more time thanks best regardsd mdc --- Paul Lambert <paul.lambert@autoledgers.com.au> escribió: > marcelo Cortez wrote: > > Magnus > > > > I have NTFS only , i don't have FAT partitions > at > > all. > > But the problem is not resolved. > > The install fail at create cluster for me. > > I set all permisions for user postgres. > > > > Binary manual installation .. make sense i try > . > > It has any manual/instructions/links for that? > > > > Best regards > > MDC > > > > > > > > Have you run the setup with the 'write detailed > installation log to > postgresql-8.2.log in the current directory' > checked? > > Can you paste the relevant bits of that log (which > you can find in the > same directory as the installation file) into a > message so more educated > persons can take a look? > > If it's a file system problem, I'd also suggest > going to > http://www.sysinternals.com to their file and disk > utilities, download > ntfilemon and run it to monitor file activity (HINT: > Set the filter to > include only *postgres*, otherwise you will be > flooded with information > relating to file system access from everything else > on your server - and > turn on advanced output) that may show you more > information about what > the error was from the file system point of view. > > -- > Paul Lambert > Database Administrator > AutoLedgers > > __________________________________________________ Preguntá. Respondé. Descubrí. Todo lo que querías saber, y lo que ni imaginabas, está en Yahoo! Respuestas (Beta). ¡Probalo ya! http://www.yahoo.com.ar/respuestas
On Thu, Feb 15, 2007 at 01:18:25AM -0300, marcelo Cortez wrote: > Paul > > Thanks for your time. > the installer log say: > > fixing permissions on existing directory C:/Archivos > de programa/PostgreSQL/8.2/data ... ok > creating subdirectories ... initdb: could not create > directory "C:/Archivos de programa": File exists > initdb: removing contents of data directory > "C:/Archivos de programa/PostgreSQL/8.2/data" > > note path is truncated in message ??? > file not exists i delete directory > one more time thanks This sounds like a permissions problem on either c:\ or c:\archivos de programa. Note that the account must have specific permissions there *not* granted through the user of Administrators or Power Users, because those permissions are given up before it tries to access them. //Magnus