From owner-freebsd-questions@FreeBSD.ORG Thu Aug 14 12:42:02 2008 Return-Path: Delivered-To: questions@FreeBSD.ORG Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 867B2106564A for ; Thu, 14 Aug 2008 12:42:02 +0000 (UTC) (envelope-from jotawski@gmail.com) Received: from ti-out-0910.google.com (ti-out-0910.google.com [209.85.142.188]) by mx1.freebsd.org (Postfix) with ESMTP id F0D808FC08 for ; Thu, 14 Aug 2008 12:42:01 +0000 (UTC) (envelope-from jotawski@gmail.com) Received: by ti-out-0910.google.com with SMTP id d27so221483tid.3 for ; Thu, 14 Aug 2008 05:42:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type:references; bh=hXOSZfJcSid2Uupc99kQQhfdm4nXt0GTiwlMdN9AECY=; b=rT3CZLhrI7adlEUgizyE/dzYddZwg8l2QLkFQcAwSbyvrGinbtLiuxiZhYD0sNHIto nPyLGSeZCyLraN8x4pSTQ4Xddoz4s0eKpBmkWeC1VDk4CSqjRLhuID4P/VsBpthWsmk5 uG1/tETDnWtVQrxlfxoinvRsaYu5IE7mXsH0k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:references; b=jKKqZBeC9WvJtSrKVGzuV88Zw6zgMJ7YmlhWb4Jpv4AVRt5kgHTCdBkxC6m23rLeEu 9bu1IiPIKUp34gO4mlvWHEpRudnGlp/G8KkP8vUuP0kKiofGT8ZjieM1NuKJyGulFSf3 8YXymZW9UCI/MjewVG9+8u0IrqHPEUFwmD8nA= Received: by 10.110.53.14 with SMTP id b14mr1087125tia.8.1218717720528; Thu, 14 Aug 2008 05:42:00 -0700 (PDT) Received: by 10.110.60.15 with HTTP; Thu, 14 Aug 2008 05:42:00 -0700 (PDT) Message-ID: Date: Thu, 14 Aug 2008 19:42:00 +0700 From: "fire jotawski" To: "Mehul Ved" In-Reply-To: MIME-Version: 1.0 References: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: questions@FreeBSD.ORG Subject: Re: postgres: [2-1] FATAL: the database is starting up X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 14 Aug 2008 12:42:02 -0000 On Thu, Aug 14, 2008 at 10:49 AM, Mehul Ved wrote: > On 8/14/08, fire jotawski wrote: > > every time i boot the machine i always get the message that says > > > > postgres[pid]: [2-1] FATAL: the database system is starting > > Have you checked /var/log/messages or /var/log/postgresql > I am not sure as to where does postgresql log but you can look around > in /var/log directory and go through the file for errors or warning. thanks so much for your time. i read /var/log/postgresql.log and did as suggested from hint in a log file but still got error message when reboot. here is /var/log/postgresql.log content [~] # cat /var/log/postgres.log Aug 14 16:09:53 makham postgres[1221]: [1-1] WARNING: autovacuum not started because of misconfiguration Aug 14 16:09:53 makham postgres[1221]: [1-2] HINT: Enable options "stats_start_collector" and "stats_row_level". Aug 14 16:09:53 makham postgres[1223]: [3-1] FATAL: the database system is starting up Aug 14 16:39:00 makham postgres[1223]: [2-1] FATAL: the database system is starting up Aug 14 16:45:32 makham postgres[1223]: [2-1] FATAL: the database system is starting up Aug 14 16:58:45 makham postgres[1223]: [2-1] FATAL: the database system is starting up Aug 14 18:27:33 makham postgres[1198]: [2-1] FATAL: the database system is starting up [~] # best regards, psr