Date: Tue, 25 May 1999 16:47:41 -0700 (PDT) From: Doug White <dwhite@resnet.uoregon.edu> To: jfreeze@lexmark.com Cc: freebsd-questions@FreeBSD.ORG, pgsql-novice@postgreSQL.org Subject: Re: Installing and Running PostgreSQL on FreeBSD 3.1 Message-ID: <Pine.BSF.4.03.9905251643510.13061-100000@resnet.uoregon.edu> In-Reply-To: <199905252025.AA23818@interlock2.lexmark.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Tue, 25 May 1999 jfreeze@lexmark.com wrote: > 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 Good. > 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 Looks good. > 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? That's normal. In general, you don't want random users reading your databases since they may contain passwords and other important data. You should connect to the PostgreSQL daemon and it will service the request for you. Read the applicable documentation (including the post-install-notes in your directory there) for further instructions. > (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). Then simply: 1) su to root 2) su to pgsql 3) launch portmaster OR 1) verify a script exists in /usr/local/etc/rc.d/ to start pgsql 2) reboot Doug White Internet: dwhite@resnet.uoregon.edu | FreeBSD: The Power to Serve http://gladstone.uoregon.edu/~dwhite | www.freebsd.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?Pine.BSF.4.03.9905251643510.13061-100000>