Re: Password?

On Wednesday 08 July 2009 11:48:08 am Ms swati chande wrote:
> Hi,
>  
> I started everything again from scratch.
> 1. Created a new user("Swati"), with limited/ restricted rights.
>     Ensured that no password is set anywhere.

How limited? Can this user do administrative tasks, i.e create database,create
user?

>  
> 2. Ran initdb from the new user.
>             c:\postgresql\bin>initdb -D c:\postgresql\data2
>        It displayed the DEBUG: start transaction and commit transaction
> states etc. and ended with DEBUG: exit(0)
>        A warning with the following statement was also displayed:
>              WARNING: enabling "trust" authentication foe local connections
>              you can change this by editing "pg_hba.conf" or by initdb -A.
>  
> 3. After this I executed pg_ctl:
>              c:\postgresql\bin>pg_ctl -D c:\postgresql\data2 -l logfile
> start got the the message:server starting
>              and the logfile contained the following:
>                  LOG:  could not bind IPv4 socket: No error
>                  HINT:  Is another postmaster already running on port 5432?
> If not, wait a few seconds and retry.
>                  WARNING:  could not create listen socket for "localhost"
>                  FATAL:  could not create any TCP/IP sockets
>                  LOG:  could not bind IPv4 socket: No error
>                  HINT:  Is another postmaster already running on port 5432?
> If not, wait a few seconds and retry.
>                  WARNING:  could not create listen socket for "localhost"
>                  FATAL:  could not create any TCP/IP sockets
>  
> 4. To take care of the above issues,
>          Made the following change in the postgresql.conf file:
>                  listen_addresses = 'xxx.xxx.x.x' (my current ip)
>          and in pg_hba:
>                  host all all 'xxx.xxx.x.x' trust

Can you show the complete pg_hba.conf file? Or to put it another way is the
above line the only uncommented line in the file?

>  
> 5.Then issued
>          c:\postgresql\bin>pg_ctl -D c:\postgresql\data2 -l logfile start
>    again.
>    Now got the following in logfile:
>                  LOG: database system was shut down at 2009-07-08 22:34:50
>                  LOG: database system is ready to accept connections
>                  LOG:  autovacuum launcher started
>  
> 6.Opened another command window.
>    Now when I write in the new window (or even in the same),
>                  c:\postgresql\bin>createdb demo
>    OR
>                  c:\postgresql\bin>createuser -S -d -R svc
>    I am prompted for password, I don't know what to enter here.

Are you running this as 'Swati' user?

>  
> I think I am making some mistake in pg_hba.conf. Can't make out.
> Must be some brainless blunder some where.
>  
> Thanks a ton for sparing your time and bearing with me.
>  
> Please guide.
>  
> Regards
> Swati



--
Adrian Klaver
aklaver@comcast.net