Re: pgsql user change to postgres

Joe <dev@freedomcircle.net> writes:
> It was when I tried starting PostgreSQL from boot, which requires adding
> "postgresql_enable" in /etc/rc.conf, that it didn't work.  I tracked
> that down to /usr/local/etc/rc.d/010.pgsql.sh which uses a
> "postgresql_user" variable defined as "pgsql" by the port.  And this in
> turn is driven by the Makefile and other files provided by the FreeBSD
> port.  As I mentioned, I could fix those references to 'pgsql' but then
> I'd have to patch them any time I fetched a port update.

> So I guess the port procedures are not controlled by the Development Group?

We can't dictate the contents of port-supplied files, if that's what you
mean.

Plan B is to leave the pgsql user alone and add another superuser named
postgres.  You can have more than one superuser ...

            regards, tom lane