Bug 78630 - databases/postgresql80-server doesn't allow alternet PG superuser anymore
Summary: databases/postgresql80-server doesn't allow alternet PG superuser anymore
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: Normal Affects Only Me
Assignee: Palle Girgensohn
Depends on:
Reported: 2005-03-09 16:20 UTC by Vick Khera
Modified: 2005-03-19 03:58 UTC (History)
0 users

See Also:

file.diff (338 bytes, patch)
2005-03-09 16:20 UTC, Vick Khera
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Vick Khera 2005-03-09 16:20:02 UTC

I just upgraded Postgres from 7.4 to 8.0 via the ports.  After suitably
editing the new config files, initializing the database (using my standard
procedure), starting postgres fails since the user "pgsql" doesn't exist.

The current setup requires that the postgres super user be "pgsql".  Up thru
the port for 7.4.7, it allowed the postgres super user to be set from the
environment in ~pgsql/.profile for PGUSER.  Traditionally, many people
(including myself) have used "postgres" as the database superuser.  Much of
my infrastructure assumes superuser='postgres' so this is a hard change to
force into the port.

Fix: Use "su -l" like the 7.4.x init script does.


install the port for postgres 8.
export PGUSER=postgres in ~pgsql/.profile
init the database with:
 su - pgsql -c 'initdb -U postgres'
then start /usr/local/etc/rc.d/010.pgsql.sh start

it will fail to start.  doing the same process for 7.4 postgres port works
just fine.
Comment 1 Volker Stolz freebsd_committer 2005-03-10 08:37:02 UTC
Responsible Changed
From-To: freebsd-ports-bugs->girgen

Over to maintainer
Comment 2 Palle Girgensohn freebsd_committer 2005-03-19 03:57:55 UTC
State Changed
From-To: open->closed

Committed. Thanks!