X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E61CE11F633C for ; Wed, 29 Mar 2006 21:36:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 90711-09 for ; Wed, 29 Mar 2006 21:36:06 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.travelamericas.com (unknown [206.130.134.147]) by postgresql.org (Postfix) with SMTP id 6259511F6299 for ; Wed, 29 Mar 2006 21:36:04 -0400 (AST) Received: (qmail 27040 invoked from network); 30 Mar 2006 01:36:03 -0000 Received: from unknown (HELO ?10.0.0.253?) (10.0.0.253) by verkiel.travelamericas.com with SMTP; 30 Mar 2006 01:36:03 -0000 Message-ID: <442B3603.7030309@metatrontech.com> Date: Wed, 29 Mar 2006 17:36:03 -0800 From: Chris Travers User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: lmyho CC: Chris Travers , pgsql-admin@postgresql.org Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! References: <20060330012656.87991.qmail@web30808.mail.mud.yahoo.com> In-Reply-To: <20060330012656.87991.qmail@web30808.mail.mud.yahoo.com> Content-Type: multipart/mixed; boundary="------------060406060700030503010107" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.115 required=5 tests=[AWL=0.115, MANY_EXCLAMATIONS=0] X-Spam-Score: 0.115 X-Spam-Level: X-Archive-Number: 200603/351 X-Sequence-Number: 21108 This is a multi-part message in MIME format. --------------060406060700030503010107 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Things to check when PostgreSQL doesn't seem to start: 1) Are there any postmaster programs running (ps -A | grep postmaster is useful here) 2) If not, is there a postmaster.pid file n the postgresql data directory? (do a search for the file if you have to-- if no postmaster processes are running delete the file and try again) 3) What are the final entries in the serverlog in the data directory? In your case, if PostgreSQL is hanging, I would suspect that the problem is likely to be with something else. Hopefully there would be info in the serverlog that would help. Best Wishes, Chris Travers Metatron Technology Consulting lmyho wrote: > > > >>Perhaps I wasn't clear. >> >> >. > > >>With identd authentication a username is still specified. But you have >>to own the process to login with that username. So generally speaking >>(absent sudo and the like) you can generally login only with the same >>username as your OS username. >> >> > > > >>The documentation of PostgreSQL goes into a bit of depth on >>authentication, but if you want a little bit to get started, you might >>find the following article helpful: >> >> > > > >>http://www.metatrontech.com/sql-ledger-wiki/index.php?UnderstandingPostgreSQLAuthentication >> >> > >Hi Chris, > >Hope you are on line and can see this mail soon. Just turned on the Debian system computer today but got trouble at system booting time when it's trying to start the PostgreSQL server!! > >What I did yesterday was: changed the system created password of user postgres, by "alter user postgres password 'blabal...' ", and changed the ident method to md5, in order to login as postgres through pgAdmin3 into the database. Everything seemed fine yesterday while I was in the system. I loged out after 1am this very morning, and just to login again today right now. > >However, the system doesn't work anymore.:(( When the Debian systen booting, it stoped at "Starting PostgreSQL 8.1 database server: main", and hung there forever... >I tried to start againfrom the Recovery mode, was able to login as root, but don't know what to do at the command line mode.:(( When I exit from the recovery mode, the system tried to switch to the login point and seemed to use the standard process to approach the login point, so it went to the point of starting the Postgresql server again and hung there again with the same info: "Starting PostgreSQL 8.1 database server: main", and goes nowhere:((( > >What is the problem?? Is there angthing has gone wrong with my change of the password of user postgres yesterday? Is there anyway to make the system booting go through?? By the way it has been impossible to reverse the password of user postgres because the original password was generated by the system during installation, and I don't even have a clue about what it is:(( > >Any help idea would be greatly appreciated!! Thank you for help very much!!! > >leo > >---------------------------(end of broadcast)--------------------------- >TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > > > --------------060406060700030503010107 Content-Type: text/x-vcard; charset=utf-8; name="chris.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="chris.vcf" begin:vcard fn:Chris Travers n:Travers;Chris email;internet:chris@metatrontech.com tel;work:509-888-0220 tel;cell:509-630-7794 x-mozilla-html:FALSE version:2.1 end:vcard --------------060406060700030503010107--