Re: PGSQL on shared hosting

Quoting Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>:

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>

An even more basic question is what is the hosters policy on users running their
own servers.

I've got clients that do but only after they are granted permission to do so.
Having clients run they own servers as administratively not a good idea since
thing can very quick get our of control if you don't know what is running.
'Course these days you can tune your kernel and shell parameters to minimize
that. Still, I would ask first to see if maybe they'll install it system-wide
first...

<shameless-plug>

As previously mentioned you could just go with an ISP that has already been
running PostgreSQL for some time. I've notice quite a few service providers on
the list. Some are probably listed on techdocs but I noticed my entry hasn't
shown up yet.

</shameless-plug>

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com