Re: Need PostgreSQL startup scripts

Hi all,

If anybody has a minute or two, can they please email me the startup
script they use on their system to automatically start PostgreSQL when
the system boots?

I have a Linux Mandrake 7.2 startup script for PostgreSQL 7.0.3 on the
techdocs.postgresql.org site, and I'm looking for startup scripts for
other OS's. Startup scripts that are SANE of course.

From what I understand of Debian, it uses a different method of starting
up than Mandrake, so I'd appreciate a copy of the Debian startup script
especially.

Regards and best wishes,

Justin Clift

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

Oops.

Thanks Peter, I hadn't thought of checking there.

Now that I know you are already addressing this, I'm not sure they need
to be on the techdocs site. I don't think we should have too much
duplication and therefore wasted effort.

Do you think it would be better to remove the startup scripts section
from the techdocs site, or leave it there?

Regards and best wishes,

Justin Clift

Peter Eisentraut wrote:
>
> Justin Clift writes:
>
> > If anybody has a minute or two, can they please email me the startup
> > script they use on their system to automatically start PostgreSQL when
> > the system boots?
>
> I've started collecting some in contrib/start-scripts.
>
> --
> Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/

Justin Clift writes:

> If anybody has a minute or two, can they please email me the startup
> script they use on their system to automatically start PostgreSQL when
> the system boots?

I've started collecting some in contrib/start-scripts.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/

Justin Clift wrote:
>
> Oops.
>
> Thanks Peter, I hadn't thought of checking there.
>
> Now that I know you are already addressing this, I'm not sure they need
> to be on the techdocs site. I don't think we should have too much
> duplication and therefore wasted effort.
>
> Do you think it would be better to remove the startup scripts section
> from the techdocs site, or leave it there?

It wouldn't hurt to leave a note mentioning the fact that they're there
- it was ages before I noticed that the contrib directory existed at
all, and I still tend to miss when new stuff is introduced.

- Richard Huxton

On Sun, Apr 01, 2001 at 01:13:21PM +1000, Justin Clift wrote:
> If anybody has a minute or two, can they please email me the startup
> script they use on their system to automatically start PostgreSQL when
> the system boots?
>
> I have a Linux Mandrake 7.2 startup script for PostgreSQL 7.0.3 on the
> techdocs.postgresql.org site, and I'm looking for startup scripts for
> other OS's. Startup scripts that are SANE of course.
>
> From what I understand of Debian, it uses a different method of starting
> up than Mandrake, so I'd appreciate a copy of the Debian startup script
> especially.

when i do an

apt-get install postgresql

on my debian potato (2.2) system, it creates the

/etc/init.d/postgresql

script which can be called via symlink from any of the
/etc/rc*.d/S??* startup scripts to match your runlevels (where
rc3.d would be for runlevel 3).

so in theory, it should just 'come with the meat' and simply work
out-of-the-box. if not, you can try

/etc/init.d/postgresql start

(as root) toget it going by hand, and then check

man update-rc.d

to see how to use the debian way to install runlevel-specific
hooks to get postgresql going.

--
does a brain cell think?

will(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

Justin Clift <jclift(at)iprimus(dot)com(dot)au> writes:

> If anybody has a minute or two, can they please email me the startup
> script they use on their system to automatically start PostgreSQL when
> the system boots?

Look at the one in Red Hat Linux - Lamar and I've both contributed to
it, and I would believe Mandrake just has an older copy of it.

--
Trond Eivind Glomsrød
Red Hat, Inc.

Justin Clift writes:

> Now that I know you are already addressing this, I'm not sure they need
> to be on the techdocs site. I don't think we should have too much
> duplication and therefore wasted effort.
>
> Do you think it would be better to remove the startup scripts section
> from the techdocs site, or leave it there?

Feel free to keep them there. Maybe it's better to track them on the web,
since distributions change so often. The ones in contrib are more "proof
of concept" types anyway.

Once we have a large collection of scripts we can perhaps consolidate them
and make a few of them official.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/