Make the port more "package friendly".

Do not call initdb from Makefile's post-install. Users are required to
manually run initdb, maybe after configuring their preferred database
location in pgsql's user .profile. pkg_add used to simply replace some
existing data files.

Add pkg-message to tell the user about initdb.

Remove 2 empty directories from pkg-plist (pgsql/include/port/freebsd,
pgsql/include/port), since they are not included in "make package" anyway
and cause pkg_deinstall to complain about the plist.

Remove all pgsql/data contents from pkg-plist, so "make deinstall" and
pkg_delete won't clobber existing databases. Minor version upgrades can now be
performed by means of pkg_delete and "make install", without using pg_dump.

Chown %D/pgsql/lib to root:wheel to satisfy ldconfig's recent security
requirements.

Change @dirrm of pgsql to "@unexec rmdir": pkg_deinstall won't complain if
data still exists in that directory at deinstall time.

Approved by:	maintainer

1 files changed, 12 insertions, 0 deletions

diff --git a/databases/postgresql-devel/pkg-message b/databases/postgresql-devel/pkg-message
new file mode 100644
index 000000000000..88cc50d642e6
--- /dev/null
+++ b/databases/postgresql-devel/pkg-message
@@ -0,0 +1,12 @@
+==========================================
+To initialize the database, you should run
+initdb as the "pgsql" user.
+
+Example:
+
+  su -l pgsql -c initdb
+
+You can then start PostgreSQL by running:
+
+  /usr/local/etc/rc.d/pgsql.sh start
+==========================================