automatically starting PostgreSQL

[Warren Block]

On Mon, 2 Apr 2007, Charles Farinella wrote:

> I built PostgreSQL from source

In other words, not from ports?  Or if it was from ports, which port?

> and copied the supplied startup script to 
> /etc/rc.d/postgresql.  The script works as expected.

Yes, but that's not where it should be in FreeBSD, if that's even a 
startup script meant for FreeBSD.

> In /etc/rc.conf I've added the following:
>
> postgresql_enable="YES"
>
> expecting this to automatically start PostgeSQL at boot, yet this doesn't 
> happen and there is nothing in any error log that I can find that mentions 
> any failure.

For that to work, you'd have to have the (correct) script in 
/usr/local/etc/rc.d.  Remove the source version of PostgreSQL and 
install it from the appropriate port, and the port will install the 
right script in the right place.

-Warren Block * Rapid City, South Dakota USA