From sandhyar@amiindia.co.in Thu May 11 10:41:14 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 824FA9FA176 for ; Thu, 11 May 2006 07:41:14 -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 96984-06 for ; Thu, 11 May 2006 07:41:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id E306C9F9430 for ; Thu, 11 May 2006 07:41:08 -0300 (ADT) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k4BAYVH2020382 for ; Thu, 11 May 2006 16:04:31 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 39BCB33266Cfor ; Thu, 11 May 2006 16:04:31 +0530 (IST) Message-ID: <011f01c674e8$8b92db90$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Subject: Fw: reg:logon failure Date: Thu, 11 May 2006 16:19:14 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_011C_01C67516.A51B5500" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:79.29285 C:21 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/139 X-Sequence-Number: 21671 This is a multi-part message in MIME format. ------=_NextPart_000_011C_01C67516.A51B5500 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Already i have postgres server running on my windows system.Suddenly = when i open it didn't open and when i run and see in the services...I am = getting the following.Can any one please explain me why this problem is = coming?Will i lost all my data in it.I am not getting any problem with = my Linux server.But in Windows i am facing this problem. Thank you, Regards Sandhya ------=_NextPart_000_011C_01C67516.A51B5500 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
Already i have postgres server running on my windows = system.Suddenly when i open it didn't open and when i run and see in the = services...I am getting the following.Can any one please explain me why = this=20 problem is coming?Will i lost all my data in it.I am not getting any = problem=20 with my Linux server.But in Windows i am facing this = problem.
 
