dbTalk Databases Forums  

[BUGS] PgSQL Down

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] PgSQL Down in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Cavit Keskin
 
Posts: n/a

Default [BUGS] PgSQL Down - 01-27-2004 , 06:01 AM







Using Postgresql's source files I compiled postgresql 7.4.1 on a
dedicated machine with a customized Redhat 7.2 system.
Postgresql often stops after a time (unknown, changing).
Below is the log file just after Postgresql database server is started
manually. Log can't record the cause of this problem.

_____________________
LOG: could not create IPv6 socket: Address family not supported by
protocol
LOG: database system was interrupted at 2004-01-27 03:18:09 CST
LOG: checkpoint record is at 0/4470A6C
LOG: redo record is at 0/4470A6C; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID: 1275; next OID: 234555
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: record with zero length at 0/4470AAC
LOG: redo is not required
LOG: database system is ready
______________________________________


Please note that I don't experience such a problem on a Slackware 9.0
system.


Cavit Keskin
cavit (AT) binbir (DOT) net



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] PgSQL Down - 01-27-2004 , 11:00 AM






"Cavit Keskin" <cavit (AT) binbir (DOT) net> writes:
Quote:
Postgresql often stops after a time (unknown, changing).
You haven't given any information that would allow anyone to help :-(

Quote:
Below is the log file just after Postgresql database server is started
manually. Log can't record the cause of this problem.
We need to see the log entries from before the crash, not after.

regards, tom lane

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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.