Re: running postgresSQL 7 on Linux as postgres user

Hello,

Actually the below will not work as RedHat intended. RedHat uses a
service manager (Mandrake as well) called chkconfig. The chkconfig
program can use the sh script provided with PostgreSQL "IF" you edit
it.

You must add the following two lines:

# chkconfig: 345 85 15
# description: Starts and stops the PostgreSQL backend daemon\
# that handles all database requests.

The description line can say anything as long as chkconfig finds the
"description:" For reference, this is covered in chapter two of the
book Practical PostgreSQL.

J

Björn Lundin <bjorn(dot)lundin(at)swipnet(dot)se> wrote in message news:<9n61k4$2659$1(at)news(dot)tht(dot)net>...
> A.A wrote:
>
> > hello,
> >
> > I'm new to postgreSQL. On my linux Red Hat 7.1 machine I've installed
> > the postmaster software that came with the distribution; now, form the
> > commandline when I try to run :
> > % postmaster
> >
> > I get a error saying that the pastgreSQL back-end cannot be run as
> > 'root' user. a seperate user has to be created for PS.
> > Since the install setup a 'postgres' user already, I'm confused. How
> > come PS doesn't start automatically ?
> >
> > I'd appreciate any help.
> >
> > Thanks,
> >
> > Best Regards,
> >
> > Ahsan A.
> On a Red Hat, the startup script proberbly is located in
> /etc/init.d and called postgres.
>
> Make a symbolic link to /etc/init.d/rc3.d and/or /etc/init.d/rc5.d
> to start at boot. (name it like S65postgresql)
>
> Also put symbolic links to /etc/init.d/rc0.d and /etc/init.d/rc6.d
> and name them like K15postgresql to bring it down at shutdown/reboot
>
>
> Björn