From: | Aaron <aamehl(at)bezeqint(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | newbie and no idea |
Date: | 2003-08-18 17:11:41 |
Message-ID: | 1061226701.4318.3.camel@bzq-218-14-208.cablep.bezeqint.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
A friend of mine just wrote a database for me using postgres.
I have postgres installed but can't figure out how to change the passwd
for user postgres.
[root(at)bzq-218-14-208 aamehl]# ps -U postgres
PID TTY TIME CMD
4014 pts/1 00:00:00 postmaster
4016 pts/1 00:00:00 postmaster
4017 pts/1 00:00:00 postmaster
[root(at)bzq-218-14-208 aamehl]#
---------------------------------------
root(at)bzq-218-14-208 aamehl]# ps -l -C postmaster
F S UID PID PPID C PRI NI ADDR SZ WCHAN TTY TIME CMD
0 S 26 4014 1 0 72 0 - 2446 do_sel pts/1 00:00:00
postmaster
1 S 26 4016 4014 0 72 0 - 2693 do_sel pts/1 00:00:00
postmaster
1 S 26 4017 4016 0 72 0 - 2451 do_sel pts/1 00:00:00
postmaster
[root(at)bzq-218-14-208 aamehl]#
----------------------------------------------------------------
[root(at)bzq-218-14-208 aamehl]# createdb -U postgres nigun_test
psql: FATAL: IDENT authentication failed for user "postgres"
createdb: database creation failed
[root(at)bzq-218-14-208 aamehl]#
-----------------------------------------------------
Any idea??
I am also interested in getting some front end up and running.
Thanks
Aaron
From | Date | Subject | |
---|---|---|---|
Next Message | Ed L. | 2003-08-18 17:17:20 | Re: dbmirror revisions |
Previous Message | Rich Parker | 2003-08-18 17:02:45 | Re: New to list, quick question. |