From: | Ms swati chande <swativc(at)yahoo(dot)com> |
---|---|
To: | 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> |
Cc: | pgsql-general List <pgsql-general(at)postgresql(dot)org>, swativc(at)yahoo(dot)com |
Subject: | Re: Password? |
Date: | 2009-07-08 18:48:08 |
Message-ID: | 129740.22112.qm@web112612.mail.gq1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I started everything again from scratch.
1. Created a new user("Swati"), with limited/ restricted rights.
Ensured that no password is set anywhere.
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
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.
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
From | Date | Subject | |
---|---|---|---|
Next Message | SHARMILA JOTHIRAJAH | 2009-07-08 18:53:51 | Oracle Help in PG? |
Previous Message | Tom Lane | 2009-07-08 18:45:42 | Re: now() + '4d' AT TIME ZONE issue |