From: | Adrian Klaver <aklaver(at)comcast(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Ms swati chande <swativc(at)yahoo(dot)com>, Jasen Betts <jasen(at)xnet(dot)co(dot)nz>, Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de>, Steve Atkins <steve(at)blighty(dot)com>, Serge Fonville <serge(dot)fonville(at)gmail(dot)com>, Abbas <abbas(dot)dba(at)gmail(dot)com>, Shashank Sahni <shredder12(at)gmail(dot)com> |
Subject: | Re: Password? |
Date: | 2009-07-09 01:21:46 |
Message-ID: | 200907081821.46891.aklaver@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)comcast(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Yaroslav Tykhiy | 2009-07-09 01:53:12 | Re: ZFS prefetch considered evil? |
Previous Message | Erik Jones | 2009-07-09 00:15:04 | Re: PostgreSQL and Poker |