Re: PGSQL on shared hosting - Mailing list pgsql-general

From Robert Treat
Subject Re: PGSQL on shared hosting
Date
Msg-id 1069429047.10323.12622.camel@camel
Whole thread Raw
In response to Re: PGSQL on shared hosting  (Holger Klawitter <lists@klawitter.de>)
Responses Re: PGSQL on shared hosting
List pgsql-general
On Fri, 2003-11-21 at 04:41, Holger Klawitter wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Am Friday 21 November 2003 09:49 schrieben Sie:
> > > i am a newbie to the pgsql world, so pls bear with a possibly stupid
> > > question. i want to test out pgsql but i only have a shared hosting
> > > account. is it possible to install pgsql without root access, only for
> > > my
> > > account? my webhost uses redhat i think.
> >
> > No. The "make install" step requires a root access.
>
> Wrong! If you install into a writeable directory e.g.
>   ./configure --prefix=/home/user/postgres
> make install will work just fine (or at least it did with me).
>
> The only problem is that you cannot start postgres automatially that easily at
> boot time.
>

A bit hackey, but you could write a cronjob to check for postmaster.pid
every few minutes and start postmaster if it does not exist. (assumes
your provider gives you cron access along with those software compiling
privileges). this wouldnt give you an at boot time start, but at least a
shortly after boot time start. you'd need to make that script behave
properly after system crash too.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Concurrent testing PostgreSQL Vs MySQL
Next
From: Bruno Wolff III
Date:
Subject: Re: linking postgre to AD