newbie question

[Tena Sakai]

Hello Ryan,

I did it!  Many thanks for your help.

Unfortunately, I am not able to use it yet.

Having installed it, the first thing I want to do is to run
'psql postgres' command.  When I do this, it asks me
postgres user password.  I have no idea what that is
(I think maybe macport created postgres user?).  When
I use "Accounts" from System Preferences it shows no
such user as postgres.  However, I can become root
and then issue 'su postgres' command and strangely
enough I am indeed user postgres.

Can you please give me a tip as to how to reset password
for user postgres?

Thank you.

Tena


--- On Mon, 5/2/11, Ryan Schmidt <ryandesign at macports.org> wrote:

From: Ryan Schmidt <ryandesign at macports.org>
Subject: Re: newbie question
To: "Tena Sakai" <sakaitena at yahoo.com>
Cc: macports-users at lists.macosforge.org
Date: Monday, May 2, 2011, 7:28 PM

Welcome to MacPorts!


On May 2, 2011, at 21:17, Tena Sakai wrote:

> I have two questions:
> (1) I see on a page 
>   http://www.macports.org/ports.php?by=category&substr=databases&page=3&pagesize=50
> that postgresql90 9.0.4 and postgresql90-server 9.0.4 are available.  Would
> someone please explain the difference between two?

postgresql90 is the PostgreSQL 9.0.x programs and libraries. If you just need to connect to an existing PostgreSQL server running elsewhere, this is what you want.

postgresql90-server performs the small bit of additional setup required if you want to run your own PostgreSQL server. You'll also need the programs and libraries in the postgresql90 port, which will automatically be installed if you ask to install postgresql90-server.


> (2) Say, I picked one of them, how do I go about installing it?  I am using
> snow leopard 10.6.7.

1. Install MacPorts
2. Open the Terminal (/Applications/Utilities/Terminal)
3. Type "sudo port install postgresql90" (without the quotes) and press return
4. If prompted for your password, type it and press return (nothing will be shown as you type)


Further information about using MacPorts is in the guide:

http://guide.macports.org/#using



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20110502/9805b59f/attachment.html>