Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 28 May 1999 08:18:29 -0400 (EDT)
From:      Thomas Good <tomg@nrnet.org>
To:        David Kelly <dkelly@hiwaay.net>
Cc:        freebsd-questions@FreeBSD.ORG
Subject:   Re: Installing and Running PostgreSQL 
Message-ID:  <Pine.LNX.3.96.990528080654.11167A-100000@mailhost.nrnet.org>
In-Reply-To: <199905280156.UAA53656@nospam.hiwaay.net>

next in thread | previous in thread | raw e-mail | index | archive | help
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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.LNX.3.96.990528080654.11167A-100000>