Re: postgres: [2-1] FATAL: the database is starting up
On Thu, Aug 14, 2008 at 10:49 AM, Mehul Ved [EMAIL PROTECTED] wrote: On 8/14/08, fire jotawski [EMAIL PROTECTED] 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 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: postgres: [2-1] FATAL: the database is starting up
On 8/14/08, fire jotawski [EMAIL PROTECTED] wrote: 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. You can try enabling those 2 parameters. Maybe something can be found http://www.postgresql.org/docs/8.1/static/runtime-config.html ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: postgres: [2-1] FATAL: the database is starting up
On Thu, Aug 14, 2008 at 09:59:57AM +0700, fire jotawski wrote: hi sirs, apologize me for disturbing the list but i faced the strange problem that i can not understand every times i boot my machine. every time i boot the machine i always get the message that says postgres[pid]: [2-1] FATAL: the database system is starting later on after logged in as root, i check for process, i found the postgresql has been started . so what the reason for the message at during start up then. IIRC, PostgreSQL always starts with this FATAL message. It still works flawlessly nonetheless. If there are no other FATAL messages, this one may not be a reason for concern. You may want to read this as well: http://archives.postgresql.org/pgsql-general/2007-12/msg01339.php Regards, -cpghost. -- Cordula's Web. http://www.cordula.ws/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: postgres: [2-1] FATAL: the database is starting up
On Thu, Aug 14, 2008 at 8:21 PM, cpghost [EMAIL PROTECTED] wrote: On Thu, Aug 14, 2008 at 09:59:57AM +0700, fire jotawski wrote: hi sirs, apologize me for disturbing the list but i faced the strange problem that i can not understand every times i boot my machine. every time i boot the machine i always get the message that says postgres[pid]: [2-1] FATAL: the database system is starting later on after logged in as root, i check for process, i found the postgresql has been started . so what the reason for the message at during start up then. IIRC, PostgreSQL always starts with this FATAL message. It still works flawlessly nonetheless. If there are no other FATAL messages, this one may not be a reason for concern. yes, it was just that but some time it did not happen some time it did. You may want to read this as well: http://archives.postgresql.org/pgsql-general/2007-12/msg01339.php thanks indeed for this informations. i do not use -w flag and there is no error now. thanks to all of you and thanks to the list too. Regards, -cpghost. with best regards, psr -- Cordula's Web. http://www.cordula.ws/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
postgres: [2-1] FATAL: the database is starting up
hi sirs, apologize me for disturbing the list but i faced the strange problem that i can not understand every times i boot my machine. my machine is [~] # uname -a FreeBSD makham.serveblog.net 7.0-RELEASE FreeBSD 7.0-RELEASE #4: Wed Jul 2 03:43:34 ICT 2008 root@:/usr/obj/usr/src/sys/SITING i386 [~] # and i installed postgres via ports [~] # pkg_info -Ix postgre postgresql-client-8.2.7 PostgreSQL database (client) postgresql-server-8.2.7 The most advanced open-source database available anywhere [ ~] # every time i boot the machine i always get the message that says postgres[pid]: [2-1] FATAL: the database system is starting later on after logged in as root, i check for process, i found the postgresql has been started . so what the reason for the message at during start up then. best regards, psr ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]