Re: Creating a db on my newly installed postresql on OS X

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Søren Krogh Neigaard <soeren(at)neigaard(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Creating a db on my newly installed postresql on OS X
Date: 2010-04-16 17:01:34
Message-ID: 11439.1271437294@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

=?iso-8859-1?Q?S=F8ren_Krogh_Neigaard?= <soeren(at)neigaard(dot)com> writes:
> Im totally new to postgresql. I installed 8.4.3 via MacPorts, and it told me to run this command to have postgresql start at boot:

> sudo launchctl load -w /Library/LaunchDaemons/org.macports.postgresql84-server.plist

> I can see with a ps command that there are something runing. So what next? I can read that I must use initdb to create a database, and give it a path to a file/directory where the data will be stored, but will the running postgresql server then know where this database/data is?

If the server is running, there must already be a valid data directory
for it to work in. I'm not familiar with the MacPorts package but it
seems likely that that daemon script ran initdb for you --- you could
look into the script to check.

> What are the next steps to get me up and running?

Try "psql postgres" and see what happens.

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Søren Krogh Neigaard 2010-04-16 18:21:12 Re: Creating a db on my newly installed postresql on OS X
Previous Message Søren Krogh Neigaard 2010-04-16 16:25:12 Creating a db on my newly installed postresql on OS X