From owner-freebsd-ports@FreeBSD.ORG Wed Jan 23 03:25:58 2013 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.FreeBSD.org [8.8.178.115]) by hub.freebsd.org (Postfix) with ESMTP id EAE8AFD3 for ; Wed, 23 Jan 2013 03:25:58 +0000 (UTC) (envelope-from FreeBSD@shaneware.biz) Received: from ipmail04.adl6.internode.on.net (ipmail04.adl6.internode.on.net [IPv6:2001:44b8:8060:ff02:300:1:6:4]) by mx1.freebsd.org (Postfix) with ESMTP id 5B3E6711 for ; Wed, 23 Jan 2013 03:25:58 +0000 (UTC) Received: from ppp247-71.static.internode.on.net (HELO leader.local) ([203.122.247.71]) by ipmail04.adl6.internode.on.net with ESMTP; 23 Jan 2013 13:55:55 +1030 Message-ID: <50FF57F2.8030205@ShaneWare.Biz> Date: Wed, 23 Jan 2013 13:54:34 +1030 From: Shane Ambler User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:17.0) Gecko/17.0 Thunderbird/17.0 MIME-Version: 1.0 To: Owen O' Shaughnessy Subject: Re: FreeBSD 9.1 & Postgresql References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-ports@freebsd.org X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 23 Jan 2013 03:25:59 -0000 On 23/01/2013 05:30, Owen O' Shaughnessy wrote: > Hi Guys, > > Wondering if anybody else has tried installing Postgres from > packages? > > I have used pkg_add -r to install postgresql-server and > postgresql-client, both installed sucessfully, I've got server and > client binaries and libraries but no configuration files for the > server. > > Does the package assume it is an upgrade, or is there another package > that you install to get the configuration files and initscripts? > > I was expecting to find: /usr/local/etc/rc.d/postgresql I was > expecting a binary somewhere on the system called initdb > What you are after should be installed as part of the server package. Sure you didn't get the client only? initdb should be in /usr/local/bin with postgres and postmaster. The postgresql.conf file will be inside the data dir after initdb is run. /usr/local/etc/rc.d/postgresql should exist and contain info on adding settings to /etc/rc.conf Of course if you happen to have $PREFIX set to something other than /usr/local things may have ended up elsewhere. (not sure if that effects packages or just port builds)