Thread: Need PostgreSQL startup scripts

Need PostgreSQL startup scripts

From
Justin Clift
Date:
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

Re: Need PostgreSQL startup scripts

From
Peter Eisentraut
Date:
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@gmx.net       http://yi.org/peter-e/


Re: Need PostgreSQL startup scripts

From
Justin Clift
Date:
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@gmx.net       http://yi.org/peter-e/

Re: Need PostgreSQL startup scripts

From
Richard Huxton
Date:
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

Re: Need PostgreSQL startup scripts

From
will trillich
Date:
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@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

Re: Need PostgreSQL startup scripts

From
teg@redhat.com (Trond Eivind Glomsrød)
Date:
Justin Clift <jclift@iprimus.com.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.

Re: Need PostgreSQL startup scripts

From
Peter Eisentraut
Date:
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@gmx.net       http://yi.org/peter-e/


Re: Need PostgreSQL startup scripts

From
"Russell Hires"
Date:
I had the same problem with the start up script on debian myself. Rebooting
took care of it, though I'm not sure why. I wasn't able to just simply type
"/etc/init.d/postgresql start" and it start. I did a complete reboot and it
did start.

Russell

____________________________________________________
      "I don't care if you're going nowhere,
       Just take good care of the world."
                            -- Depeche Mode


----------
>From: teg@redhat.com (Trond Eivind
>To: Justin Clift <jclift@iprimus.com.au>
>Cc: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Need PostgreSQL startup scripts
>

> Justin Clift <jclift@iprimus.com.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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org