postgres: [2-1] FATAL: the database is starting up

fire jotawski jotawski at gmail.com
Thu Aug 14 12:42:02 UTC 2008


On Thu, Aug 14, 2008 at 10:49 AM, Mehul Ved <mehul.n.ved at gmail.com> wrote:

> On 8/14/08, fire jotawski <jotawski at 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


More information about the freebsd-questions mailing list