From: | "Andrew L(dot) Gould" <algould(at)datawok(dot)com> |
---|---|
To: | Aaron <aamehl(at)bezeqint(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: newbie and no idea |
Date: | 2003-08-18 18:32:39 |
Message-ID: | 200308181332.39185.algould@datawok.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Monday 18 August 2003 12:11 pm, Aaron wrote:
> 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]#
As root, execute: passwd postgres
Best of luck,
Andrew Gould
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-08-18 18:41:07 | Are you an pgODBC hacker? |
Previous Message | Vilson farias | 2003-08-18 18:28:39 | Re: Simulating sequences |