From: | "Darren Weber" <darren(dot)weber(dot)lists(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | postgres user account on OSX |
Date: | 2008-09-10 23:14:15 |
Message-ID: | b808b3510809101614k581a5877w287a49ce42481a4a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
There is a postgres user account on my OSX system. I'm not clear
about how it was created. I've installed a binary version of 8.3 in
/Library/PostgreSQL/8.3/ and built another version from source into
/usr/local/pgsql/. When I login as root and then 'su - postgres' it
takes me to the postgres account and the user directory is at
/opt/local/var/db/postgresql83/.
Can someone explain how this user account was created?
I'm trying to start the server that I built from source but it will
not create a logfile, ie:
elegans:~ postgres$ /usr/local/pgsql/bin/pg_ctl -D
/usr/local/pgsql/data -l logfile start
server starting
sh: logfile: Permission denied
elegans:~ postgres$
elegans:~ postgres$ nohup /usr/local/pgsql/bin/postgres -D
/usr/local/pgsql/data </dev/null >>server.log 2>&1 </dev/null &
[1] 28696
elegans:~ postgres$ -sh: server.log: Permission denied
elegans:~ postgres$
elegans:~ postgres$ pwd
/opt/local/var/db/postgresql83
elegans:~ postgres$
elegans:~ postgres$ ls -al ..
total 0
drwxr-xr-x 4 root admin 136 Aug 28 12:05 .
drwxr-xr-x 8 root admin 272 Sep 9 14:49 ..
drwxr-xr-x 3 root admin 102 Aug 28 12:05 postgresql83
drwxr-xr-x 3 root admin 102 Aug 26 13:06 smb
Should I remove this user somehow and replace it with a standard user
(using the system admin GUI)?
Thanks, Darren
From | Date | Subject | |
---|---|---|---|
Next Message | kevin kempter | 2008-09-10 23:19:56 | Re: postgres user account on OSX |
Previous Message | Scott Marlowe | 2008-09-10 22:10:04 | Re: pgdump problem or question? |