On Oct 18, 2004, at 1:09 AM, Joel wrote:


Because some Mac users prefer to use the Finder to manipulate files
rather than the Terminal .

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

(10.2) have a user named 'postgres' as default. And Apple Remote
Desktop 2.x which uses internally a postgres 7.3.2 database to store
statistic data does not use the postgres user afaik, it uses root...

regards David


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

On Oct 21, 2004, at 4:43 AM, David Teran wrote:

I'll take your word for it. I just can't recall creating one, yet it
was there. Maybe from something I did with fink. I see a mysql user
also. I know I did not create or install that .

Best,

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

At 9:20 AM -0400 10/21/04, John DeSoi wrote:
Fink creates a postgres user, amongst others, as part of the base
install. (Well, it's one of the strongly suggested packages, but
close enough since pretty much everyone puts it in)
--
Dan

--------------------------------------it's like this-------------------
Dan Sugalski even samurai
dan (AT) sidhe (DOT) org have teddy bears and even
teddy bears get drunk

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

That has in there by default since sometime before Jaguar. It's not used
unless you install mysql, but mysql became part of the default install
in the server versions somewhere after 10.0 beta, which might have
something to do with it.

--
Joel <rees (AT) ddcom (DOT) co.jp>


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

I'm a little late to the party, but figured I could at least offer some info for
the archives.

If you don't know the user's password, and you have admin access, then it really
doesn't matter. In fact, I set any special users (pgsql, mailman, etc.) upso
that they *cannot* be logged into normally. Instead, do this:

sudo su - pgsql

and then all you need to know is your own password.

You can use niutil to create and delete users and groups. Reading the man page
and exploring a bit using the -list and -read options will be very informative.

Here is a script I use to create a user. Execute it with sudo.



niutil -create . /groups/pgsql
niutil -createprop . /groups/pgsql gid 5001

niutil -create . /users/pgsql
niutil -createprop . /users/pgsql uid 5001
niutil -createprop . /users/pgsql gid 5001
niutil -createprop . /users/pgsql passwd \*
niutil -createprop . /users/pgsql home /Users/pgsql
niutil -createprop . /users/pgsql shell /bin/tcsh


gid and uid can be set to some non-conflicting number of your choice. I believe
that numbers over 5000 do not show up in System Preferences or the login window.

--
Jim Crate
Deep Sky Technologies, Inc.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

(A little back-seat driving from me below

On Thu, 4 Nov 2004 10:11:18 -0500
Jim Crate <jcrate (AT) deepskytech (DOT) com> favored us with

This gives you a shell under the pgsql user, which can be convenient,
but anything you do after getting the shell is not logged. Logging is
convenient in a different way.

Also, if you tighten up the configuration a bit, su will refuse to log a
user with no default shell or home directory.

I prefer to sudo each command, for the logging:

sudo -u pgsql <command>

If you don't like all that extra typing, command line editing is on by
default in the Mac OS X shell window, so you can just hit the up arrow,
erase the previous command, and type the next one.

And you can even use the netinfo GUI utility. (heh. I sudo each command,
but I use the GUI netinfo to save typing. I'm strange, I guess.)

--
Joel <rees (AT) ddcom (DOT) co.jp>


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match