| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Lonnie Cumberland <lonnie_cumberland(at)yahoo(dot)com> |
| Cc: | Mitch Vincent <mitch(at)venux(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Re: postmaster question |
| Date: | 2001-02-24 10:58:41 |
| Message-ID: | 3A9793E2.32A61A90@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Lonnie Cumberland wrote:
>
> Hello Mitch,
>
> I have been trying to do just that and hove found that by going to my init.d
> directory and starting up the "postgresql" service helps.
>
> Now the problem seems to be that even though I have just used "pg_passwd" to
> add me as a user, I am now getting an error message back saying that:
>
> ---------------------------------------------------------------
> Connection to database 'template1' failed.
> FATAL 1: SetUserId: user 'lonnie' is not in 'pg_shadow'
>
> createdb: database creation failed on testpg.
> ----------------------------------------------------
Make sure that postgres is actually running by checking "ps aux | grep post"
Make sure that initdb has been run.
Make sure that you have created a user with "createuser" (I think this
is the one for you)
- Richard Huxton
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2001-02-24 11:16:49 | Re: ...lame use of casting, looking for workaround... |
| Previous Message | Richard Huxton | 2001-02-24 10:49:15 | Re: vecor/list INSERT or UPDATE |