Forum OpenACS Q&A: Re: Warning, Debian postgresql package default date input format breaks things

dpkg-reconfigure postgresql

There are a few options in there -- the third or fourth deals with dates.

Otherwise, next time you upgrade and it overwrites your postgresql config, you'll be changing it again.