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(at)hotmail(dot)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(at)hotmail(dot)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(at)hotmail(dot)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(at)012(dot)net(dot)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:

>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 Belman
>
> ICQ: 1912453
> AIM: VitalyB1984
> MSN: tmdagent(at)hotmail(dot)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(at)hotmail(dot)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
>
>
>---------------------------(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(at)012(dot)net(dot)il>
To: <pgsql-hackers-win32(at)postgresql(dot)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(at)hotmail(dot)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(at)hotmail(dot)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(at)012(dot)net(dot)il>
LB> To: <pgsql-hackers-win32(at)postgresql(dot)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(at)hotmail(dot)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(at)012(dot)net(dot)il>
To: "Laurent Ballester" <postgresql(dot)ballester(at)wanadoo(dot)fr>
Cc: <pgsql-hackers-win32(at)postgresql(dot)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(at)hotmail(dot)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(at)012(dot)net(dot)il>
> LB> To: <pgsql-hackers-win32(at)postgresql(dot)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(at)hotmail(dot)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(at)postgresql(dot)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.
>
>
>