By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,178 Members | 987 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,178 IT Pros & Developers. It's quick & easy.

PGSQL on shared hosting

P: n/a
hello,

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.

thanks!
..ep

__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #1
Share this Question
Share on Google+
13 Replies


P: n/a
> 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.

Your best chance is to find a shared hosting which offers PostgreSQL
rather than MySQL. There are some. Not many, but some...

Good luck.

---------------
Francois

Home page: http://www.monpetitcoin.com/

"Would Descartes have programmed in Pascal?" - Umberto Eco
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #2

P: n/a
Hiya,

Without wanting to get flamed for gratuitous advertising, my company
offers shared hosting with PostgreSQL 7.4. I'll leave it at that.

Apologies in advance to anyone I've offended.

Regards

Tony.

Francois Suter wrote:
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.

Your best chance is to find a shared hosting which offers PostgreSQL
rather than MySQL. There are some. Not many, but some...

Good luck.

---------------
Francois

Home page: http://www.monpetitcoin.com/

"Would Descartes have programmed in Pascal?" - Umberto Eco
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #3

P: n/a
rob
> Without wanting to get flamed for gratuitous advertising, my company
offers shared hosting with PostgreSQL 7.4. I'll leave it at that.


Just to make it fair I'll say ditto, then ;)
No. The "make install" step requires a root access.


That's not true, so long as your ./configure --prefix has been set to a
user writeable directory.

The only other issue is which PORT you run it on, and this depends on
the implementation of shared hosting your provider supplies.

As IIRC the port number influences shared memory segement use and you
don't want to clash with another instance on the shared server.

Something you don't have to worry about if your provider uses the
context patch, *ahem*.

Cheers,

--
Rob Fielding
ro*@dsvr.net
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #4

P: n/a
-----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 easilyat
boot time.

Mit freundlichem Gruß / With kind regards
Holger Klawitter
- --
in**@klawitter.de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/vd2z1Xdt0HKSwgYRAjF8AJ96e80dD2gNkvXHvJxLZgpNZzCAuw Cgkpnx
Dl4Ik0s7s69ElW5ed/qILEM=
=oSjQ
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #5

P: n/a
Holger Klawitter <li***@klawitter.de> writes:
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.


Correct. AFAIK, you have to be root to set up any init-script action.

You can easily build, install, and run PG in a personal directory
(I do that all the time for testing purposes) but you couldn't really
use it as a full-time server because it'd need to be manually restarted
after any system reboot.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #6

P: n/a
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

Nov 12 '05 #7

P: n/a
Quoting Robert Treat <xz****@users.sourceforge.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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #8

P: n/a
On Fri, 2003-11-21 at 11:20, Keith C. Perry wrote:
<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>


<raised eyebrow>
where/when did you send in your update? given that there are several
people dedicated to deprecating the current implementation i know that
maintenance has been slacking, but occasionally I update this
information when I get a chance. Can you send your info to
we*******@postgresql.org?

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #9

P: n/a
Quoting Robert Treat <xz****@users.sourceforge.net>:
On Fri, 2003-11-21 at 11:20, Keith C. Perry wrote:
<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>


<raised eyebrow>
where/when did you send in your update? given that there are several
people dedicated to deprecating the current implementation i know that
maintenance has been slacking, but occasionally I update this
information when I get a chance. Can you send your info to
we*******@postgresql.org?

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


Robert,

I think it was about a month ago but I don't remember. I'll forward you the
original email.

--
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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #10

P: n/a
On Fri, Nov 21, 2003 at 10:16:56AM -0500, Tom Lane wrote:
Correct. AFAIK, you have to be root to set up any init-script action.

You can easily build, install, and run PG in a personal directory
(I do that all the time for testing purposes) but you couldn't really
use it as a full-time server because it'd need to be manually restarted
after any system reboot.
For the record, at least linux cron has an @reboot tag, defined as:

@reboot Run once, at startup.

Which should be what you want for an init script.

--
Martijn van Oosterhout <kl*****@svana.org> http://svana.org/kleptog/ "All that is needed for the forces of evil to triumph is for enough good
men to do nothing." - Edmond Burke
"The penalty good people pay for not being interested in politics is to be
governed by people worse than themselves." - Plato


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE/vp3GY5Twig3Ge+YRAgKkAKCcycukzIaeopgtToxdN/fwzBvRBACdEUCP
6cOGuarQJE4vi2wtTu39YhI=
=k94J
-----END PGP SIGNATURE-----

Nov 12 '05 #11

P: n/a
Thanks Tom. I don't mind having to start it again and again at server
reboots, as I only intend to use it for testing for now.

So how can I execute it inside my own folder? Do I need to give any
special commands? Is there any FAQ for this?

Thanks,
Erick

__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #12

P: n/a
Erick Papadakis <er*************@yahoo.com> writes:
So how can I execute it inside my own folder? Do I need to give any
special commands? Is there any FAQ for this?


I think the other respondents already gave you the needed clues:
configure with --prefix set to someplace in your own directory tree,
and select a PGDATA directory under your own tree as well.

I'm also in the habit of selecting a default port that's not standard
(not 5432), so that there won't be a port conflict if the machine's
owner someday decides to install PG as standard.

In short, something like

../configure --with-pgport=5434 --prefix=/home/tgl/version74

(plus any other configure options you like) and then

export PGDATA=/home/tgl/version74/data

before running initdb or starting the postmaster.

If you do it exactly as above then you'll also need to add
/home/tgl/version74/bin to your PATH so that you can invoke psql and
other utilities conveniently. I think you can also fool with
configure's more-detailed prefix options if you have an existing
personal bin directory that you'd rather put psql into.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #13

P: n/a
On Fri, Nov 21, 2003 at 12:30:32AM -0800, Erick Papadakis wrote:
hello,

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.


Yes. We do it all the time. You'll need to configure with --prefix
set to something you have write access to. You may need your
provider to install a symlink to init scripts for you if you want
automatic start up, and you may need to have your provider make some
kernel setting changes, but that's about it.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<an****@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #14

This discussion thread is closed

Replies have been disabled for this discussion.