Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group