From owner-freebsd-questions@FreeBSD.ORG  Mon Nov 22 22:28:21 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 019FB16A4CE
	for <questions@freebsd.org>; Mon, 22 Nov 2004 22:28:21 +0000 (GMT)
Received: from relay03.pair.com (relay03.pair.com [209.68.5.17])
	by mx1.FreeBSD.org (Postfix) with SMTP id 4A19643D2F
	for <questions@freebsd.org>; Mon, 22 Nov 2004 22:28:20 +0000 (GMT)
	(envelope-from ryan@confabulator.net)
Received: (qmail 95392 invoked from network); 22 Nov 2004 22:28:19 -0000
Received: from unknown (HELO ?192.168.0.83?) (unknown)
  by unknown with SMTP; 22 Nov 2004 22:28:19 -0000
X-pair-Authenticated: 209.197.24.213
Message-ID: <41A2840D.9020104@confabulator.net>
Date: Mon, 22 Nov 2004 16:27:57 -0800
From: "Ryan J. Cavicchioni" <ryan@confabulator.net>
User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: questions@freebsd.org
References: <41A24148.1000400@schmittnet.com>
In-Reply-To: <41A24148.1000400@schmittnet.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: Setting up Postfix with PosgreSQLon FreeBSD
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 22 Nov 2004 22:28:21 -0000

Bill,

These instructions have always worked for me: 
http://www.postgresql.org/docs/7.2/static/installation.html

The important thing is to make sure you use gmake when compiling.

Here is a quick install that I modified to work on BSD:

./configure
gmake
su
gmake install
pw useradd postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test

I hope that this helps.

Regards,
Ryan

Bill Schmitt (SW) wrote:

> I've been trying to find some documentation on setting up Postfix to 
> use PostgreSQL on FreeBSD. There seems to be a lot of documentation on 
> doing it with mySQL, but I can't seem to find anything using 
> PostgreSQL. Does anyone here have any documentation, suggestions, or 
> pointers to web sites? I'm working with FBSD 4.9, PostgreSQL 7.2, and 
> Postfix 2.15.
>
> TIA,
>
> Bill
>
>
> _______________________________________________
> freebsd-questions@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to 
> "freebsd-questions-unsubscribe@freebsd.org"