Return to root then run systemctl status postgresql.service. The only thing you should be running as Pleroma is mix tasks.