Re: [ADMIN] FATAL 1: SetUserId:

Hi,

I am fairly new to Postgres, and had some installation problems similar to
yours. I am also using Redhat 5.0 and installed the RPMs. Although this
may not be the ideal workaround, it worked for me.

When you ran initdb, it should have created a 'postgres' user for
you.
If you do not have the password for it, log it as 'root', then type
'passwd postgres' and enter a new password. Log out and log back in as
postgres. Then "createuser username". You should be able to log out, and
log back in as the user you created, then run "psql databasename"
(provided you have already done a 'createdb databasename" as 'postgres'.
Now, this will not give you access to having full rights to create,
destroy, and edit databases. You must grant these accesses from the
postgres account. In any case, just using this process, you can
create a database and tables in postgres and give SELECT, INSERT, and
UPDATE access to your user by typing
--> GRANT ALL ON databasename TO username
--> \g
I did this with username 'nobody' to give my Apache server access to the
database. The RPM for Redhat 5.0 sets up Postmaster with TCP/IP
connectivity, so you don't have to worry about it.

Hope that helps. If it doesn't, let me know where it is failing and I
will re-walk through my own Redhat RPM install.

John Cook

On Thu, 13 Aug 1998, Bernd Johannes Wuebben wrote:

>
> On 13-Aug-98 Bruce Momjian wrote:
> > That is funny. We do have a somewhat creeping featurism, though the
> > stuff has not changed much in the recent releases. What should be
> > changed/added/removed?
>
> I am new to postgres and am abosultely not qualified to comment on that.
> All I want at this point is to get postgres to work.:-) My previous mails
> indicate the problems I am having. I did read the tuturial and much
> of the other documentation that is supplied with postgres, but I can't
> get started.
>
> It might well be that the problem is trivial or just a goof up of the
> rpm builder. So let's see what the problem is and how to resolve it.
> Once that's achieved we can think about improving the documentation or
> whatever else needs to be done ;-)
>
> thanks,
> Bernd
>
>
> >
> >
> > --
> > Bruce Momjian | 830 Blythe Avenue
> > maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania
> > 19026
> > + If your life is a hard drive, | (610) 353-9879(w)
> > + Christ can be your backup. | (610) 853-3000(h)
>
> --------------------------------------------------------------------
> Bernd Johannes Wuebben wuebben(at)kde(dot)org
> wuebben(at)math(dot)cornell(dot)edu wuebben(at)acm(dot)org
> --------------------------------------------------------------------
>
>
>