Thread: Re: During InitDB: could not access file "$

Re: During InitDB: could not access file "$

From

Claudio Natoli

Date:

26 March 2004, 18:36:10

>   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>

Re: During InitDB: could not access file "$

From

Vitaly Belman

Date:

26 March 2004, 22:08:31

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

Re: During InitDB: could not access file "$

From

Vitaly Belman

Date:

27 March 2004, 00:57:13

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

Re: During InitDB: could not access file "$

From

Tom Lane

Date:

27 March 2004, 04:22:37

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

Re: During InitDB: could not access file "$

From

Andrew Dunstan

Date:

27 March 2004, 04:24:39

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 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 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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: During InitDB: could not access file "$

From

"Laurent Ballester"

Date:

28 March 2004, 04:31:43

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

Re: During InitDB: could not access file "$

From

Vitaly Belman

Date:

28 March 2004, 04:37:18

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

Re: During InitDB: could not access file "$

From

"Laurent Ballester"

Date:

28 March 2004, 06:15:13

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)

Re: During InitDB: could not access file "$

From

Andrew Dunstan

Date:

28 March 2004, 09:34:32

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.
>
>
>