Skip site navigation (1) Skip section navigation (2)

Re: During InitDB: could not access file "$

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Vitaly Belman <vitalib(at)012(dot)net(dot)il>
Cc: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: During InitDB: could not access file "$
Date: 2004-03-26 22:24:39
Message-ID: 4064ADA7.2070701@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
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
>
>  
>

In response to

pgsql-hackers-win32 by date

Next:From: weiping heDate: 2004-03-27 15:14:40
Subject: win32 compile error open.c: O_SEQUENTIAL not defined
Previous:From: Tom LaneDate: 2004-03-26 22:22:37
Subject: Re: During InitDB: could not access file "$

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group