Thank you,
Regards
Sandhya
------=_NextPart_000_011C_01C67516.A51B5500-- From David.Bonilla@isotrol.com Thu May 11 11:59:48 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7DA959FA42B for ; Thu, 11 May 2006 08:59:48 -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 03385-04 for ; Thu, 11 May 2006 08:59:43 -0300 (ADT) X-Greylist: delayed 00:26:19.23475 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id D54789FA2F8 for ; Thu, 11 May 2006 08:59:43 -0300 (ADT) Received: from isotrol.com (smtp.isotrol.com [83.175.206.228]) by svr4.postgresql.org (Postfix) with ESMTP id CE7D45B0672 for ; Thu, 11 May 2006 11:33:22 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by isotrol.com (Postfix) with ESMTP id 7D4436C34C; Thu, 11 May 2006 13:33:08 +0200 (CEST) Received: from isotrol.com ([127.0.0.1]) by localhost (srv007.red.isotrol.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 25233-01-38; Thu, 11 May 2006 13:33:07 +0200 (CEST) Received: from [192.168.102.210] (portatil-pablo.red.isotrol.com [192.168.102.210]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by isotrol.com (Postfix) with ESMTP id 904936C349; Thu, 11 May 2006 13:33:07 +0200 (CEST) Message-ID: <446320FE.7060504@isotrol.com> Date: Thu, 11 May 2006 13:33:18 +0200 From: David Bonilla User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Fw: reg:logon failure References: <011f01c674e8$8b92db90$cd00000a@sandhyar> In-Reply-To: <011f01c674e8$8b92db90$cd00000a@sandhyar> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at isotrol.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/250 X-Sequence-Number: 21782 sandhya escribió: > Hi, > Already i have postgres server running on my windows system.Suddenly > when i open it didn't open and when i run and see in the services...I am > getting the following. I have this problem in a W2000 system. The solution is write again de password to user postgres in windows, or the user that run the service. I don't know why happen that, but in my experience this must solve your problem. From sandhyar@amiindia.co.in Mon May 15 08:14:57 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 2A9B29F944D for ; Mon, 15 May 2006 05:14:57 -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 41576-06 for ; Mon, 15 May 2006 05:14:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 1B7E59F9430 for ; Mon, 15 May 2006 05:14:42 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with SMTP id k4F86P81024230; Mon, 15 May 2006 13:37:16 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 604A03326B9; Mon, 15 May 2006 12:30:32 +0530 (IST) Message-ID: <012e01c677ef$57e56ba0$cd00000a@sandhyar> From: "sandhya" To: "David Bonilla" Cc: "Postgres" References: <011f01c674e8$8b92db90$cd00000a@sandhyar> <446320FE.7060504@isotrol.com> Subject: Re: Fw: reg:logon failure Date: Mon, 15 May 2006 12:44:48 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:21 M:2 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/174 X-Sequence-Number: 21706 The solution is write again de password to user postgres in windows, or the user that run the service. I don't know why happen that, but in my experience this must solve your problem. Where i should mention the password. Is it in Users of Controlpanel i need to change my password.Bcoz mine is also win2000 only. Why it is happening in Win2000,Anybody can pls explain me? ----- Original Message ----- From: "David Bonilla" To: Sent: Thursday, May 11, 2006 5:03 PM Subject: Re: [ADMIN] Fw: reg:logon failure > sandhya escribió: > > Hi, > > Already i have postgres server running on my windows system.Suddenly > > when i open it didn't open and when i run and see in the services...I am > > getting the following. > > I have this problem in a W2000 system. The solution is write again de > password to user postgres in windows, or the user that run the service. > I don't know why happen that, but in my experience this must solve your > problem. > From andy.shellam@mailnetwork.co.uk Mon May 15 08:20:17 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id EB51F9F944D for ; Mon, 15 May 2006 05:20:17 -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 42037-09 for ; Mon, 15 May 2006 05:20:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id 8B4669F9430 for ; Mon, 15 May 2006 05:20:12 -0300 (ADT) Received: from [213.146.143.243] (port=59513 helo=it020361) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FfYJD-0000rG-54; Mon, 15 May 2006 09:20:07 +0100 Reply-To: From: "Andy Shellam" To: "'sandhya'" Cc: Subject: Re: Fw: reg:logon failure Date: Mon, 15 May 2006 09:20:33 +0100 Organization: the mail network Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <012e01c677ef$57e56ba0$cd00000a@sandhyar> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 Thread-Index: AcZ399MpY49TdZWGQdGEHaL/6PENhwAAFtXg X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/175 X-Sequence-Number: 21707 By default in Windows 2000, passwords are set to expire after 42 days = (in my experience.) So after 42 days, Windows will stop the user from being able to authenticate, so the service cannot logon. When you reset the password, the 42-day expiry counter begins again. If you run the Local Users & Groups MMC (lusrmgr.msc) and open up the = user account for your postgres service - you can set "Password never expires" = to get around this for this user only. Andy > -----Original Message----- > From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin- > owner@postgresql.org] On Behalf Of sandhya > Sent: 15 May 2006 8:15 am > To: David Bonilla > Cc: Postgres > Subject: Re: [ADMIN] Fw: reg:logon failure >=20 > The solution is write again de password to user postgres in windows, = or > the > user that run the service. > I don't know why happen that, but in my experience this must solve = your > problem. >=20 > Where i should mention the password. > Is it in Users of Controlpanel i need to change my password.Bcoz mine = is > also win2000 only. > Why it is happening in Win2000,Anybody can pls explain me? >=20 >=20 >=20 >=20 >=20 >=20 > ----- Original Message ----- > From: "David Bonilla" > To: > Sent: Thursday, May 11, 2006 5:03 PM > Subject: Re: [ADMIN] Fw: reg:logon failure >=20 >=20 > > sandhya escribi=F3: > > > Hi, > > > Already i have postgres server running on my windows = system.Suddenly > > > when i open it didn't open and when i run and see in the = services...I > am > > > getting the following. > > > > I have this problem in a W2000 system. The solution is write again = de > > password to user postgres in windows, or the user that run the = service. > > I don't know why happen that, but in my experience this must solve = your > > problem. > > >=20 >=20 >=20 >=20 > ---------------------------(end of = broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >=20 > !DSPAM:14,446838cb34494500111402! >=20