Re: Re: postmaster question

From: Doug McNaught <doug(at)wireboard(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 17:29:09
Message-ID: m3hf1k0z2y.fsf@belphigor.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lonnie Cumberland <lonnie_cumberland(at)yahoo(dot)com> writes:

> 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:

What you need to do is 'su' to user 'postgres' and run 'createuser'.
It will ask if the new user is allowed to create databases, say yes.

Then, just log in as yourself and do:

$ createdb foo
$ psql foo

and you'll be good to go.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2001-02-24 17:41:26 Re: vacuum and backup
Previous Message Doug McNaught 2001-02-24 17:26:37 Re: problems with copy