Обсуждение: Re: During InitDB: could not access file "$
> From MSYS I did: > * configure --without-zlib > * make Try: make install 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>
Hello PGSQL, CN> Try: make install CN> Cheers, CN> Claudio Thanks, that did the trick =) Now I have a new trouble though. InitDB finished fine and I starter Postmaster: > "D:/Linux/msys/local/pgsql/bin/postmaster.exe" -i -D data > > LOG: database system was shut down at 2004-03-26 18:02:03 FLE Standard Time > LOG: checkpoint record is at 0/A02AD0 > LOG: redo record is at 0/A02AD0; undo record is at 0/0; shutdown TRUE > LOG: next transaction ID: 455; next OID: 17207 > LOG: database system is ready > LOG: select() failed in statistics buffer: No error > LOG: select() failed in statistics collector: No such file or directory > LOG: statistics collector process (PID 4100) was terminated by signal 1 It already looked bad because of these "No such file or directory". However, I tried to connect to the DB using psql: > psql > psql: server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. The server said on that: > LOG: could not receive data from client: No such file or directory > LOG: incomplete startup packet Using the "createdb" executeable yielded the same result :(. What file does it want now? =\ Regards, Vitaly Belman ICQ: 1912453 AIM: VitalyB1984 MSN: tmdagent@hotmail.com Yahoo!: VitalyBe Friday, March 26, 2004, 2:36:10 PM, you wrote: >> From MSYS I did: >> * configure --without-zlib >> * make CN> Try: make install CN> Cheers, CN> Claudio CN> --- CN> Certain disclaimers and policies apply to all email sent from Memetrics. CN> For the full text of these disclaimers and policies see CN> <a CN> href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em CN> ailpolicy.html</a> CN> ---------------------------(end of CN> broadcast)--------------------------- CN> TIP 8: explain analyze is your friend
Hello PGSQL, I'd just like to add that I ran the postmaster with -i. I also tried to do the "tcpip_socket = true" but on that the postmaster said: > FATAL: unrecognized configuration parameter "tcpip_socket" I'd think that my snapshot is too old.. But I downloaded it this morning (20 hours ago). Regards, Vitaly Belman ICQ: 1912453 AIM: VitalyB1984 MSN: tmdagent@hotmail.com Yahoo!: VitalyBe Friday, March 26, 2004, 6:08:31 PM, you wrote: VB> Hello PGSQL, CN>> Try: make install CN>> Cheers, CN>> Claudio VB> Thanks, that did the trick =) VB> Now I have a new trouble though. VB> InitDB finished fine and I starter Postmaster: >> "D:/Linux/msys/local/pgsql/bin/postmaster.exe" -i -D data >> >> LOG: database system was shut down at 2004-03-26 18:02:03 FLE Standard Time >> LOG: checkpoint record is at 0/A02AD0 >> LOG: redo record is at 0/A02AD0; undo record is at 0/0; shutdown TRUE >> LOG: next transaction ID: 455; next OID: 17207 >> LOG: database system is ready >> LOG: select() failed in statistics buffer: No error >> LOG: select() failed in statistics collector: No such file or directory >> LOG: statistics collector process (PID 4100) was terminated by signal 1 VB> It already looked bad because of these "No such file or directory". VB> However, I tried to connect to the DB using psql: >> psql >> psql: server closed the connection unexpectedly >> This probably means the server terminated abnormally >> before or while processing the request. VB> The server said on that: >> LOG: could not receive data from client: No such file or directory >> LOG: incomplete startup packet VB> Using the "createdb" executeable yielded the same result :(. VB> What file does it want now? =\ VB> Regards, VB> Vitaly Belman VB> ICQ: 1912453 VB> AIM: VitalyB1984 VB> MSN: tmdagent@hotmail.com VB> Yahoo!: VitalyBe VB> Friday, March 26, 2004, 2:36:10 PM, you wrote: >>> From MSYS I did: >>> * configure --without-zlib >>> * make CN>> Try: make install CN>> Cheers, CN>> Claudio CN>> --- CN>> Certain disclaimers and policies apply to all email sent from Memetrics. CN>> For the full text of these disclaimers and policies see CN>> <a CN>> href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em CN>> ailpolicy.html</a> CN>> ---------------------------(end of CN>> broadcast)--------------------------- CN>> TIP 8: explain analyze is your friend
Vitaly Belman <vitalib@012.net.il> writes:
>> FATAL: unrecognized configuration parameter "tcpip_socket"
> I'd think that my snapshot is too old.. But I downloaded it this
> morning (20 hours ago).
No, too new ;-). tcpip_socket is history.
regards, tom lane
Vitaly Belman wrote:
That parameter has disappeared, along with the virtual_host parameter. See the latest docs at http://developer.postgresql.org/docs/postgres/index.html
Postgres now listens on "localhost" by default. To listen on all addresses you can use -i -or -h '*' or listen_addresses = '*'
cheers
andrew
Hello PGSQL, I'd just like to add that I ran the postmaster with -i. I also tried to do the "tcpip_socket = true" but on that the postmaster said:FATAL: unrecognized configuration parameter "tcpip_socket"
That parameter has disappeared, along with the virtual_host parameter. See the latest docs at http://developer.postgresql.org/docs/postgres/index.html
Postgres now listens on "localhost" by default. To listen on all addresses you can use -i -or -h '*' or listen_addresses = '*'
cheers
andrew
I'd think that my snapshot is too old.. But I downloaded it this morning (20 hours ago). Regards,Vitaly BelmanICQ: 1912453AIM: VitalyB1984MSN: tmdagent@hotmail.comYahoo!: VitalyBe Friday, March 26, 2004, 6:08:31 PM, you wrote: VB> Hello PGSQL, CN>> Try: make install CN>> Cheers, CN>> Claudio VB> Thanks, that did the trick =) VB> Now I have a new trouble though. VB> InitDB finished fine and I starter Postmaster:"D:/Linux/msys/local/pgsql/bin/postmaster.exe" -i -D data LOG: database system was shut down at 2004-03-26 18:02:03 FLE Standard Time LOG: checkpoint record is at 0/A02AD0 LOG: redo record is at 0/A02AD0; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 455; next OID: 17207 LOG: database system is ready LOG: select() failed in statistics buffer: No error LOG: select() failed in statistics collector: No such file or directory LOG: statistics collector process (PID 4100) was terminated by signal 1VB> It already looked bad because of these "No such file or directory". VB> However, I tried to connect to the DB using psql:psql psql: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.VB> The server said on that:LOG: could not receive data from client: No such file or directory LOG: incomplete startup packetVB> Using the "createdb" executeable yielded the same result :(. VB> What file does it want now? =\ VB> Regards, VB> Vitaly Belman VB> ICQ: 1912453 VB> AIM: VitalyB1984 VB> MSN: tmdagent@hotmail.com VB> Yahoo!: VitalyBe VB> Friday, March 26, 2004, 2:36:10 PM, you wrote:From MSYS I did: * configure --without-zlib * makeCN>> Try: make install CN>> Cheers, CN>> Claudio CN>> --- CN>> Certain disclaimers and policies apply to all email sent from Memetrics. CN>> For the full text of these disclaimers and policies see CN>> <a CN>> href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em CN>> ailpolicy.html</a> CN>> ---------------------------(end of CN>> broadcast)--------------------------- CN>> TIP 8: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
Hello, Did you have McAfee Viruscan 7 installed on your computer? I had the same error one month ago, and I solve it by disable the Hostile Actvity Watch Kernel (HAWK) for mail and script in Viruscan. Now postmaster/postgres process start correctly and you can use createdb and others tools like pgAdmin III. Regards Laurent Ballester ----- Original Message ----- From: "Vitaly Belman" <vitalib@012.net.il> To: <pgsql-hackers-win32@postgresql.org> Sent: Friday, March 26, 2004 5:08 PM Subject: Re: [pgsql-hackers-win32] During InitDB: could not access file "$ > Hello PGSQL, > > CN> Try: make install > > CN> Cheers, > CN> Claudio > > Thanks, that did the trick =) > > Now I have a new trouble though. > > InitDB finished fine and I starter Postmaster: > > > "D:/Linux/msys/local/pgsql/bin/postmaster.exe" -i -D data > > > > LOG: database system was shut down at 2004-03-26 18:02:03 FLE Standard Time > > LOG: checkpoint record is at 0/A02AD0 > > LOG: redo record is at 0/A02AD0; undo record is at 0/0; shutdown TRUE > > LOG: next transaction ID: 455; next OID: 17207 > > LOG: database system is ready > > LOG: select() failed in statistics buffer: No error > > LOG: select() failed in statistics collector: No such file or directory > > LOG: statistics collector process (PID 4100) was terminated by signal 1 > > It already looked bad because of these "No such file or directory". > > However, I tried to connect to the DB using psql: > > > psql > > psql: server closed the connection unexpectedly > > This probably means the server terminated abnormally > > before or while processing the request. > > The server said on that: > > > LOG: could not receive data from client: No such file or directory > > LOG: incomplete startup packet > > Using the "createdb" executeable yielded the same result :(. > > What file does it want now? =\ > > Regards, > Vitaly Belman > > ICQ: 1912453 > AIM: VitalyB1984 > MSN: tmdagent@hotmail.com > Yahoo!: VitalyBe > > Friday, March 26, 2004, 2:36:10 PM, you wrote: > > > >> From MSYS I did: > >> * configure --without-zlib > >> * make > > CN> Try: make install > > CN> Cheers, > CN> Claudio > > CN> --- > CN> Certain disclaimers and policies apply to all email sent from Memetrics. > CN> For the full text of these disclaimers and policies see > CN> <a > CN> href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em > CN> ailpolicy.html</a> > > CN> ---------------------------(end of > CN> broadcast)--------------------------- > CN> TIP 8: explain analyze is your friend > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html
Hello Laurent, Hmm, no. I have no McAfee running. I tried disabling my anti-virus though (Avast) but that didn't help. I do have many other processes running, I am not sure which I should disable for it to work (or if it is even connected)... Regards, Vitaly Belman ICQ: 1912453 AIM: VitalyB1984 MSN: tmdagent@hotmail.com Yahoo!: VitalyBe Sunday, March 28, 2004, 12:31:43 AM, you wrote: LB> Hello, LB> Did you have McAfee Viruscan 7 installed on your computer? LB> I had the same error one month ago, and I solve it by disable the Hostile LB> Actvity Watch Kernel (HAWK) for mail and script in Viruscan. Now LB> postmaster/postgres process start correctly and you can use createdb and LB> others tools like pgAdmin III. LB> Regards LB> Laurent Ballester LB> ----- Original Message ----- LB> From: "Vitaly Belman" <vitalib@012.net.il> LB> To: <pgsql-hackers-win32@postgresql.org> LB> Sent: Friday, March 26, 2004 5:08 PM LB> Subject: Re: [pgsql-hackers-win32] During InitDB: could not access file "$ >> Hello PGSQL, >> >> CN> Try: make install >> >> CN> Cheers, >> CN> Claudio >> >> Thanks, that did the trick =) >> >> Now I have a new trouble though. >> >> InitDB finished fine and I starter Postmaster: >> >> > "D:/Linux/msys/local/pgsql/bin/postmaster.exe" -i -D data >> > >> > LOG: database system was shut down at 2004-03-26 18:02:03 FLE Standard LB> Time >> > LOG: checkpoint record is at 0/A02AD0 >> > LOG: redo record is at 0/A02AD0; undo record is at 0/0; shutdown TRUE >> > LOG: next transaction ID: 455; next OID: 17207 >> > LOG: database system is ready >> > LOG: select() failed in statistics buffer: No error >> > LOG: select() failed in statistics collector: No such file or directory >> > LOG: statistics collector process (PID 4100) was terminated by signal 1 >> >> It already looked bad because of these "No such file or directory". >> >> However, I tried to connect to the DB using psql: >> >> > psql >> > psql: server closed the connection unexpectedly >> > This probably means the server terminated abnormally >> > before or while processing the request. >> >> The server said on that: >> >> > LOG: could not receive data from client: No such file or directory >> > LOG: incomplete startup packet >> >> Using the "createdb" executeable yielded the same result :(. >> >> What file does it want now? =\ >> >> Regards, >> Vitaly Belman >> >> ICQ: 1912453 >> AIM: VitalyB1984 >> MSN: tmdagent@hotmail.com >> Yahoo!: VitalyBe >> >> Friday, March 26, 2004, 2:36:10 PM, you wrote: >> >> >> >> From MSYS I did: >> >> * configure --without-zlib >> >> * make >> >> CN> Try: make install >> >> CN> Cheers, >> CN> Claudio >> >> CN> --- >> CN> Certain disclaimers and policies apply to all email sent from LB> Memetrics. >> CN> For the full text of these disclaimers and policies see >> CN> <a >> CN> LB> href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em >> CN> ailpolicy.html</a> >> >> CN> ---------------------------(end of >> CN> broadcast)--------------------------- >> CN> TIP 8: explain analyze is your friend >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 5: Have you checked our extensive FAQ? >> >> http://www.postgresql.org/docs/faqs/FAQ.html
Vitaly, For Viruscan, disabled temporally the Anti-virus with context menu is not sufficient, postmaster and postgres has still continued to fail at start up. I made a test by desintalling the anti virus, and Postgresql started successfully. After re-installing the anti-virus, the errors appears again, so I decided to check the security options to find where the problem come from. If it can help you. regards Laurent Ballester ----- Original Message ----- From: "Vitaly Belman" <vitalib@012.net.il> To: "Laurent Ballester" <postgresql.ballester@wanadoo.fr> Cc: <pgsql-hackers-win32@postgresql.org> Sent: Saturday, March 27, 2004 11:37 PM Subject: Re: [pgsql-hackers-win32] During InitDB: could not access file "$ > Hello Laurent, > > Hmm, no. I have no McAfee running. > > I tried disabling my anti-virus though (Avast) but that didn't help. I > do have many other processes running, I am not sure which I should > disable for it to work (or if it is even connected)... > > Regards, > Vitaly Belman > > ICQ: 1912453 > AIM: VitalyB1984 > MSN: tmdagent@hotmail.com > Yahoo!: VitalyBe > > Sunday, March 28, 2004, 12:31:43 AM, you wrote: > > LB> Hello, > > LB> Did you have McAfee Viruscan 7 installed on your computer? > > LB> I had the same error one month ago, and I solve it by disable the Hostile > LB> Actvity Watch Kernel (HAWK) for mail and script in Viruscan. Now > LB> postmaster/postgres process start correctly and you can use createdb and > LB> others tools like pgAdmin III. > > > > LB> Regards > > LB> Laurent Ballester > > > LB> ----- Original Message ----- > LB> From: "Vitaly Belman" <vitalib@012.net.il> > LB> To: <pgsql-hackers-win32@postgresql.org> > LB> Sent: Friday, March 26, 2004 5:08 PM > LB> Subject: Re: [pgsql-hackers-win32] During InitDB: could not access file "$ > > > >> Hello PGSQL, > >> > >> CN> Try: make install > >> > >> CN> Cheers, > >> CN> Claudio > >> > >> Thanks, that did the trick =) > >> > >> Now I have a new trouble though. > >> > >> InitDB finished fine and I starter Postmaster: > >> > >> > "D:/Linux/msys/local/pgsql/bin/postmaster.exe" -i -D data > >> > > >> > LOG: database system was shut down at 2004-03-26 18:02:03 FLE Standard > LB> Time > >> > LOG: checkpoint record is at 0/A02AD0 > >> > LOG: redo record is at 0/A02AD0; undo record is at 0/0; shutdown TRUE > >> > LOG: next transaction ID: 455; next OID: 17207 > >> > LOG: database system is ready > >> > LOG: select() failed in statistics buffer: No error > >> > LOG: select() failed in statistics collector: No such file or directory > >> > LOG: statistics collector process (PID 4100) was terminated by signal 1 > >> > >> It already looked bad because of these "No such file or directory". > >> > >> However, I tried to connect to the DB using psql: > >> > >> > psql > >> > psql: server closed the connection unexpectedly > >> > This probably means the server terminated abnormally > >> > before or while processing the request. > >> > >> The server said on that: > >> > >> > LOG: could not receive data from client: No such file or directory > >> > LOG: incomplete startup packet > >> > >> Using the "createdb" executeable yielded the same result :(. > >> > >> What file does it want now? =\ > >> > >> Regards, > >> Vitaly Belman > >> > >> ICQ: 1912453 > >> AIM: VitalyB1984 > >> MSN: tmdagent@hotmail.com > >> Yahoo!: VitalyBe > >> > >> Friday, March 26, 2004, 2:36:10 PM, you wrote: > >> > >> > >> >> From MSYS I did: > >> >> * configure --without-zlib > >> >> * make > >> > >> CN> Try: make install > >> > >> CN> Cheers, > >> CN> Claudio > >> > >> CN> --- > >> CN> Certain disclaimers and policies apply to all email sent from > LB> Memetrics. > >> CN> For the full text of these disclaimers and policies see > >> CN> <a > >> CN> > LB> href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em > >> CN> ailpolicy.html</a> > >> > >> CN> ---------------------------(end of > >> CN> broadcast)--------------------------- > >> CN> TIP 8: explain analyze is your friend > >> > >> > >> ---------------------------(end of > >> broadcast)--------------------------- > >> TIP 5: Have you checked our extensive FAQ? > >> > >> http://www.postgresql.org/docs/faqs/FAQ.html > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
you just gave me reason number 107 not to use a virus scanner .... Laurent Ballester wrote: >Hello, > >Did you have McAfee Viruscan 7 installed on your computer? > >I had the same error one month ago, and I solve it by disable the Hostile >Actvity Watch Kernel (HAWK) for mail and script in Viruscan. Now >postmaster/postgres process start correctly and you can use createdb and >others tools like pgAdmin III. > > >