From owner-freebsd-questions Fri May 28 6:57:12 1999 Delivered-To: freebsd-questions@freebsd.org Received: from mail2.panix.com (mail2.panix.com [166.84.0.213]) by hub.freebsd.org (Postfix) with ESMTP id AD97A14BE9 for ; Fri, 28 May 1999 06:57:10 -0700 (PDT) (envelope-from tomg@nrnet.org) Received: from mailhost.nrnet.org (root@mailhost.nrnet.org [166.84.192.39]) by mail2.panix.com (8.8.8/8.8.8/PanixM1.3) with ESMTP id JAA28946; Fri, 28 May 1999 09:57:07 -0400 (EDT) Received: from localhost (tomg@localhost) by mailhost.nrnet.org (8.8.7/8.8.4) with SMTP id IAA11220; Fri, 28 May 1999 08:18:29 -0400 Date: Fri, 28 May 1999 08:18:29 -0400 (EDT) From: Thomas Good To: David Kelly Cc: freebsd-questions@FreeBSD.ORG Subject: Re: Installing and Running PostgreSQL In-Reply-To: <199905280156.UAA53656@nospam.hiwaay.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Thu, 27 May 1999, David Kelly wrote: > Thomas Good writes: > > Now can we get PG binaries online somewhere?! ;-) > > Thought I'd try it. This is how one makes a binary package out of a > port: > > % cd /ports/databases/postgresql/ > % make USE_TCL=yes package > ===> postgresql-6.4.2 may not be packaged: Requires pgsql uid. > % > > Apparently it blows up because the package system does not yet support > the creation/addition of new user id's. Or maybe there is some good > reason a package can not create a user account? David - what about a shell script that does the same thing? When I cp'd the binaries from my production box to my laptop I did this: 1) tar the /usr/local/pgsql dir tree as root 2) unpack the tarball 3) useradd postgres 4) chown -R postgres.(group) /usr/local/pgsql 5) update ld conf... 6) add env vars to /etc/profile 7) login as postgres, initdb 8) as postgres, fire up the server 9) createuser... If the binaries were available with a shell script or a brief doc it would be easy enough to setup. I do this with Slackware and PostgreSQL.org offers Solaris binaries... God knows I wish I had had binaries for my UnixWare box. That was an ordeal to get going. By comparison, FreeBSD was cake. Tom ---- North Richmond Community Mental Health Center Thomas Good Information Systems Coordinator E-Mail: tomg@ { admin | q8 } .nrnet.org Phone: 718-354-5528 Fax: 718-354-5056 Empowered by PostgreSQL 6.3.2 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message