Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 14 Aug 2008 19:42:00 +0700
From:      "fire jotawski" <jotawski@gmail.com>
To:        "Mehul Ved" <mehul.n.ved@gmail.com>
Cc:        questions@FreeBSD.ORG
Subject:   Re: postgres: [2-1] FATAL: the database is starting up
Message-ID:  <c583719d0808140542s6874345awd3b920e4c23c1910@mail.gmail.com>
In-Reply-To: <c1e7523f0808132049s17683e6cw1956f12fdf3ac85a@mail.gmail.com>
References:  <c583719d0808131959p1d3a18b8ged0054aaca6196b0@mail.gmail.com> <c1e7523f0808132049s17683e6cw1956f12fdf3ac85a@mail.gmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help
On Thu, Aug 14, 2008 at 10:49 AM, Mehul Ved <mehul.n.ved@gmail.com> wrote:

> On 8/14/08, fire jotawski <jotawski@gmail.com> 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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?c583719d0808140542s6874345awd3b920e4c23c1910>