Re: PostgreSQL not stsrt!:( -Re: Please help, pgAdmin3 - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: PostgreSQL not stsrt!:( -Re: Please help, pgAdmin3
Date
Msg-id 442B4E06.4000502@dunslane.net
Whole thread Raw
In response to PostgreSQL not stsrt!:( -Re: Please help, pgAdmin3 on Debian!  (lmyho <lm_yho@yahoo.com>)
List pgsql-hackers
-hackers is not the place for these questions. Please ask your questions 
in the correct forum, possibly pgsql-general. -hackers is for discussion 
of backend development.

cheers

andrew

lmyho wrote:

>>> Which is good.  But I've got big trouble to login to this initial db by
>>>using this auto-created username "postgres" through pgAdmin:(((  The first
>>>try failed due to "Ident authentication failed", so I follow the suggestion
>>>on the pop-up window of pgAdmin3, and changed the ident method in the
>>>pg_hba.conf file all to md5 to try again, but the database now ask me for
>>>the password!! which I couldn't figure out the passwd so I tried to created
>>>rules in the pg_ident.conf file to map both the ordinary user and root user
>>>od Debian system to postgres, and tried again.  But still failed,:(((
>>>"ident authentication failed"again!!!:(((  I've tried many times for all I
>>>could think and failed everytime failed:(((  By the way each time before I
>>>try, I did "pg_ctl reload", and I could see the failure reason changed after
>>>I do reload.
>>>      
>>>
>>You could try to change the ident method to trust (in pg_hba.conf). This
>>should allow you to login.
>>Then, set the password of the postgres user (alter user postgres with password
>>'blabla1212' ; ).  Then you could change the ident method back to md5 .
>>
>>
>>Adrian Maier
>>    
>>
> 
>Hi Adrian and All,
> 
>I've got trouble again!:(( I changed the possword of postgres yesterday following the inst you gave, everything worked
fineafter the change, and I was able to login to the initial db through pgAdmin3 as the user postgres. I loged out of
theDebian system until after 1am this very morning, and everything was fine at that time.
 
> 
>But when I tried to login again to day today right now, I got problem.  The Debian system started booting, everything
goesfine until at the moment to start the postgresql server.  The booting msg shows "Starting postgreSQL 8.1 database
server:main", and then hung forever and not move anymore.  I have to turn off the computer power to stop it!  I tried
tologed in via the Recovery mode and was able to login as root, but I don't know what to do about the PostgreSQL and
whateverrelated system booting process at the command line mode??:(( 
 
> 
>So is there anything has been wrong with what I did yesterday? Does the password change of user postgres has some
impacton the Debian system booting?  
 
> 
>Please help me out of this.  The PostgreSQl 8.1 just installed, not in use at all, all has been done on it was the
changeof the password of user postgres, in order to login to the initial db through pgAdmin3.
 
> 
>Any help would be greatly appreciated!!!  Thank you in advance!!!
> 
>leo 
>
>
>  
>


pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: control pg_hba.conf via SQL
Next
From: Tom Lane
Date:
Subject: Re: psql \c error