473,586 Members | 2,681 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

PGSQL on shared hosting

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
13 2304
> 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
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*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #3
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
-----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/vd2z1Xdt0HKSwgY RAjF8AJ96e80dD2 gNkvXHvJxLZgpNZ zCAuwCgkpnx
Dl4Ik0s7s69ElW5 ed/qILEM=
=oSjQ
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #5
Holger Klawitter <li***@klawitte r.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
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
Quoting Robert Treat <xz****@users.s ourceforge.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 administrativel y 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*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #8
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*******@postg resql.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
Quoting Robert Treat <xz****@users.s ourceforge.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*******@postg resql.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 YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 12 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
2710
by: Google Mike | last post by:
To my surprise last month, my dad wanted to start dabbling in PHP and MySQL or pgSQL. I've been helping him out a bit. He's into athletic medicine and wants to have a website to help athletes and physical therapists improve performance. His current web hosting provider -- Earthlink -- doesn't give him anything but PHP 3.0.x. I want to get him...
11
4183
by: Mike MacSween | last post by:
My client has an MS Access database application on her local machine. I have full access to that in terms of changing the design. I've got a simple PHP/MySql application on shared hosting, so no direct access to the db server. I'd like to give her the facility to export the information in her local Access application to the shared...
6
1475
by: Phil Howard | last post by:
I'm actually getting the mailing list mail, so I don't know what the deal is. Successful deliveries are coming from 64.117.225.209. But 207.173.200.206 has big problems. Sendmail is misconfigured in at least two ways. DNS is not even configured at all for reverse DNS. I can't whitelist the sender email addresses because spammers already...
11
2312
by: Daniel E. Fisher | last post by:
> I can't get a rest for a min guys. > > I go away for the weekend and my server is getting this error. > > Fatal error: Call to undefined function: pg_connect() in > /var/www/html/crohns/phpBB2/db/postgres7.php on line 79 Your PHP doesn't have support for PostgreSQL. Look at phpinfo();
0
1389
by: Chris Travers | last post by:
Hi all; This seems at least somewhat on-topic here, so at the risk of seeming shamelessly self-promoting, I figured I would ask. I am the main developer of an open source CRM suite (http://hermesweb.sourceforge.net). We are in the beta-testing of our 0.3.0 release which will include experimental support for shared hosting environments. ...
2
2544
by: Lee Harr | last post by:
I am following along with the pl/pgsql docs here: http://www.postgresql.org/docs/current/static/plpgsql-declarations.html In section 37.4.3. Row Types I have altered the function slightly (I finished the where ... clause) : CREATE or REPLACE FUNCTION use_two_tables(tablename) RETURNS text AS ' DECLARE in_t ALIAS FOR $1;
4
1814
by: Postgresql | last post by:
Hello, I am unable to get on many of the postgresql mailing lists. I usually get this message back with no attachment and no email comes afterwards with a confirmation. I've tried this over and over on multiple lists. After a while I was able to get on pgsql-admin...but it took a few tries. It's been a couple days now, so I'm assuming...
0
1903
by: Matt | last post by:
I need an installation with Postgres support, and was happy to find in my phpinfo that there was a --with-pgsql=shared option in the config line. but I still got "call to undefined function: pgsql_connect (4.3.11) So I figured whatev, I'll put a new installation (PHP5, in fact), but I always fail config with: Cannot find libpq-fe.h....
2
1945
by: Carl Gilbert | last post by:
Hi I feel as if I'm fighting a loosing battle with shared hosting at the moment. I have an account with 1&1. For a whopping £16.99 a month I get 6GB of shared Microsoft hosting. I also get the ability to have as many domains as I like, 5 web applications and large SQL databases. I'm currently experiencing some difficulties with a...
0
7839
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8202
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8338
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7959
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6614
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5710
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3837
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2345
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1449
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.