Thread: Runtime Problems
Hello All I am quite new to pgsql and the Win32 port. I have just tried Vishal's new guide to building and I am having what looks like a path problem when I try to initialise a database. I am using Windows 2000. Everything builds and installs OK and I have copied the files in the msys\1.0\local\pgsql to my c:\pgsql folder as per the instructions. I have added C:\pgsql\bin and c:\pgsql\lib to my path as instructed. When I try to run initdb I get the following error initdb -D c:\pgsql\data -W --lc-collate=C Bad command or file name fgets failure: No error Bad command or file name fgets failure: No error The program "postgres" is needed by initdb but was not found in the directory "C:/msys/1.0/local/pgsql/bin". Check your installation I would appreciate any clues here as this has me stumped. I don't understand why is should even be looking in the msys directory. Regards Richard _______________________________________ Richard Luckhurst Manager / Engineer Sound Advice / BSP Internet Services P.O. Box 104 Narrabri NSW 2390 Ph / Fax 02 6792 6060 http://www.bsp.aunz.com
Attachment
Take a peek at the -L option to initdb. Sounds like you need to do something like: initdb -L c:\pgsql\share -D c:\pgsql\data -W --lc-collate=C This is a long standing quirk with the win32 port which is (finally) being fixed pretty much as we speak. Cheers, Claudio > -----Original Message----- > From: Richard Luckhurst [mailto:rickl@soundadvice.aunz.net] > Sent: Thursday, 13 May 2004 11:04 AM > To: PGSQL Hackers > Subject: [pgsql-hackers-win32] Runtime Problems > > Hello All > > I am quite new to pgsql and the Win32 port. I have just tried Vishal's new guide to building > and I am having what looks like a path problem when I try to initialise a database. I am using > Windows 2000. Everything builds and installs OK and I have copied the files in the msys\1.0\local\pgsql > to my c:\pgsql folder as per the instructions. I have added C:\pgsql\bin and c:\pgsql\lib to my path > as instructed. When I try to run initdb I get the following error > > initdb -D c:\pgsql\data -W --lc-collate=C > Bad command or file name > fgets failure: No error > Bad command or file name > fgets failure: No error > The program "postgres" is needed by initdb but was not found in > the directory "C:/msys/1.0/local/pgsql/bin". Check your installation > > I would appreciate any clues here as this has me stumped. I don't understand > why is should even be looking in the msys directory. > > Regards > > Richard > _______________________________________ > Richard Luckhurst > Manager / Engineer > Sound Advice / BSP Internet Services > P.O. Box 104 > Narrabri NSW 2390 > Ph / Fax 02 6792 6060 > http://www.bsp.aunz.com > << File: ATT03291.txt >> --- Certain disclaimers and policies apply to all email sent from Memetrics. For the full text of these disclaimers and policies see <a href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em ailpolicy.html</a>
Err, no. I mis-read your post. I provided you a solution to the *next* problem you are going to have :-) I'm don't see why postgres.exe would not be found if you've set your path correctly. Are you working from cvs or a recent snapshot? There's been quite a few changes to this code recently and perhaps you've gotten an inconsistent set of changes... Like I said, this stuff should hopefully be sorted in a couple days. Cheers, Claudio > -----Original Message----- > From: Claudio Natoli > Sent: Thursday, 13 May 2004 11:27 AM > To: 'Richard Luckhurst'; PGSQL Hackers > Subject: RE: [pgsql-hackers-win32] Runtime Problems > > > > Take a peek at the -L option to initdb. Sounds like you need > to do something like: > > initdb -L c:\pgsql\share -D c:\pgsql\data -W --lc-collate=C > > This is a long standing quirk with the win32 port which is > (finally) being fixed pretty much as we speak. > > Cheers, > Claudio > > > -----Original Message----- > > From: Richard Luckhurst [mailto:rickl@soundadvice.aunz.net] > > Sent: Thursday, 13 May 2004 11:04 AM > > To: PGSQL Hackers > > Subject: [pgsql-hackers-win32] Runtime Problems > > > > Hello All > > > > I am quite new to pgsql and the Win32 port. I have just > tried Vishal's new guide to building > > and I am having what looks like a path problem when I try > to initialise a database. I am using > > Windows 2000. Everything builds and installs OK and I have > copied the files in the msys\1.0\local\pgsql > > to my c:\pgsql folder as per the instructions. I have added > C:\pgsql\bin and c:\pgsql\lib to my path > > as instructed. When I try to run initdb I get the following error > > > > initdb -D c:\pgsql\data -W --lc-collate=C > > Bad command or file name > > fgets failure: No error > > Bad command or file name > > fgets failure: No error > > The program "postgres" is needed by initdb but was not found in > > the directory "C:/msys/1.0/local/pgsql/bin". Check your installation > > > > I would appreciate any clues here as this has me stumped. I > don't understand > > why is should even be looking in the msys directory. > > > > Regards > > > > Richard > > _______________________________________ > > Richard Luckhurst > > Manager / Engineer > > Sound Advice / BSP Internet Services > > P.O. Box 104 > > Narrabri NSW 2390 > > Ph / Fax 02 6792 6060 > > http://www.bsp.aunz.com > > << File: ATT03291.txt >> > --- Certain disclaimers and policies apply to all email sent from Memetrics. For the full text of these disclaimers and policies see <a href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em ailpolicy.html</a>
Hi Claudio I tried that and I get exactly the same error Regards Richard -----Original Message----- From: Claudio Natoli [mailto:claudio.natoli@memetrics.com] Sent: Thursday, 13 May 2004 11:27 AM To: 'Richard Luckhurst'; PGSQL Hackers Subject: RE: [pgsql-hackers-win32] Runtime Problems Take a peek at the -L option to initdb. Sounds like you need to do something like: initdb -L c:\pgsql\share -D c:\pgsql\data -W --lc-collate=C This is a long standing quirk with the win32 port which is (finally) being fixed pretty much as we speak. Cheers, Claudio > -----Original Message----- > From: Richard Luckhurst [mailto:rickl@soundadvice.aunz.net] > Sent: Thursday, 13 May 2004 11:04 AM > To: PGSQL Hackers > Subject: [pgsql-hackers-win32] Runtime Problems > > Hello All > > I am quite new to pgsql and the Win32 port. I have just tried Vishal's new guide to building > and I am having what looks like a path problem when I try to initialise a database. I am using > Windows 2000. Everything builds and installs OK and I have copied the files in the msys\1.0\local\pgsql > to my c:\pgsql folder as per the instructions. I have added C:\pgsql\bin and c:\pgsql\lib to my path > as instructed. When I try to run initdb I get the following error > > initdb -D c:\pgsql\data -W --lc-collate=C > Bad command or file name > fgets failure: No error > Bad command or file name > fgets failure: No error > The program "postgres" is needed by initdb but was not found in > the directory "C:/msys/1.0/local/pgsql/bin". Check your installation > > I would appreciate any clues here as this has me stumped. I don't understand > why is should even be looking in the msys directory. > > Regards > > Richard > _______________________________________ > Richard Luckhurst > Manager / Engineer > Sound Advice / BSP Internet Services > P.O. Box 104 > Narrabri NSW 2390 > Ph / Fax 02 6792 6060 > http://www.bsp.aunz.com > << File: ATT03291.txt >> --- Certain disclaimers and policies apply to all email sent from Memetrics. For the full text of these disclaimers and policies see <a href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em ailpolicy.html</a> __________ NOD32 1.758 (20040513) Information __________ This message was checked by NOD32 antivirus system. http://www.nod32.com
Attachment
Hi Claudio I am working from a snapshot about 5 days old Regards Richard -----Original Message----- From: pgsql-hackers-win32-owner@postgresql.org [mailto:pgsql-hackers-win32-owner@postgresql.org]On Behalf Of Claudio Natoli Sent: Thursday, 13 May 2004 11:30 AM To: Claudio Natoli; 'Richard Luckhurst'; 'PGSQL Hackers' Subject: Re: [pgsql-hackers-win32] Runtime Problems Err, no. I mis-read your post. I provided you a solution to the *next* problem you are going to have :-) I'm don't see why postgres.exe would not be found if you've set your path correctly. Are you working from cvs or a recent snapshot? There's been quite a few changes to this code recently and perhaps you've gotten an inconsistent set of changes... Like I said, this stuff should hopefully be sorted in a couple days. Cheers, Claudio > -----Original Message----- > From: Claudio Natoli > Sent: Thursday, 13 May 2004 11:27 AM > To: 'Richard Luckhurst'; PGSQL Hackers > Subject: RE: [pgsql-hackers-win32] Runtime Problems > > > > Take a peek at the -L option to initdb. Sounds like you need > to do something like: > > initdb -L c:\pgsql\share -D c:\pgsql\data -W --lc-collate=C > > This is a long standing quirk with the win32 port which is > (finally) being fixed pretty much as we speak. > > Cheers, > Claudio > > > -----Original Message----- > > From: Richard Luckhurst [mailto:rickl@soundadvice.aunz.net] > > Sent: Thursday, 13 May 2004 11:04 AM > > To: PGSQL Hackers > > Subject: [pgsql-hackers-win32] Runtime Problems > > > > Hello All > > > > I am quite new to pgsql and the Win32 port. I have just > tried Vishal's new guide to building > > and I am having what looks like a path problem when I try > to initialise a database. I am using > > Windows 2000. Everything builds and installs OK and I have > copied the files in the msys\1.0\local\pgsql > > to my c:\pgsql folder as per the instructions. I have added > C:\pgsql\bin and c:\pgsql\lib to my path > > as instructed. When I try to run initdb I get the following error > > > > initdb -D c:\pgsql\data -W --lc-collate=C > > Bad command or file name > > fgets failure: No error > > Bad command or file name > > fgets failure: No error > > The program "postgres" is needed by initdb but was not found in > > the directory "C:/msys/1.0/local/pgsql/bin". Check your installation > > > > I would appreciate any clues here as this has me stumped. I > don't understand > > why is should even be looking in the msys directory. > > > > Regards > > > > Richard > > _______________________________________ > > Richard Luckhurst > > Manager / Engineer > > Sound Advice / BSP Internet Services > > P.O. Box 104 > > Narrabri NSW 2390 > > Ph / Fax 02 6792 6060 > > http://www.bsp.aunz.com > > << File: ATT03291.txt >> > --- Certain disclaimers and policies apply to all email sent from Memetrics. For the full text of these disclaimers and policies see <a href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em ailpolicy.html</a> ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) __________ NOD32 1.758 (20040513) Information __________ This message was checked by NOD32 antivirus system. http://www.nod32.com
Richard Luckhurst said: > Hello All > > I am quite new to pgsql and the Win32 port. I have just tried Vishal's > new guide to building > and I am having what looks like a path problem when I try to initialise > a database. I am using > Windows 2000. Everything builds and installs OK and I have copied the > files in the msys\1.0\local\pgsql > to my c:\pgsql folder as per the instructions. I have added > C:\pgsql\bin and c:\pgsql\lib to my path > as instructed. When I try to run initdb I get the following error > > initdb -D c:\pgsql\data -W --lc-collate=C > Bad command or file name > fgets failure: No error > Bad command or file name > fgets failure: No error > The program "postgres" is needed by initdb but was not found in > the directory "C:/msys/1.0/local/pgsql/bin". Check your installation > > I would appreciate any clues here as this has me stumped. I don't > understand why is should even be looking in the msys directory. > I haven't had time to read the document referred to, but if it currently recommends that you run from anywhere but the installed path then I disagree with it. When we get relocatable installs, which Bruce is working on, you will be able to move the whole installation around to your heart's content. Have you checked that there is still in fact a C:/msys/1.0/local/pgsql/bin/postgres.exe? Could it be a permissions problem? cheers andrew
Hi Andrew > Have you checked that there is still in fact a > C:/msys/1.0/local/pgsql/bin/postgres.exe? Could it be a permissions > problem? Yes there is as I left the entire default installation in place. I have checked the permissions and everything in the bin directory is group and world readable and executable. regards Richard
> I am working from a snapshot about 5 days old Ok, that's probably why then. The relocatable install stuff Bruce is doing is pretty new, and not quite finished. I imagine the document you are working on was developed using a newer release with it more or less working. For now, if you want to keep playing with your build, I suggest you just drop the pgsql root directory into C:/msys/1.0/local/ Cheers, Claudio --- Certain disclaimers and policies apply to all email sent from Memetrics. For the full text of these disclaimers and policies see <a href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em ailpolicy.html</a>
I said: > Richard Luckhurst said: >> Hello All >> >> I am quite new to pgsql and the Win32 port. I have just tried Vishal's >> new guide to building >> and I am having what looks like a path problem when I try to >> initialise a database. I am using >> Windows 2000. Everything builds and installs OK and I have copied the >> files in the msys\1.0\local\pgsql >> to my c:\pgsql folder as per the instructions. I have added >> C:\pgsql\bin and c:\pgsql\lib to my path >> as instructed. When I try to run initdb I get the following error >> >> initdb -D c:\pgsql\data -W --lc-collate=C The clue is actually in these following 4 lines >> Bad command or file name >> fgets failure: No error >> Bad command or file name >> fgets failure: No error For some reason, initdb has found postgres.exe in 2 locations but in both cases has been unable to execute it, and consequently unable to read in the version string. That's a bit strange - I have no explanation for it right now. The relevant code has just been refactored by Bruce as part of the relocation stuff. For now, I still recommend running from the installed path. cheers andrew >> The program "postgres" is needed by initdb but was not found in >> the directory "C:/msys/1.0/local/pgsql/bin". Check your installation >> >> I would appreciate any clues here as this has me stumped. I don't >> understand why is should even be looking in the msys directory. >> > > I haven't had time to read the document referred to, but if it > currently recommends that you run from anywhere but the installed path > then I disagree with it. When we get relocatable installs, which Bruce > is working on, you will be able to move the whole installation around > to your heart's content. > > Have you checked that there is still in fact a > C:/msys/1.0/local/pgsql/bin/postgres.exe? Could it be a permissions > problem? >
Hi All
I have just recompiled using the latest snapshot and I am still getting
exactly the same errors. I still have the compile stuff in msys and the copy
in c:\pgsql so that explains why it is picking it up twice I guess. In any
case I still have the error I first asked about last week.
Regards
Richard
-----Original Message-----
From: pgsql-hackers-win32-owner@postgresql.org
[mailto:pgsql-hackers-win32-owner@postgresql.org]On Behalf Of Andrew
Dunstan
Sent: Thursday, 13 May 2004 8:54 PM
To: pgsql-hackers-win32@postgresql.org
Subject: Re: [pgsql-hackers-win32] Runtime Problems
I said:
> Richard Luckhurst said:
>> Hello All
>>
>> I am quite new to pgsql and the Win32 port. I have just tried Vishal's
>> new guide to building
>> and I am having what looks like a path problem when I try to
>> initialise a database. I am using
>> Windows 2000. Everything builds and installs OK and I have copied the
>> files in the msys\1.0\local\pgsql
>> to my c:\pgsql folder as per the instructions. I have added
>> C:\pgsql\bin and c:\pgsql\lib to my path
>> as instructed. When I try to run initdb I get the following error
>>
>> initdb -D c:\pgsql\data -W --lc-collate=C
The clue is actually in these following 4 lines
>> Bad command or file name
>> fgets failure: No error
>> Bad command or file name
>> fgets failure: No error
For some reason, initdb has found postgres.exe in 2 locations but in both
cases has been unable to execute it, and consequently unable to read in
the version string.
That's a bit strange - I have no explanation for it right now.
The relevant code has just been refactored by Bruce as part of the
relocation stuff.
For now, I still recommend running from the installed path.
cheers
andrew
>> The program "postgres" is needed by initdb but was not found in
>> the directory "C:/msys/1.0/local/pgsql/bin". Check your installation
>>
>> I would appreciate any clues here as this has me stumped. I don't
>> understand why is should even be looking in the msys directory.
>>
>
> I haven't had time to read the document referred to, but if it
> currently recommends that you run from anywhere but the installed path
> then I disagree with it. When we get relocatable installs, which Bruce
> is working on, you will be able to move the whole installation around
> to your heart's content.
>
> Have you checked that there is still in fact a
> C:/msys/1.0/local/pgsql/bin/postgres.exe? Could it be a permissions
> problem?
>
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
__________ NOD32 1.759 (20040513) Information __________
This message was checked by NOD32 antivirus system.
http://www.nod32.com
Richard Luckhurst said: > Hi All > > I have just recompiled using the latest snapshot and I am still getting > exactly the same errors. I still have the compile stuff in msys and the > copy in c:\pgsql so that explains why it is picking it up twice I > guess. In any case I still have the error I first asked about last > week. What parameters did you run configure with? cheers andrew > > Regards > > Richard > > -----Original Message----- > From: pgsql-hackers-win32-owner@postgresql.org > [mailto:pgsql-hackers-win32-owner@postgresql.org]On Behalf Of Andrew > Dunstan > Sent: Thursday, 13 May 2004 8:54 PM > To: pgsql-hackers-win32@postgresql.org > Subject: Re: [pgsql-hackers-win32] Runtime Problems > > > I said: >> Richard Luckhurst said: >>> Hello All >>> >>> I am quite new to pgsql and the Win32 port. I have just tried >>> Vishal's new guide to building >>> and I am having what looks like a path problem when I try to >>> initialise a database. I am using >>> Windows 2000. Everything builds and installs OK and I have copied the >>> files in the msys\1.0\local\pgsql >>> to my c:\pgsql folder as per the instructions. I have added >>> C:\pgsql\bin and c:\pgsql\lib to my path >>> as instructed. When I try to run initdb I get the following error >>> >>> initdb -D c:\pgsql\data -W --lc-collate=C > > The clue is actually in these following 4 lines > >>> Bad command or file name >>> fgets failure: No error >>> Bad command or file name >>> fgets failure: No error > > For some reason, initdb has found postgres.exe in 2 locations but in > both cases has been unable to execute it, and consequently unable to > read in the version string. > > That's a bit strange - I have no explanation for it right now. > > The relevant code has just been refactored by Bruce as part of the > relocation stuff. > > For now, I still recommend running from the installed path. > > cheers > > andrew > > >>> The program "postgres" is needed by initdb but was not found in the >>> directory "C:/msys/1.0/local/pgsql/bin". Check your installation >>> >>> I would appreciate any clues here as this has me stumped. I don't >>> understand why is should even be looking in the msys directory. >>> >> >> I haven't had time to read the document referred to, but if it >> currently recommends that you run from anywhere but the installed path >> then I disagree with it. When we get relocatable installs, which Bruce >> is working on, you will be able to move the whole installation around >> to your heart's content. >> >> Have you checked that there is still in fact a >> C:/msys/1.0/local/pgsql/bin/postgres.exe? Could it be a permissions >> problem? >> > >
Hi Andrew
I ran configure with the --without-zlib option
Regards
Richard
-----Original Message-----
From: pgsql-hackers-win32-owner@postgresql.org
[mailto:pgsql-hackers-win32-owner@postgresql.org]On Behalf Of Andrew
Dunstan
Sent: Sunday, 16 May 2004 8:13 PM
To: pgsql-hackers-win32@postgresql.org
Subject: Re: [pgsql-hackers-win32] Runtime Problems
Richard Luckhurst said:
> Hi All
>
> I have just recompiled using the latest snapshot and I am still getting
> exactly the same errors. I still have the compile stuff in msys and the
> copy in c:\pgsql so that explains why it is picking it up twice I
> guess. In any case I still have the error I first asked about last
> week.
What parameters did you run configure with?
cheers
andrew
>
> Regards
>
> Richard
>
> -----Original Message-----
> From: pgsql-hackers-win32-owner@postgresql.org
> [mailto:pgsql-hackers-win32-owner@postgresql.org]On Behalf Of Andrew
> Dunstan
> Sent: Thursday, 13 May 2004 8:54 PM
> To: pgsql-hackers-win32@postgresql.org
> Subject: Re: [pgsql-hackers-win32] Runtime Problems
>
>
> I said:
>> Richard Luckhurst said:
>>> Hello All
>>>
>>> I am quite new to pgsql and the Win32 port. I have just tried
>>> Vishal's new guide to building
>>> and I am having what looks like a path problem when I try to
>>> initialise a database. I am using
>>> Windows 2000. Everything builds and installs OK and I have copied the
>>> files in the msys\1.0\local\pgsql
>>> to my c:\pgsql folder as per the instructions. I have added
>>> C:\pgsql\bin and c:\pgsql\lib to my path
>>> as instructed. When I try to run initdb I get the following error
>>>
>>> initdb -D c:\pgsql\data -W --lc-collate=C
>
> The clue is actually in these following 4 lines
>
>>> Bad command or file name
>>> fgets failure: No error
>>> Bad command or file name
>>> fgets failure: No error
>
> For some reason, initdb has found postgres.exe in 2 locations but in
> both cases has been unable to execute it, and consequently unable to
> read in the version string.
>
> That's a bit strange - I have no explanation for it right now.
>
> The relevant code has just been refactored by Bruce as part of the
> relocation stuff.
>
> For now, I still recommend running from the installed path.
>
> cheers
>
> andrew
>
>
>>> The program "postgres" is needed by initdb but was not found in the
>>> directory "C:/msys/1.0/local/pgsql/bin". Check your installation
>>>
>>> I would appreciate any clues here as this has me stumped. I don't
>>> understand why is should even be looking in the msys directory.
>>>
>>
>> I haven't had time to read the document referred to, but if it
>> currently recommends that you run from anywhere but the installed path
>> then I disagree with it. When we get relocatable installs, which Bruce
>> is working on, you will be able to move the whole installation around
>> to your heart's content.
>>
>> Have you checked that there is still in fact a
>> C:/msys/1.0/local/pgsql/bin/postgres.exe? Could it be a permissions
>> problem?
>>
>
>
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
__________ NOD32 1.762 (20040516) Information __________
This message was checked by NOD32 antivirus system.
http://www.nod32.com
Richard Luckhurst wrote: >Hi Andrew > >I ran configure with the --without-zlib option > What happens if you cd to c:\pgsql and run bin/initdb -D c:\pgsql\data -W --lc-collate=C ? cheers andrew > >Regards > >Richard > >-----Original Message----- >From: pgsql-hackers-win32-owner@postgresql.org >[mailto:pgsql-hackers-win32-owner@postgresql.org]On Behalf Of Andrew >Dunstan >Sent: Sunday, 16 May 2004 8:13 PM >To: pgsql-hackers-win32@postgresql.org >Subject: Re: [pgsql-hackers-win32] Runtime Problems > > >Richard Luckhurst said: > > >>Hi All >> >>I have just recompiled using the latest snapshot and I am still getting >>exactly the same errors. I still have the compile stuff in msys and the >>copy in c:\pgsql so that explains why it is picking it up twice I >>guess. In any case I still have the error I first asked about last >>week. >> >> > >What parameters did you run configure with? > >cheers > >andrew > > > > >>Regards >> >>Richard >> >>-----Original Message----- >>From: pgsql-hackers-win32-owner@postgresql.org >>[mailto:pgsql-hackers-win32-owner@postgresql.org]On Behalf Of Andrew >>Dunstan >>Sent: Thursday, 13 May 2004 8:54 PM >>To: pgsql-hackers-win32@postgresql.org >>Subject: Re: [pgsql-hackers-win32] Runtime Problems >> >> >>I said: >> >> >>>Richard Luckhurst said: >>> >>> >>>>Hello All >>>> >>>>I am quite new to pgsql and the Win32 port. I have just tried >>>>Vishal's new guide to building >>>>and I am having what looks like a path problem when I try to >>>>initialise a database. I am using >>>>Windows 2000. Everything builds and installs OK and I have copied the >>>>files in the msys\1.0\local\pgsql >>>>to my c:\pgsql folder as per the instructions. I have added >>>>C:\pgsql\bin and c:\pgsql\lib to my path >>>>as instructed. When I try to run initdb I get the following error >>>> >>>>initdb -D c:\pgsql\data -W --lc-collate=C >>>> >>>> >>The clue is actually in these following 4 lines >> >> >> >>>>Bad command or file name >>>>fgets failure: No error >>>>Bad command or file name >>>>fgets failure: No error >>>> >>>> >>For some reason, initdb has found postgres.exe in 2 locations but in >>both cases has been unable to execute it, and consequently unable to >>read in the version string. >> >>That's a bit strange - I have no explanation for it right now. >> >>The relevant code has just been refactored by Bruce as part of the >>relocation stuff. >> >>For now, I still recommend running from the installed path. >> >>cheers >> >>andrew >> >> >> >> >>>>The program "postgres" is needed by initdb but was not found in the >>>>directory "C:/msys/1.0/local/pgsql/bin". Check your installation >>>> >>>>I would appreciate any clues here as this has me stumped. I don't >>>>understand why is should even be looking in the msys directory. >>>> >>>> >>>> >>>I haven't had time to read the document referred to, but if it >>>currently recommends that you run from anywhere but the installed path >>>then I disagree with it. When we get relocatable installs, which Bruce >>>is working on, you will be able to move the whole installation around >>>to your heart's content. >>> >>>Have you checked that there is still in fact a >>>C:/msys/1.0/local/pgsql/bin/postgres.exe? Could it be a permissions >>>problem? >>> >>> >>> >> >> > > > > >---------------------------(end of broadcast)--------------------------- >TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > > >__________ NOD32 1.762 (20040516) Information __________ > >This message was checked by NOD32 antivirus system. >http://www.nod32.com > > > >
Richard Luckhurst wrote: > Hi Andrew > > I ran configure with the --without-zlib option Should we default to this on Win32? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Hi Andrew if I try to just run bin/initdb in the pgsql directory I get the normal error that bin is not an executable. If I try the full path c:\pgsql\bin\initdb I get the same old error. Regards Richard -----Original Message----- From: Andrew Dunstan [mailto:andrew@dunslane.net] Sent: Monday, 17 May 2004 9:42 AM To: Richard Luckhurst Cc: PGSQL Hackers Subject: Re: [pgsql-hackers-win32] Runtime Problems Richard Luckhurst wrote: >Hi Andrew > >I ran configure with the --without-zlib option > What happens if you cd to c:\pgsql and run bin/initdb -D c:\pgsql\data -W --lc-collate=C ? cheers andrew > >Regards > >Richard > >-----Original Message----- >From: pgsql-hackers-win32-owner@postgresql.org >[mailto:pgsql-hackers-win32-owner@postgresql.org]On Behalf Of Andrew >Dunstan >Sent: Sunday, 16 May 2004 8:13 PM >To: pgsql-hackers-win32@postgresql.org >Subject: Re: [pgsql-hackers-win32] Runtime Problems > > >Richard Luckhurst said: > > >>Hi All >> >>I have just recompiled using the latest snapshot and I am still getting >>exactly the same errors. I still have the compile stuff in msys and the >>copy in c:\pgsql so that explains why it is picking it up twice I >>guess. In any case I still have the error I first asked about last >>week. >> >> > >What parameters did you run configure with? > >cheers > >andrew > > > > >>Regards >> >>Richard >> >>-----Original Message----- >>From: pgsql-hackers-win32-owner@postgresql.org >>[mailto:pgsql-hackers-win32-owner@postgresql.org]On Behalf Of Andrew >>Dunstan >>Sent: Thursday, 13 May 2004 8:54 PM >>To: pgsql-hackers-win32@postgresql.org >>Subject: Re: [pgsql-hackers-win32] Runtime Problems >> >> >>I said: >> >> >>>Richard Luckhurst said: >>> >>> >>>>Hello All >>>> >>>>I am quite new to pgsql and the Win32 port. I have just tried >>>>Vishal's new guide to building >>>>and I am having what looks like a path problem when I try to >>>>initialise a database. I am using >>>>Windows 2000. Everything builds and installs OK and I have copied the >>>>files in the msys\1.0\local\pgsql >>>>to my c:\pgsql folder as per the instructions. I have added >>>>C:\pgsql\bin and c:\pgsql\lib to my path >>>>as instructed. When I try to run initdb I get the following error >>>> >>>>initdb -D c:\pgsql\data -W --lc-collate=C >>>> >>>> >>The clue is actually in these following 4 lines >> >> >> >>>>Bad command or file name >>>>fgets failure: No error >>>>Bad command or file name >>>>fgets failure: No error >>>> >>>> >>For some reason, initdb has found postgres.exe in 2 locations but in >>both cases has been unable to execute it, and consequently unable to >>read in the version string. >> >>That's a bit strange - I have no explanation for it right now. >> >>The relevant code has just been refactored by Bruce as part of the >>relocation stuff. >> >>For now, I still recommend running from the installed path. >> >>cheers >> >>andrew >> >> >> >> >>>>The program "postgres" is needed by initdb but was not found in the >>>>directory "C:/msys/1.0/local/pgsql/bin". Check your installation >>>> >>>>I would appreciate any clues here as this has me stumped. I don't >>>>understand why is should even be looking in the msys directory. >>>> >>>> >>>> >>>I haven't had time to read the document referred to, but if it >>>currently recommends that you run from anywhere but the installed path >>>then I disagree with it. When we get relocatable installs, which Bruce >>>is working on, you will be able to move the whole installation around >>>to your heart's content. >>> >>>Have you checked that there is still in fact a >>>C:/msys/1.0/local/pgsql/bin/postgres.exe? Could it be a permissions >>>problem? >>> >>> >>> >> >> > > > > >---------------------------(end of broadcast)--------------------------- >TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > > >__________ NOD32 1.762 (20040516) Information __________ > >This message was checked by NOD32 antivirus system. >http://www.nod32.com > > > > __________ NOD32 1.762 (20040516) Information __________ This message was checked by NOD32 antivirus system. http://www.nod32.com
Richard Luckhurst said: > Hi Andrew > > if I try to just run bin/initdb in the pgsql directory I get the normal > error sorry - of course I meant bin\initdb -D c:\pgsql\data -W --lc-collate=C > that bin is not an executable. If I try the full path > c:\pgsql\bin\initdb I get the same old error. > > Regards > > Richard > > -----Original Message----- > From: Andrew Dunstan [mailto:andrew@dunslane.net] > Sent: Monday, 17 May 2004 9:42 AM > To: Richard Luckhurst > Cc: PGSQL Hackers > Subject: Re: [pgsql-hackers-win32] Runtime Problems > > > > > Richard Luckhurst wrote: > >>Hi Andrew >> >>I ran configure with the --without-zlib option >> > > What happens if you cd to c:\pgsql and run > > bin/initdb -D c:\pgsql\data -W --lc-collate=C > > ? > > cheers > > andrew > > >> >>Regards >> >>Richard >> >>-----Original Message----- >>From: pgsql-hackers-win32-owner@postgresql.org >>[mailto:pgsql-hackers-win32-owner@postgresql.org]On Behalf Of Andrew >>Dunstan >>Sent: Sunday, 16 May 2004 8:13 PM >>To: pgsql-hackers-win32@postgresql.org >>Subject: Re: [pgsql-hackers-win32] Runtime Problems >> >> >>Richard Luckhurst said: >> >> >>>Hi All >>> >>>I have just recompiled using the latest snapshot and I am still >>>getting exactly the same errors. I still have the compile stuff in >>>msys and the copy in c:\pgsql so that explains why it is picking it up >>>twice I guess. In any case I still have the error I first asked about >>>last week. >>> >>> >> >>What parameters did you run configure with? >> >>cheers >> >>andrew >> >> >> >> >>>Regards >>> >>>Richard >>> >>>-----Original Message----- >>>From: pgsql-hackers-win32-owner@postgresql.org >>>[mailto:pgsql-hackers-win32-owner@postgresql.org]On Behalf Of Andrew >>>Dunstan >>>Sent: Thursday, 13 May 2004 8:54 PM >>>To: pgsql-hackers-win32@postgresql.org >>>Subject: Re: [pgsql-hackers-win32] Runtime Problems >>> >>> >>>I said: >>> >>> >>>>Richard Luckhurst said: >>>> >>>> >>>>>Hello All >>>>> >>>>>I am quite new to pgsql and the Win32 port. I have just tried >>>>>Vishal's new guide to building >>>>>and I am having what looks like a path problem when I try to >>>>>initialise a database. I am using >>>>>Windows 2000. Everything builds and installs OK and I have copied >>>>>the files in the msys\1.0\local\pgsql >>>>>to my c:\pgsql folder as per the instructions. I have added >>>>>C:\pgsql\bin and c:\pgsql\lib to my path >>>>>as instructed. When I try to run initdb I get the following error >>>>> >>>>>initdb -D c:\pgsql\data -W --lc-collate=C >>>>> >>>>> >>>The clue is actually in these following 4 lines >>> >>> >>> >>>>>Bad command or file name >>>>>fgets failure: No error >>>>>Bad command or file name >>>>>fgets failure: No error >>>>> >>>>> >>>For some reason, initdb has found postgres.exe in 2 locations but in >>>both cases has been unable to execute it, and consequently unable to >>>read in the version string. >>> >>>That's a bit strange - I have no explanation for it right now. >>> >>>The relevant code has just been refactored by Bruce as part of the >>>relocation stuff. >>> >>>For now, I still recommend running from the installed path. >>> >>>cheers >>> >>>andrew >>> >>> >>> >>> >>>>>The program "postgres" is needed by initdb but was not found in the >>>>>directory "C:/msys/1.0/local/pgsql/bin". Check your installation >>>>> >>>>>I would appreciate any clues here as this has me stumped. I don't >>>>>understand why is should even be looking in the msys directory. >>>>> >>>>> >>>>> >>>>I haven't had time to read the document referred to, but if it >>>>currently recommends that you run from anywhere but the installed >>>>path then I disagree with it. When we get relocatable installs, which >>>>Bruce is working on, you will be able to move the whole installation >>>>around to your heart's content. >>>> >>>>Have you checked that there is still in fact a >>>>C:/msys/1.0/local/pgsql/bin/postgres.exe? Could it be a permissions >>>>problem? >>>> >>>> >>>> >>> >>> >> >> >> >> >>---------------------------(end of >>broadcast)--------------------------- TIP 9: the planner will ignore >>your desire to choose an index scan if your >> joining column's datatypes do not match >> >> >>__________ NOD32 1.762 (20040516) Information __________ >> >>This message was checked by NOD32 antivirus system. >>http://www.nod32.com >> >> >> >> > > > > __________ NOD32 1.762 (20040516) Information __________ > > This message was checked by NOD32 antivirus system. > http://www.nod32.com
Hi Andrew I get the same old fgets error. Regards Richard -----Original Message----- From: Andrew Dunstan [mailto:andrew@dunslane.net] Sent: Monday, 17 May 2004 12:32 PM To: rickl@soundadvice.aunz.net Cc: pgsql-hackers-win32@postgresql.org Subject: RE: [pgsql-hackers-win32] Runtime Problems Richard Luckhurst said: > Hi Andrew > > if I try to just run bin/initdb in the pgsql directory I get the normal > error sorry - of course I meant bin\initdb -D c:\pgsql\data -W --lc-collate=C > that bin is not an executable. If I try the full path > c:\pgsql\bin\initdb I get the same old error. > > Regards > > Richard > > -----Original Message----- > From: Andrew Dunstan [mailto:andrew@dunslane.net] > Sent: Monday, 17 May 2004 9:42 AM > To: Richard Luckhurst > Cc: PGSQL Hackers > Subject: Re: [pgsql-hackers-win32] Runtime Problems > > > > > Richard Luckhurst wrote: > >>Hi Andrew >> >>I ran configure with the --without-zlib option >> > > What happens if you cd to c:\pgsql and run > > bin/initdb -D c:\pgsql\data -W --lc-collate=C > > ? > > cheers > > andrew > > >> >>Regards >> >>Richard >> >>-----Original Message----- >>From: pgsql-hackers-win32-owner@postgresql.org >>[mailto:pgsql-hackers-win32-owner@postgresql.org]On Behalf Of Andrew >>Dunstan >>Sent: Sunday, 16 May 2004 8:13 PM >>To: pgsql-hackers-win32@postgresql.org >>Subject: Re: [pgsql-hackers-win32] Runtime Problems >> >> >>Richard Luckhurst said: >> >> >>>Hi All >>> >>>I have just recompiled using the latest snapshot and I am still >>>getting exactly the same errors. I still have the compile stuff in >>>msys and the copy in c:\pgsql so that explains why it is picking it up >>>twice I guess. In any case I still have the error I first asked about >>>last week. >>> >>> >> >>What parameters did you run configure with? >> >>cheers >> >>andrew >> >> >> >> >>>Regards >>> >>>Richard >>> >>>-----Original Message----- >>>From: pgsql-hackers-win32-owner@postgresql.org >>>[mailto:pgsql-hackers-win32-owner@postgresql.org]On Behalf Of Andrew >>>Dunstan >>>Sent: Thursday, 13 May 2004 8:54 PM >>>To: pgsql-hackers-win32@postgresql.org >>>Subject: Re: [pgsql-hackers-win32] Runtime Problems >>> >>> >>>I said: >>> >>> >>>>Richard Luckhurst said: >>>> >>>> >>>>>Hello All >>>>> >>>>>I am quite new to pgsql and the Win32 port. I have just tried >>>>>Vishal's new guide to building >>>>>and I am having what looks like a path problem when I try to >>>>>initialise a database. I am using >>>>>Windows 2000. Everything builds and installs OK and I have copied >>>>>the files in the msys\1.0\local\pgsql >>>>>to my c:\pgsql folder as per the instructions. I have added >>>>>C:\pgsql\bin and c:\pgsql\lib to my path >>>>>as instructed. When I try to run initdb I get the following error >>>>> >>>>>initdb -D c:\pgsql\data -W --lc-collate=C >>>>> >>>>> >>>The clue is actually in these following 4 lines >>> >>> >>> >>>>>Bad command or file name >>>>>fgets failure: No error >>>>>Bad command or file name >>>>>fgets failure: No error >>>>> >>>>> >>>For some reason, initdb has found postgres.exe in 2 locations but in >>>both cases has been unable to execute it, and consequently unable to >>>read in the version string. >>> >>>That's a bit strange - I have no explanation for it right now. >>> >>>The relevant code has just been refactored by Bruce as part of the >>>relocation stuff. >>> >>>For now, I still recommend running from the installed path. >>> >>>cheers >>> >>>andrew >>> >>> >>> >>> >>>>>The program "postgres" is needed by initdb but was not found in the >>>>>directory "C:/msys/1.0/local/pgsql/bin". Check your installation >>>>> >>>>>I would appreciate any clues here as this has me stumped. I don't >>>>>understand why is should even be looking in the msys directory. >>>>> >>>>> >>>>> >>>>I haven't had time to read the document referred to, but if it >>>>currently recommends that you run from anywhere but the installed >>>>path then I disagree with it. When we get relocatable installs, which >>>>Bruce is working on, you will be able to move the whole installation >>>>around to your heart's content. >>>> >>>>Have you checked that there is still in fact a >>>>C:/msys/1.0/local/pgsql/bin/postgres.exe? Could it be a permissions >>>>problem? >>>> >>>> >>>> >>> >>> >> >> >> >> >>---------------------------(end of >>broadcast)--------------------------- TIP 9: the planner will ignore >>your desire to choose an index scan if your >> joining column's datatypes do not match >> >> >>__________ NOD32 1.762 (20040516) Information __________ >> >>This message was checked by NOD32 antivirus system. >>http://www.nod32.com >> >> >> >> > > > > __________ NOD32 1.762 (20040516) Information __________ > > This message was checked by NOD32 antivirus system. > http://www.nod32.com __________ NOD32 1.762 (20040516) Information __________ This message was checked by NOD32 antivirus system. http://www.nod32.com
Richard Luckhurst wrote: > Hi Andrew > > I get the same old fgets error. That error is from a copy of CVS that is perhaps a few weeks old: >>>>>Bad command or file name >>>>>fgets failure: No error >>>>>Bad command or file name >>>>>fgets failure: No error I have fixed it and it shouldn't appear in current CVS. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Hi Bruce I am working from a snapshot only 2 days old. Is the snapshot no good? Regards Richard -----Original Message----- From: pgsql-hackers-win32-owner@postgresql.org [mailto:pgsql-hackers-win32-owner@postgresql.org]On Behalf Of Bruce Momjian Sent: Monday, 17 May 2004 1:54 PM To: Richard Luckhurst Cc: Andrew Dunstan; PGSQL Hackers Subject: Re: [pgsql-hackers-win32] Runtime Problems Richard Luckhurst wrote: > Hi Andrew > > I get the same old fgets error. That error is from a copy of CVS that is perhaps a few weeks old: >>>>>Bad command or file name >>>>>fgets failure: No error >>>>>Bad command or file name >>>>>fgets failure: No error I have fixed it and it shouldn't appear in current CVS. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html __________ NOD32 1.762 (20040516) Information __________ This message was checked by NOD32 antivirus system. http://www.nod32.com
Richard Luckhurst wrote: > Hi Bruce > > I am working from a snapshot only 2 days old. Is the snapshot no good? That new, huh? It should be fine. I assume the errors are coming from src/port/exec.c. Can you add some printf's in there to see where it is failing? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
> -----Original Message----- > From: Bruce Momjian [mailto:pgman@candle.pha.pa.us] > Sent: 17 May 2004 01:07 > To: Richard Luckhurst > Cc: Andrew Dunstan; PGSQL Hackers > Subject: Re: [pgsql-hackers-win32] Runtime Problems > > Richard Luckhurst wrote: > > Hi Andrew > > > > I ran configure with the --without-zlib option > > Should we default to this on Win32? I would say no. It's not difficult to get or install, and the number of ppl likely to be building from source on Win32 is probably going to be minimal. I assume it's used by toast, so the effects of not having it could be significant. Regards, Dave.
Bruce Momjian said: > Richard Luckhurst wrote: >> Hi Bruce >> >> I am working from a snapshot only 2 days old. Is the snapshot no good? > > That new, huh? It should be fine. I assume the errors are coming from > src/port/exec.c. Can you add some printf's in there to see where it is > failing? > In particular, we need to see the command line that is being passed to popen() - that's apparently where it is failing. cheers andrew
Dave Page wrote: > > > > -----Original Message----- > > From: Bruce Momjian [mailto:pgman@candle.pha.pa.us] > > Sent: 17 May 2004 01:07 > > To: Richard Luckhurst > > Cc: Andrew Dunstan; PGSQL Hackers > > Subject: Re: [pgsql-hackers-win32] Runtime Problems > > > > Richard Luckhurst wrote: > > > Hi Andrew > > > > > > I ran configure with the --without-zlib option > > > > Should we default to this on Win32? > > I would say no. It's not difficult to get or install, and the number of > ppl likely to be building from source on Win32 is probably going to be > minimal. I assume it's used by toast, so the effects of not having it > could be significant. Oh, OK. Good point. I though we had our own as a replacement library, but no I remember we don't. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073