pgsql user (Postgresql)

[balanga]

I'm following instructions for install Postgresql 9.6 here https://cwharton.com/blog/2016/10/postgresql-and-freebsd-quick-start/

and have succeeded in installing and starting the server, but I'm told to "Log into the pgsql account created for you when you installed PostgreSQL." But there is no such account.

What did I miss?

 

[SirDice]

The port/package should create a postgres user and group:

PG_USER?=       postgres
PG_GROUP?=      postgres
PG_UID?=        770

 

[balanga]

In the foresaid instructions PostgreSQL and FreeBSD Quick Start for setting up Postgresql 9.6 on FreeBSD -

https://cwharton.com/blog/2016/10/postgresql-and-freebsd-quick-start/

it definitely says

Log into the pgsql account created for you when you installed PostgreSQL.

So I'm confused as it has not been created as part of my installation.

 

[julp]

PostgreSQL's user was changed, this definitely is postgres for PostgreSQL >= 9.6 (pgsql remains for older versions). From /usr/ports/UPDATING:

20160905:
AFFECTS: users of databases/postgresql96-server
AUTHOR: girgen@FreeBSD.org

The default unix user used by the PostgreSQL daemon has changed to
`postgres' to reflect the long time upstream's convention. Any scripts
you have using the old `pgsql' unix user should be modified when upgrading to
PostgreSQL version 9.6. Older versions of PostgreSQL will continue using
`pgsql' until their end-of-life.

[...]

Your source is simply not up to date. Moreover, this change to the ports tree may not have affected binary packages before a while (especially with a quarterly repository)

 

[balanga]

Thanks for taking the time to explain the situation.