Re: [GENERAL] DB terminating

2009-12-03 Thread Scott Felt
Sorry. Don't think I got that uploaded on the last message. Scott Felt wrote: > > Thanks, Tom. I will alter the config file to give greater details as you > suggest. Perhaps that will be sufficiently informative to point me toward > a fix. Thank you. > > --Scott > > > Tom Lane-2 wrote:

Re: [GENERAL] DB terminating

2009-12-03 Thread Scott Felt
Thanks. I altered the log log_statements and added the PID to the log_line_prefix. I have uploaded the log. Forgive me if I'm missing something obvious here, but I do not see that PID referenced elsewhere. Is there a a "crash report" somewhere or is that just these logs? Thank you. Scott T

Re: [GENERAL] DB terminating [on Windows]

2009-11-19 Thread Magnus Hagander
Looks like your typical backend crash of PID 9644, causing a typical restart. So something broke the backend - I'd start by trying to figure that out. Clearly, it's failing to restart after the crash, due to shared memory issues. At the risk of repeating, this often happens with antivirus on the

Re: [GENERAL] DB terminating

2009-11-18 Thread Craig Ringer
On 19/11/2009 1:23 AM, Scott Felt wrote: > > Hello. I have been having an issue with a database. The logs consistently > show this: [snip] > Prior to this, the logs show nothing other than AutoVacWorkerMain > activities. This database is installed on a Windows OS. The version of > PostgreSQL

Re: [GENERAL] DB terminating

2009-11-18 Thread Scott Felt
Thanks, Tom. I will alter the config file to give greater details as you suggest. Perhaps that will be sufficiently informative to point me toward a fix. Thank you. --Scott Tom Lane-2 wrote: > > Scott Felt writes: >> Hello. I have been having an issue with a database. The logs >> consist

Re: [GENERAL] DB terminating

2009-11-18 Thread Tom Lane
Scott Felt writes: > Hello. I have been having an issue with a database. The logs consistently > show this: > 2009-11-17 16:03:55 ESTLOG: 0: server process (PID 9644) exited with > exit code 128 This looks like a fairly garden-variety backend crash, but with only this much information t

Re: [GENERAL] DB terminating [on Windows]

2009-11-18 Thread Richard Broersma
Magnus, any thoughts? On Wed, Nov 18, 2009 at 9:53 AM, Scott Felt wrote: > > Hello.  I have been having an issue with a database.  The logs consistently > show this: > > 2009-11-17 16:03:55 ESTLOG:  0: server process (PID 9644) exited with > exit code 128 > 2009-11-17 16:03:55 ESTLOCATION: