postmaster question

Read the installation documentation that comes with the source/binaries. :-)

-Mitch

----- Original Message -----
From: "root" <Lonnie_Cumberland@yahoo.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, February 20, 2001 6:48 PM
Subject: postmaster question

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

Could you please tell me what I am doing wrong with this stuff?

I am very new to using it and still do not have feel for the way that things
are done.

I just want to do a simple test on this system by adding a user, create a
database, and start up "psql" with it.

Cheers,
Lonnie
--- Mitch Vincent <mitch@venux.net> wrote:

Read the installation documentation that comes with the source/binaries. :-)

-Mitch

----- Original Message -----
From: "root" <Lonnie_Cumberland@yahoo.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, February 20, 2001 6:48 PM
Subject: postmaster question

Hello All,

does anyone know how to get the postmaster set up properly in a native
version of Mandrake Linux 7.1?

I see that that RPM's are there, but the the backend daemon is not up
and running. I tried to just enter "postmaster" but it says that
I cannot be runnig it as root and that it needs it's own userid.

I did not see where in the docs that the install discusses this.

Any ideas anyone?

Best Regards,
Lonnie

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/

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

Lonnie Cumberland <lonnie_cumberland@yahoo.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