[Babase] Hunter is creating user accounts -- Was: Fwd: Re: No postgresql on albertslab [thm@duke.edu]

Karl O. Pinc babase@www.eco.princeton.edu
Fri, 12 Nov 2004 14:06:17 -0600


--=_Qxx1br4bt0+wmk
Content-Type: text/plain; format=flowed; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

Hunter is making unix accounts as per Susan's
request.

I'll make database accounts for folks as soon as I get to
it.

I am no longer waiting on Hunter.

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein

--=_Qxx1br4bt0+wmk
Content-Type: message/rfc822; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: 8bit

Return-Path: <thm@duke.edu>
Delivered-To: kop@localhost.meme.com
Received: from localhost (localhost [127.0.0.1])
	by mofo.meme.com (Postfix) with ESMTP id B7F9A4361
	for <kop@localhost>; Fri, 12 Nov 2004 12:23:08 -0600 (CST)
Delivered-To: kop@66.93.114.26
Received: from 192.168.2.3 [192.168.2.3]
	by localhost with POP3 (fetchmail-5.9.0)
	for kop@localhost (single-drop); Fri, 12 Nov 2004 12:23:08 -0600 (CST)
Received: from pixie.artic.edu (pixie.artic.edu [198.40.30.132])
	by smtp.meme.com (Postfix) with ESMTP id 028231FE12
	for <kop@66.93.114.26>; Fri, 12 Nov 2004 12:16:16 -0600 (CST)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by pixie.artic.edu (Postfix) with ESMTP id A803939823F
	for <kop@66.93.114.26>; Fri, 12 Nov 2004 12:08:54 -0600 (CST)
Received: from eddings.acpub.duke.edu (eddings.acpub.duke.edu [152.3.233.76])
	by pixie.artic.edu (Postfix) with ESMTP id D27EF39819F
	for <kop@meme.com>; Fri, 12 Nov 2004 12:08:53 -0600 (CST)
Received: from [152.3.158.100] (user-152-3-158-100.wireless.duke.edu [152.3.158.100]) 
	by eddings.acpub.duke.edu (8.12.10/8.12.10/Duke-5.0.0) with ESMTP id iACI8qUM022297;
	Fri, 12 Nov 2004 13:08:52 -0500 (EST)
Subject: Re: No postgresql on albertslab
From: Hunter Matthews <thm@duke.edu>
To: "Karl O. Pinc" <kop@meme.com>
In-Reply-To: <20041112093343.C4328@mofo.meme.com>
References: <20041112093343.C4328@mofo.meme.com>
Content-Type: text/plain
Organization: Duke Biology
Message-Id: <1100282935.2844.28.camel@jade.biology.duke.edu>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) 
Date: Fri, 12 Nov 2004 13:08:55 -0500
Content-Transfer-Encoding: 7bit
X-UIDL: #]]"!b7k!!l4+!!-7K!!
X-Bogosity: No, tests=bogofilter, spamicity=0.000000, version=0.15.13
Status: RO
X-Status: A
Content-Length: 2121
Lines: 63

On Fri, 2004-11-12 at 10:33, Karl O. Pinc wrote:
>  From where should I get an rpm, or will you install it?
> (Niether up2date or apt-get works.)
> 
Duke uses yum

I don't want to hear any complaints about that - it wasn't MY doing.


> FYI, I'd prefer postgresql of at least 7.4, and for that matter
> it may as well be 8.0 just to not have to worry about upgrading
> later.  7.3 is a bit lacking, which is what you've got
> on synapse, but we can live with it if necessary.
> 
> Centos seems to have only postgresql 7.3.  :-(
> 
Thats what is installed at the moment. Our general policy is "you get
what is part of the standard distro".

I have already downloaded post 7.4 (from fc2) and will see about
rebuilding it. 

The general policy there is 'I will try, and a quick rebuild is sometime
possible- if that quick rebuild doesn't work, you have /usr/local/src'

I've installed postgres 7.3, httpd, turned both on, configured them to
store all their _data_ in /local, turned on the backups of /local, and
changed ownership to alblab.

To give your site a "face" I've done a partial copy of the lab web pages
to /local/www/.

Database:
   Config files and "raw" data is in /var/lib/pgsql/data
   Backups are in /local/database, done once per day.

Web: 
   Config files in /etc/httpd
   Data is in /local/www

Syslog:
   Stored in /local/syslog - let me know what perms if any need changing

Local installs:
   /usr/local is now a symlink to /local/usr_local (unfortunate name)

I went ahead and changed ownership of the web and /usr/local area, so no
sudo access is required there at all.


I'll get those other accounts created in a moment.
Please forward this to the other babase people - my email to the list
bounced.

> Karl <kop@meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                   -- Robert A. Heinlein
-- 
Hunter Matthews                          Unix / Network Administrator
Office: BioScience 145/244               Duke Univ. Biology Department
Key: F0F88438 / FFB5 34C0 B350 99A4 BB02  9779 A5DB 8B09 F0F8 8438
Never take candy from strangers. Especially on the internet.


--=_Qxx1br4bt0+wmk--