Quantcast

postgresql_user in 010.pgsql.sh

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

postgresql_user in 010.pgsql.sh

Michael Mulligan
The current port hardcodes the postgresql_user as "pgsql" in pgsql.sh.tmpl:

   postgresql_user=pgsql

I want to make the suggestion to make this configurable via /etc/rc.conf
- the default would remain "pgsql":

  postgresql_user=${postgresql_user:-"pgsql"}


Thanks for considering this.
_______________________________________________
[hidden email] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[hidden email]"
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: postgresql_user in 010.pgsql.sh

Michael Mulligan
Theodore Campbell wrote:

>I assume you're trying to set the postgres super user to something other than
>pgsql. It's good to know that the system user and the database super user
>are not related in any way. ...
>

My post was terse, not explaining why I was asking for this.  Perhaps
I have a weak reason: it is just for convenience with some legacy
operational conventions where both the UNIX username and the
Postgresql super user were named "postgres".  My workaround has been
to make the edit locally as indicated in my first email.  I thought other
folks might find this useful.

Thanks for your reply.

_______________________________________________
[hidden email] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[hidden email]"
Loading...