# cat /etc/passwd|grep postgres
postgres:x:500:500:PostgreSQL:/opt/PostgreSQL/:/bin/bash
enterprisedb:x:501:501:Postgres Plus Advanced Server:/opt/PostgresPlus/9.3AS:/bin/bash
#
# ps -ef
postgres 9799 1 0 Jan29 ? 00:00:38 /opt/PostgreSQL/9.3/bin/postgres
postgres 9800 9799 0 Jan29 ? 00:00:00 postgres: logger process
postgres 9802 9799 0 Jan29 ? 00:02:10 postgres: checkpointer process
postgres 9803 9799 0 Jan29 ? 00:01:25 postgres: writer process
postgres 9804 9799 0 Jan29 ? 00:00:09 postgres: wal writer process
postgres 9805 9799 0 Jan29 ? 00:00:37 postgres: autovacuum launcher process
postgres 9806 9799 0 Jan29 ? 00:02:07 postgres: stats collector process
....
501 2064 1 0 15:11 pts/8 00:00:00 /opt/PostgresPlus/9.3AS/bin/edb-postgres
501 2066 2064 0 15:11 ? 00:00:00 postgres: logger process
501 2068 2064 0 15:11 ? 00:00:00 postgres: checkpointer process
501 2069 2064 0 15:11 ? 00:00:00 postgres: writer process
501 2070 2064 0 15:11 ? 00:00:00 postgres: wal writer process
501 2071 2064 0 15:11 ? 00:00:00 postgres: autovacuum launcher process
501 2072 2064 0 15:11 ? 00:00:00 postgres: archiver process
501 2073 2064 0 15:11 ? 00:00:00 postgres: stats collector process
ps -ef 명령어로 디비 프로세스를 살펴보면
PostgreSQL 인 경우는 유저명이 제대로 보이나, PPAS 경우는 왜 enterprisedb 유저명이 아닌 UID 값 501
이 보일까요?
그 이유는 간단합니다.
유저명이 8자를 초과하기 때문입니다. (enterprisedb 12자)
