[CentOS] RPM for postgresql 8-* for CentOS4?

[Mark Sargent]

Craig White wrote:

>-----
>nowhere do you actually say what you are trying to do.
>
>Are you trying to start postgresql server?
>
>/sbin/service postgresql start
>
>Are you trying to get postgresql server to start on each boot?
>
>/sbin/chkconfig postgresql on
>
>Are you trying to use the client application?
>
>/usr/bin/psql [options]
>
>Are you trying to locate the configuration files?
>
>/var/lib/pgsql/data
>
Hi All,

1st, let me apologize for being slack. I should do more research before 
asking in here. Anyway, I got it running, but, am new to pgsql and am 
getting this,

[racket at ibmlap lib]$ psql template1
psql: FATAL:  role "racket" does not exist

so I went into to the data dir and looked around and thought I could add 
to the below files.

pg_ident below,

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               ident sameuser
# IPv4 local connections:
host    all         all         127.0.0.1/32          ident sameuser
# IPv6 local connections:
host    all         all         ::1/128               ident sameuser

pg_hba.conf is below,

# MAPNAME     IDENT-USERNAME    PG-USERNAME
  racket      racket             postgres

I know I'm close with this. Cheers.

Mark Sargent.