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 the
- If changing the name, I'd need to alter the
My problem, though, is that I'm not sure what the consequences of this action would be. For example, what would it means 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?
/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.