Re: Install new language - Prev: Re: Are you frustrated with PostgreSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Terence Chang" <TChang(at)nqueue(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Install new language - Prev: Re: Are you frustrated with PostgreSQL
Date: 2003-07-16 22:01:57
Message-ID: 25405.1058392917@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Terence Chang" <TChang(at)nqueue(dot)com> writes:
> 5. I start PostgreSQL with the comman "pg_ctl start -D /var/pgsql/data" I
> got the following message: It says the database was not shut down properly?
> What I did wrong? I shut down the database with this command "pg_ctl stop -D
> /var/pgsql/data -m immediate" when no connection exist.

"-m immediate" is the panic button; yes you will get that complaint
when you restart. My advice: never use "-m immediate". If you have a
situation where you think you need it (like you smell smoke coming
from the machine), you probably should be yanking the power cord out
of the wall instead.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-07-16 22:07:22 Re: Billions of records?
Previous Message Tom Lane 2003-07-16 21:45:46 Re: changing an update via rules - caught in recursion