Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 25 May 1999 16:24:25 -0400
From:      jfreeze@lexmark.com
To:        freebsd-questions@freebsd.org, pgsql-novice@postgreSQL.org
Subject:   Installing and Running PostgreSQL on FreeBSD 3.1
Message-ID:  <199905252025.AA23818@interlock2.lexmark.com>

next in thread | raw e-mail | index | archive | help
I trying to get postgres-6.0.4 working on FreeBSD 3.1. I installed
from the ports collection from the Walnut Creek 4 CDROM set.
I performed the install by

cd /usr/ports/database/postgres
make install


using the root account. After this, the postgres directory looks like


total 7
-rw-r--r--   1 pgsql  pgsql  440 May 24 17:40 .profile
drwxr-xr-x   2 pgsql  pgsql  512 May 24 17:40 bin
drwx------   3 pgsql  pgsql  512 May 24 17:40 data
drwxr-xr-x  10 pgsql  pgsql  512 May 24 17:40 include
drwxr-xr-x   2 pgsql  pgsql  512 May 24 17:40 lib
drwxr-xr-x   6 pgsql  pgsql  512 May 24 17:40 man
-r--r--r--   1 root   wheel  461 May 24 17:40 post-install-notes


When I login in as a normal user, I cannot access a database since
I have no rights on the data directory.

Why is the data directory set to drwx-------?
What went wrong?
Although I have read several docs, I am a newby and am not sure what
to expect here.

(A BSD admin question)
Also, the docs seem to suggest that I need to be logged in as
user pgsql to start the postmaster. I tried to create this user account
but it said that it already existed. I don't remember making it, but
if I did, how do I manually delete it and recreate it (since I don't
know the password for that user).


I am sending this post to both freebsd-questions@freebsd.org and to
pgsql-novice@postgreSQL.org since I am not sure which group can best
help.

Thanks

Jim Freeze
jim@freeze.org




To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?199905252025.AA23818>