thanx for the suggestion ... it just clicked !!
Ankit Arun Mehrotra
=-=-=
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
rev
On 12/8/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
my postmaster is on the same machine .. i am pasting the command and its
output here for u :-
% psql -d template1 -U postgres
psql: FATAL: Ident authentication failed for user "postgres"
You will need to modify pg_hba.conf file in the
specify the user which did initdb.
--Imad
www.EnterpriseDB.com
On 12/8/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
my postmaster is on the same machine .. i am pasting the command and its
output here for u :-
% psql -d template1 -U postgres
psql: FATAL: Ident authentication failed for
my postmaster is on the same machine . i am pasting the command and its
output here for u :-
% psql -d template1 -U postgres
psql: FATAL: Ident authentication failed for user "postgres"
Please do guide.
Ankit Arun Mehrotra
Tata Consultancy Services
Mailto: [EMAIL PROTECTED]
Website: http://ww
On 12/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I am new to using postgres. I working on version 8.0.
I have created a number of users in the database but I am not able to log
into it using any of them,
Hi,
Could you please paste the ERROR message you get.
regds
mallah.
where in
Did You specified the database ? In PostgreSQL You are logging into
database, not into DBMS, like in MySQL.
For test users try template1 first, for example psql -h yourhost -U
somebody -d template1
Did You grant those users rights to database wchich they are connecting
to ?
Regards
Adam
[EMAIL
I am new to using postgres. I working on version 8.0.
I have created a number of users in the database but I am not able to log
into it using any of them, where in logging into using user postgres is
successfull the commands that i am using are
-- createuser -a -d -P "username"
for loggi
