I feel confident I understand what's involved at the db level:
- If dropping, I'd need to create users for each sys admin, give them
SUPERUSER
, and then drop thepostgres
user. - If changing the name, I'd need to alter the
postgres
account.
My problem, though, is that I'm not sure what the consequences of this action would be. For example, what would it mean from the point of view of the Linux postgres
user? When I su - postgres
, I can run psql
and I'm able to connect to the database. I assume that capability goes away if the postgres DB user is gone.
Also, the database is started using the postgres
linux user. Is there some issue if I remove the postgres
user that would make it so the database wouldn't even be able to start?
From ps:
/usr/pgsql-9.3/bin/postgres -D /var/lib/pgsql/9.3/data PG_GRANDPARENT_PID=1 USER=postgres PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin PWD=/ PGLOCALEDIR=/usr/pgsql-9.3/share/locale LANG=en_US.UTF-8 PGSYSCONFDIR=/etc/sysconfig/pgsql SHLVL=1 HOME=/var/lib/pgsql LOGNAME=postgres PGDATA=/var/lib/pgsql/9.3/data _=/usr/pgsql-9.3/bin/postgres
I'm running PosrgreSQL 9.3 on Cent OS 7.