X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 257499FA2F7 for ; Mon, 26 Jun 2006 21:20:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 49441-07 for ; Mon, 26 Jun 2006 21:20:42 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by postgresql.org (Postfix) with ESMTP id 2377B9FAC76 for ; Mon, 26 Jun 2006 21:20:41 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so2323372ugf for ; Mon, 26 Jun 2006 17:20:40 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=C+3tnXbKILCTEwfnKhEVJpkALRkP1n0NfgeY64LRr1e38BjyqTlqYzCXOFSOwsQndCFS/wFa/D30v2j1hliceMngNHnfZUZDgiDdU5gT/MOoavp5q9CG9Gn1K+oXwglmkz5cqWpGAh+vKuzBpINXCQ6Jnz9biv1kimBzoOC6Nh8= Received: by 10.78.97.7 with SMTP id u7mr2322115hub; Mon, 26 Jun 2006 17:20:40 -0700 (PDT) Received: by 10.78.29.2 with HTTP; Mon, 26 Jun 2006 17:20:40 -0700 (PDT) Message-ID: Date: Mon, 26 Jun 2006 19:20:40 -0500 From: "Aaron Bono" To: "Scott Marlowe" Subject: Re: Problem Setting DateStyle Cc: Andy , "Tom Lane" , pgsql-admin@postgresql.org In-Reply-To: <1151338262.4215.51.camel@state.g2switchworks.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10681_30926202.1151367640185" References: <014601c69928$3dd35740$0b00a8c0@mpsro.dom> <29135.1151333441@sss.pgh.pa.us> <003801c69933$58bad960$0b00a8c0@mpsro.dom> <1151338262.4215.51.camel@state.g2switchworks.com> X-Google-Sender-Auth: a085abff50a0369d X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/249 X-Sequence-Number: 22211 ------=_Part_10681_30926202.1151367640185 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Also, and I know this sounds stupid, you may check to see if the database really restarted. I recently got a new server and for some reason when I use the restart script found in /etc/init.d/postgres it doesn't actually restart the server (the shutdown fails) but when I go to the control panel installed by my ISP it restarts wonderfully. I saw what was happening when I looked at the date the postgres process started. -Aaron On 6/26/06, Scott Marlowe wrote: > > On Mon, 2006-06-26 at 10:15, Andy wrote: > > Steps: > > 1. > > show datestyle > > DateStyle > > ISO, DMY > > > > > > 2. > > set datestyle to 'SQL, DMY'; > > show datestyle; > > DateStyle > > SQL, DMY > > > > >>>>>>>>>> this should be the good result. > > > > Now the tries: > > Edit the postgresql.conf. Set datestyle = 'SQL, DMY' parameter. Restart > the > > DB server. > > show datestyle > > DateStyle > > ISO, DMY > > > > ... there is no change. > > > > the other try: > > alter database test2 set datestyle to 'SQL, DMY'; > > SQL executed. > > show datestyle > > DateStyle > > ISO, DMY > > > > > > the same... > > > Have you set a date style for this particular database (not the cluster) > with an alter database statement before? > > I'd try to alter the database to have a certain datestyle and see if > that helps. > > ------=_Part_10681_30926202.1151367640185 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Also, and I know this sounds stupid, you may check to see if the database really restarted.  I recently got a new server and for some reason when I use the restart script found in /etc/init.d/postgres it doesn't actually restart the server (the shutdown fails) but when I go to the control panel installed by my ISP it restarts wonderfully.  I saw what was happening when I looked at the date the postgres process started.

-Aaron

On 6/26/06, Scott Marlowe <smarlowe@g2switchworks.com> wrote:
On Mon, 2006-06-26 at 10:15, Andy wrote:
> Steps:
> 1.
> show datestyle
>       DateStyle
>       ISO, DMY
>
>
> 2.
> set datestyle to 'SQL, DMY';
> show datestyle;
>       DateStyle
>       SQL, DMY
>
> >>>>>>>>>> this should be the good result.
>
> Now the tries:
> Edit the postgresql.conf. Set datestyle = 'SQL, DMY' parameter. Restart the
> DB server.
> show datestyle
>       DateStyle
>       ISO, DMY
>
> ... there is no change.
>
> the other try:
> alter database test2 set datestyle to 'SQL, DMY';
> SQL executed.
> show datestyle
>       DateStyle
>       ISO, DMY
>
>
> the same...


Have you set a date style for this particular database (not the cluster)
with an alter database statement before?

I'd try to alter the database to have a certain datestyle and see if
that helps.

------=_Part_10681_30926202.1151367640185--