Skip to Content.
Sympa Menu

sm-grimoire - Re: [SM-Grimoire] postgresql startup

sm-grimoire AT lists.ibiblio.org

Subject: Discussion of Spells and Grimoire items

List archive

Chronological Thread  
  • From: Seth Woolley <seth AT tautology.org>
  • To: Pierre Abbat <phma AT webjockey.net>
  • Cc: Source Mage - Grimoire <sm-grimoire AT lists.ibiblio.org>
  • Subject: Re: [SM-Grimoire] postgresql startup
  • Date: Fri, 3 Jan 2003 08:27:57 -0800 (PST)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

you know: secure by default!

here's one that doesn't use functions if you need something quick.

change -D to wherever you put your data, etc.

This one works fine for me as a quick hack when I realized the same
thing you did.

Anybody want to touch up for the function/evaluate_retval stuff and submit
it?

There's other stuff that needs to happen, too. like database creation if
it doesn't already exist, and the postgresql spell needs a way to upgrade
seamlessly (as possible) on updates. Going between 7.2.x-7.3.x versions
can be a pain as I have to hold the spell while I dump, unhold, update,
restore, hold, etc. If the spell knew how to do all that during install
it would be pretty easy (now I haven't checked the spell to see if it does
that already, so don't sue me if it does).

#!/bin/sh

case $1 in
start|restart) echo "$1ing postgresql postmaster."
pkill "^postmaster$"
su postgres -c '/usr/bin/postmaster -D
/home/postgres/data' &
;;
stop) echo "$1ing postgresql postmaster."
pkill "^postmaster$"
;;
*) echo "Usage: $0 {start|stop|restart}"
;;
esac

On Fri, 3 Jan 2003, Pierre Abbat wrote:

> How come the postgresql spell doesn't install a startup script?
>
> phma
> _______________________________________________
> SM-Grimoire mailing list
> SM-Grimoire AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/sm-grimoire
>

- --
Seth Alan Woolley <seth at tautology.org>, SPAM/UCE is unauthorized
Key id 7BEACC7D = 2978 0BD1 BA48 B671 C1EB 93F7 EDF4 3CDF 7BEA CC7D
Full Key at seth.tautology.org, see www.gnupg.org www.keyserver.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.0 (FreeBSD)

iD8DBQE+FboP7fQ833vqzH0RAoJJAKDQMeaoiHVfi9bdFuaCDpt0wRP86gCgpPLQ
4CIyLXH/gS3LotCrte3Wnbk=
=GBdu
-----END PGP SIGNATURE-----





Archive powered by MHonArc 2.6.24.

Top of Page