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]"
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 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 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 Startup Error Message
On Mon, 26 Mar 2007 07:02:27 -0500 "Rick Apichairuk" <[EMAIL PROTECTED]> wrote: > > I occasionally receive this error message when booting up: > > > > Mar 25 08:28:24 scorpio postgres[756]: [1-1] FATAL: the database > > system is starting up > > > > Since it is an intermittent error message, I am unable to track > > down what is causing it or how to fix it. > > > > Any suggestions? > > I had a similar problem before with an older version of PostgreSQL. > The problem was that the rc script was waiting for input from the > user. It was waiting for a password. Depending on how you set up your > PostgreSQL, it might ask for a password on startup. > > It might help to post the versions of PostgreSQL and FreeBSD you are > using. I checked on the postgresql forum and received a reply. It appears that a program is attempting to query postgresql before it is started. I think it was dovecot. In any case, I reconfigured the rc.d file for postgresql to start sooner in the boot process. That eliminated the problem, or at least it appears to have done so. -- Gerard Forgetfulness, n: A gift of God bestowed upon debtors in compensation for their destitution of conscience. signature.asc Description: PGP signature
RE: Postgres Startup Error Message
> -Original Message- > From: [EMAIL PROTECTED] [mailto:owner-freebsd- > [EMAIL PROTECTED] On Behalf Of Gerard > Sent: Sunday, March 25, 2007 7:36 AM > To: FreeBSD Questions > Subject: Postgres Startup Error Message > > I occasionally receive this error message when booting up: > > Mar 25 08:28:24 scorpio postgres[756]: [1-1] FATAL: the database system > is starting up > > Since it is an intermittent error message, I am unable to track down what > is causing it or how to fix it. > > Any suggestions? I had a similar problem before with an older version of PostgreSQL. The problem was that the rc script was waiting for input from the user. It was waiting for a password. Depending on how you set up your PostgreSQL, it might ask for a password on startup. It might help to post the versions of PostgreSQL and FreeBSD you are using. > -- > > ___ >oo // \\ || Gerard > (_,\/ \_/ \ || [EMAIL PROTECTED] > \ \_/_\_/>|| > /_/ \_\ || "If today is the first day of the rest of >___|| your life, then what was yesterday?" > ___ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" Best Regards, Rick Apichairuk ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Postgres Startup Error Message
Gerard wrote: > I occasionally receive this error message when booting up: > > Mar 25 08:28:24 scorpio postgres[756]: [1-1] FATAL: the database system > is starting up > > Since it is an intermittent error message, I am unable to track down > what is causing it or how to fix it. I've "always" seen it on my machines and assume that it's normal. In any case, you'll have more luck asking it on a PostgreSQL mailing list. signature.asc Description: OpenPGP digital signature
Re: postgres
On Wed, Apr 26, 2006 at 09:14:53PM +0100, eoghan wrote: > Thanks guys: > > Required by: > kde-3.5.1 > koffice-1.4.2_3,1 > php5-extensions-1.0 > php5-pgsql-5.1.2_1 > postgresql-libpqxx-2.5.5 > > I wanted to use it with php5, so i guess forcing an uninstall would bork > my php5 support? My suggestion for you would be to do a `pkg_delete -f' on your postgresql-client, and then install the newer version. After that succeeds, rebuild the port-dependencies listed above. Cheers. -- Jonathan Chen <[EMAIL PROTECTED]> -- Experience is a hard teacher because she gives the test first, the lesson afterwards ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: postgres
Greg Barniskis wrote: eoghan wrote: Hi I am installing postgres81-server from ports, but it gives me an error. It requires postgres81-client but I have postgres74-client installed. I have not installed this port, so is there something that uses this? I cannot find any pgsql script. Would it be safe to remove 74-client and install the latest version? Short answer: probably safe, yes. Longer answer: Have a poke at # pkg_info -R postgres74-client (or however that client package is actually named) This will tell you what other port(s) you have installed that presumably need/want you to have the 7.4 client installed, and thus what might be broken by your forcing an upgrade of it. Then you can decide if it's worth the risk, what to test after, what contingency plans and backups to make, etc. Thanks guys: Required by: kde-3.5.1 koffice-1.4.2_3,1 php5-extensions-1.0 php5-pgsql-5.1.2_1 postgresql-libpqxx-2.5.5 I wanted to use it with php5, so i guess forcing an uninstall would bork my php5 support? Since the server port installs the pgsql script (i assume???) i should probably just go with the older version? Thanks again Eoghan ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: postgres
eoghan wrote: Hi I am installing postgres81-server from ports, but it gives me an error. It requires postgres81-client but I have postgres74-client installed. I have not installed this port, so is there something that uses this? I cannot find any pgsql script. Would it be safe to remove 74-client and install the latest version? Short answer: probably safe, yes. Longer answer: Have a poke at # pkg_info -R postgres74-client (or however that client package is actually named) This will tell you what other port(s) you have installed that presumably need/want you to have the 7.4 client installed, and thus what might be broken by your forcing an upgrade of it. Then you can decide if it's worth the risk, what to test after, what contingency plans and backups to make, etc. -- Greg Barniskis, Computer Systems Integrator South Central Library System (SCLS) Library Interchange Network (LINK) , (608) 266-6348 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: postgres
eoghan wrote: > Hi > I am installing postgres81-server from ports, but it gives me an error. > It requires postgres81-client but I have postgres74-client installed. > I have not installed this port, so is there something that uses this? > I cannot find any pgsql script. Would it be safe to remove 74-client and > install the latest version? > Thanks > Eoghan > ___ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "[EMAIL PROTECTED]" Do a pkg_info on the installed postgres74-client. This should list what package is was pulled in as a dependency for. If that program is actually USING the postgres support (rather than having been built with support for it that you weren't using), you would have to carefully migrate your data. Otherwise, you will probably want to rebuild said package without the postgres support, then remove the postgresql74-client and install the postgres81 client and server. -- Nathanael Hoyle Systems and Networking Speed Express Networks, LLC [EMAIL PROTECTED] 432.837.2811 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: postgres 8 init script problem?
* Dick Davies <[EMAIL PROTECTED]> [0237 21:37]: > Anyone else having problems starting postgres 8.0.1 (from ports) > on RELENG_5? > > It seems to start alright, but clankily: > > root$ /usr/local/etc/rc.d/010.pgsql.sh start > > could not start postmaster > root$ /usr/local/etc/rc.d/010.pgsql.sh status > pg_ctl: postmaster is running (PID: 54846) > /usr/local/bin/postgres -D /usr/local/pgsql/data Ah, found it. I had PGHOST set in roots environment (after 'su'ing rather than 'su -'ing). unset PG_HOST gets it running in no time. (Looks like a bug in 010.pgsql.sh, though. roots environment shouldn't get picked up, surely?) -- 'A little rudeness and disrespect can elevate a meaningless interaction into a battle of wills and add drama to an otherwise dull day.' -- Calvin discovers Usenet Rasputin :: Jack of All Trades - Master of Nuns ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Postgres
On Wednesday 13 October 2004 04:20 pm, Randy Grafton wrote: > Dick Davies wrote: > >* Norman Uittenbogaart <[EMAIL PROTECTED]> [1010 16:10]: > >>I'm trying to write a backup script for postgres and us a crontab > >> on it. In the manual it says for pg_dumpall make $HOME/.pgpass so > >> it won't ask for a password. > >>Now I made the .pgpass in root's homedir (i wanted to use root's > >>crontab) paste the password in it, chmod 400 it ... > > > >Can't you just pgdump from the local socket? And not bother with the > > password thing at all? > > I chose to go with the pg_dump solution command from root's crontab. > Cron runs a script once a night with the following commands: > DATE=`/bin/date +%Y%m%d` > /usr/local/bin/vacuumdb -a -F -v -U pgsql > > /var/backups/"$DATE"_pg.vac /usr/local/bin/pg_dump -Fc -U pgsql > db_name > /var/backups/"$DATE"_db.bu > > -Randy Why not run use pgsql's crontab? Best of luck, Andrew Gould ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Postgres
Dick Davies wrote: * Norman Uittenbogaart <[EMAIL PROTECTED]> [1010 16:10]: I'm trying to write a backup script for postgres and us a crontab on it. In the manual it says for pg_dumpall make $HOME/.pgpass so it won't ask for a password. Now I made the .pgpass in root's homedir (i wanted to use root's crontab) paste the password in it, chmod 400 it ... Can't you just pgdump from the local socket? And not bother with the password thing at all? I chose to go with the pg_dump solution command from root's crontab. Cron runs a script once a night with the following commands: DATE=`/bin/date +%Y%m%d` /usr/local/bin/vacuumdb -a -F -v -U pgsql > /var/backups/"$DATE"_pg.vac /usr/local/bin/pg_dump -Fc -U pgsql db_name > /var/backups/"$DATE"_db.bu -Randy ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Postgres
* Norman Uittenbogaart <[EMAIL PROTECTED]> [1010 16:10]: > I'm trying to write a backup script for postgres and us a crontab on it. > In the manual it says for pg_dumpall make $HOME/.pgpass so it won't ask > for a password. > Now I made the .pgpass in root's homedir (i wanted to use root's > crontab) paste the password in it, chmod 400 it ... Can't you just pgdump from the local socket? And not bother with the password thing at all? -- I never meant to hurt you. Just destroy everything you ever believed in. - Bender Rasputin :: Jack of All Trades - Master of Nuns ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"