postgres user account on OSX

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

Responses

Browse pgsql-general by date

  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?