Opened 17 years ago

Last modified 3 years ago

#14083 assigned enhancement

compatibility improvement for postgresql82-server — at Version 1

Reported by: apinstein@… Owned by: macports-tickets@…
Priority: Normal Milestone:
Component: ports Version:
Keywords: Cc:
Port: postgresql82-server

Description (last modified by jmpalacios (Juan Manuel Palacios))

For starting/stopping the server, you should do:

instead of

  su postgres -c "${PGCTL} -D ${POSTGRESQL82DATA:=/opt/local/var/db/postgresql82/defaultdb} start -l /opt/local/var/log/postgresql82/postgres.log"

do

  sudo -u $PGUSER sh -c "${DAEMON} -D '${PGDATA}' | ${LOGUTIL} '${PGLOG}' ${ROTATESEC} &"

The latter is the postgresql way now, and doesn't require the "postgres" user to have a login shell, which is more secure.

Also, when creating the "postgresql" user, set the shell to /usr/bin/false.

Change History (1)

comment:1 Changed 17 years ago by jmpalacios (Juan Manuel Palacios)

Description: modified (diff)
Milestone: Port Enhancements
Type: defectenhancement
Note: See TracTickets for help on using tickets.