newbie question
Tena Sakai
sakaitena at yahoo.com
Wed May 4 11:10:07 PDT 2011
Hi Bradley,
> Reading through this thread it is not clear that Tena installed the postgresql90-server.
> $ sudo port install postgresql90-server
I believe I did.
I issued:
$ sudo port install postgresql90-server
and it told me:
---> Installing postgresql90-server @9.0.4_0
To create a database instance, after install do
sudo mkdir -p /opt/local/var/db/postgresql90/defaultdb
sudo chown postgres:postgres /opt/local/var/db/postgresql90/defaultdb
sudo su postgres -c '/opt/local/lib/postgresql90/bin/initdb -D /opt/local/var/db/postgresql90/defaultdb'
To tweak your DBMS, consider increasing kern.sysv.shmmax by adding an increased kern.sysv.shmmax .. to /etc/sysctl.conf
---> Activating postgresql90-server @9.0.4_0
---> Cleaning postgresql90-server
Can you tel me why you think I didn't install it?
Thank you.
Tena
--- On Wed, 5/4/11, Bradley Giesbrecht <pixilla at macports.org> wrote:
From: Bradley Giesbrecht <pixilla at macports.org>
Subject: Re: newbie question
To: "Daniel J. Luke" <dluke at geeklair.net>
Cc: "Tena Sakai" <sakaitena at yahoo.com>, "MacPorts Users" <macports-users at lists.macosforge.org>
Date: Wednesday, May 4, 2011, 10:31 AM
On May 4, 2011, at 6:30 AM, Daniel J. Luke wrote:
> On May 3, 2011, at 9:27 PM, Tena Sakai wrote:
>>
>> When I try what you mention ("psql -U postgres postgres")
>> here's what happens:
>> $ /opt/local/lib/postgresql90/bin/psql -U postgres postgres
>> Password for user postgres:
>> psql: FATAL: password authentication failed for user "postgres"
>
> that's because you supplied an incorrect password for the postgres user.
>
>> I gave "trust" as you suggested.
>
> nope, I suggested that the default authentication method (as set in your pg_hba.conf file) was 'trust' authentication which does not require a password.
>
>> Clearly the account postgres exists. (Because I can su to it
>> from being root.)
>
> you are confusing a system level postgres account with a database postgres account/user
>
>> But on this incarnation of the OS (snow
>> leopard, 10.6.7), one is supposed to manage password
>> changes via Accounts (in System Preferences). And
>> according to Accounts, there is no such user as postgres.
>> Curiously, it does show the group postgres.
>
> the Accounts pane in system preferences doesn't show all system accounts.
>
>> I have looked at the passwd file via vipw and postgres doesn't
>> exist in it. So, where is the account postgres?
>
> on Mac OS X, system accounts (and passwords) are not stored in the passwd file.
>
>> Here's something else kinda strange:
>> $ echo ~postgres
>> /Applications/postgres
>> $ ls -ld /Applications/postgres
>> ls: /Applications/postgres: No such file or directory
>
> that doesn't really matter (although it probably means your postgres user wasn't created by macports, as the postgres90-server port creates the postgres user with a $HOME of ${prefix}/var/db/postgresql90)
Reading through this thread it is not clear that Tena installed the postgresql90-server.
$ sudo port install postgresql90-server
Regards,
Bradley Giesbrecht (pixilla)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20110504/d3173011/attachment.html>
More information about the macports-users
mailing list