Thread: Postgresql Hosting
I have asked my internet host to include postgresql as part of their service but it seems that there are issues in getting it to work with "cpanel" which is their support service for their clients. Is their a reason why Postgresql is harder to host than mysql? Is their any docs I can point the server admin to that would help him? If not what service providers are people recommending? thanks Richard
On Fri, 5 Aug 2005, Richard Sydney-Smith wrote: > I have asked my internet host to include postgresql as part of their > service but it seems that there are issues in getting it to work with > "cpanel" which is their support service for their clients. Is their a > reason why Postgresql is harder to hostthan mysql? Is their any docs I > can point the server admin to that would help him? > > If not what service providers are people recommending? > > thanks > > Richard > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > If you're talking about cpanel.net then postgresql is supported by default. --------------------------------------------------- Emilian Ursu http://www.emuadmin.com
On Aug 4, 2005, at 10:28 PM, Richard Sydney-Smith wrote: > I have asked my internet host to include postgresql as part of > their service but it seems that there are issues in getting it to > work with "cpanel" which is their support service for their > clients. Is their a reason why Postgresql is harder to host than > mysql? Is their any docs I can point the server admin to that would > help him? > > If not what service providers are people recommending? I'm a satisfied customer of http://www.a2hosting.com. They use cpanel, so I'm not sure what the problem is. And the only thing you use cpanel for is to create users and databases. Otherwise you use phpPgAdmin (or psql if your account has shell access). John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
Thanks , Would seem there is no problem eith cpanel + postgresql. thanks for the link to a2hosting I will look them up. John DeSoi wrote: > > On Aug 4, 2005, at 10:28 PM, Richard Sydney-Smith wrote: > >> I have asked my internet host to include postgresql as part of their >> service but it seems that there are issues in getting it to work >> with "cpanel" which is their support service for their clients. Is >> their a reason why Postgresql is harder to host than mysql? Is their >> any docs I can point the server admin to that would help him? >> >> If not what service providers are people recommending? > > > > I'm a satisfied customer of http://www.a2hosting.com. They use > cpanel, so I'm not sure what the problem is. And the only thing you > use cpanel for is to create users and databases. Otherwise you use > phpPgAdmin (or psql if your account has shell access). > > > > John DeSoi, Ph.D. > http://pgedit.com/ > Power Tools for PostgreSQL > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > >
On 8/4/2005 10:28 PM, Richard Sydney-Smith wrote: > I have asked my internet host to include postgresql as part of their > service but it seems that there are issues in getting it to work with > "cpanel" which is their support service for their clients. Is their a > reason why Postgresql is harder to host than mysql? Is their any docs I > can point the server admin to that would help him? > > If not what service providers are people recommending? http://cwihosting.com/ Apache with Frontpage extensions (if you want them), PHP, PostgreSQL and ssh access including crontab support. Having pl/pgsql added to template1 was done in no time. I only had to put a binary cvs executable there so that I can develop somewhere else and deploy the changes via cvs update. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #
> http://cwihosting.com/ > > Apache with Frontpage extensions (if you want them), PHP, PostgreSQL and > ssh access including crontab support. Having pl/pgsql added to template1 > was done in no time. I only had to put a binary cvs executable there so > that I can develop somewhere else and deploy the changes via cvs update. If you need business class hosting I suggest Command Prompt (I work for them). Our hosting is PostgreSQL only so... http://www.commandprompt.com/ There is also Hub.org if you want FreeBSD/PostgreSQL hosting. Sincerely, Joshua D. Drake > > > Jan > -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
On Thu, 8 Sep 2005, Joshua D. Drake wrote: > >> http://cwihosting.com/ >> >> Apache with Frontpage extensions (if you want them), PHP, PostgreSQL and >> ssh access including crontab support. Having pl/pgsql added to template1 >> was done in no time. I only had to put a binary cvs executable there so >> that I can develop somewhere else and deploy the changes via cvs update. > > If you need business class hosting I suggest Command Prompt (I work for > them). Our hosting is PostgreSQL only so... > > http://www.commandprompt.com/ > > There is also Hub.org if you want FreeBSD/PostgreSQL hosting. http://www.hub.org/standard_features.php We host *everything* that nobody else wants to ... and give you full root access to add more if you need ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
We offer Postgresql hosting with phpPgAdmin on Mac Dual G5 Xserve servers:
http://www.systame.com/html/macwebhosting/
--
Randall Perry
sysTame
Xserve Web Hosting/Co-location/Leasing
QuickTime Streaming
Mac Consulting/Sales
http://www.systame.com/
Various people wrote: >>> ...PostgreSQL...crontab support...pl/pgsql I've found that with if you can get 5 companies/users to share a dedicated server you can be much better off than a hosting plan, and have full control over the services you run. I'm sharing with 5 other small businesses a dedicated server with 60GB hard drive, 700GB monthly bandwidth on a 10Mbps link for $49/month. This works out to $10/month for each us for 10GB hard drive and 100GB transfer (quotas we set for ourselves with some overhead for the OS). So far I haven't seen any hosted plan offering anything competitive with that. The best part is that we can run whatever we want. I needed postgis; so I ran a separate postgresql install for a while on a different port until it was stable before upgrading the rest of the guys. One of the guys had wierder needs, so he ran his own user-mode linux.
On Sep 9, 2005, at 7:21 PM, Ron Mayer wrote: > I've found that with if you can get 5 companies/users to share a > dedicated server you can be much better off than a hosting plan, > and have full control over the services you run. I'm sure the numbers work out, but it sounds like being in a Band. Granted, companies and geeks aren't as flaky as Bass players, but you still probably have to pick good people to partner with or else it ends up being a big headache and sometimes even a wallet drain.
On Sep 9, 2005, at 8:02 PM, Matthew Terenzio wrote: > > On Sep 9, 2005, at 7:54 PM, Scott Marlowe wrote: > >> On Fri, 2005-09-09 at 18:35, Matthew Terenzio wrote: >>> On Sep 9, 2005, at 7:21 PM, Ron Mayer wrote: >>> >>>> I've found that with if you can get 5 companies/users to share a >>>> dedicated server you can be much better off than a hosting plan, >>>> and have full control over the services you run. >>> >>> >>> I'm sure the numbers work out, but it sounds like being in a Band. >>> Granted, companies and geeks aren't as flaky as Bass players, but you >>> still probably have to pick good people to partner with or else it >>> ends >>> up being a big headache and sometimes even a wallet drain. >> >> Otherwise, somebody's tone deaf boyfriend or girlfriend will want to >> sing (i.e. sysadmin)... And then it's just a downward spiral from >> there. >> Exactly, or maybe someone decides they want to cover some cheesy pop song (MS FrontPage extensions) and then your on stage with your pants down.
On Fri, Sep 09, 2005 at 16:21:42 -0700, Ron Mayer <rm_pg@cheapcomplexdevices.com> wrote: > Various people wrote: > >>>...PostgreSQL...crontab support...pl/pgsql > > I've found that with if you can get 5 companies/users to share a > dedicated server you can be much better off than a hosting plan, > and have full control over the services you run. > > I'm sharing with 5 other small businesses a dedicated server with 60GB > hard drive, 700GB monthly bandwidth on a 10Mbps link for $49/month. > > This works out to $10/month for each us for 10GB hard drive > and 100GB transfer (quotas we set for ourselves with some > overhead for the OS). > > So far I haven't seen any hosted plan offering anything > competitive with that. This seems penny wise and pound foolish. The cost of the remote hosting is going to be swamped by whatever you are paying somneone to keep an eye on it. The savings for sharing the host, aren't going to make up for any hassels involved in sharing the host.
>This seems penny wise and pound foolish. The cost of the remote hosting is >going to be swamped by whatever you are paying somneone to keep an eye on it. >The savings for sharing the host, aren't going to make up for any hassels >involved in sharing the host. > > That depends, if they went with a Managed service it would work well but then again a managed service is going to be at least 200 bucks a month. Personally I think that a lot of people look at hosting the wrong way. It is one thing if you are just hosting some of your kids photos or a personal website to use as a Soap Box. If you are running a business you should be using a business class service. A business class service costs more than 49.00 a month (unless it is shared). A business class service would never allow you to have only one hard drive (and thus no redundancy). At least if you are doing normal shared hosting at 49.00 bucks a month you can reasonably expect that you are sitting on some level of RAID, that backups are being done, root kit checks etc... Yes I am biased because we sell such as service but we are not the only ones out there that do it and we started the service after watching so many people making such a horrible mistake with their revenue source. Sincerely, Josua D. Drake >---------------------------(end of broadcast)--------------------------- >TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
> I'm sharing with 5 other small businesses a dedicated server with 60GB
> hard drive, 700GB monthly bandwidth on a 10Mbps link for $49/month.
Where is this available?
The web host that I do programming for pays around $120 a month for a
Debian machine with an AMD Athlon 2200 Processor, 1GB Memory, an 80 GB
Hard Drive, 2000 GB Bandwidth at serverbeach.com. But it's not backedup,
etc. If the machine fails, they'll reload the operating system and turn
it back over to us to get going again. I keep it backed up with rsync to
other machines - which means if it does fail I'm in for an unscheduled few
days of restoration.
It's definitely much faster than the shared hosting we have other websites
on. Both of the websites in my sig below are on it, both use postgreSQL
(but they are really small databases - the biggest table is around 10,000
rows).
I'm just wondering what $49/month buys?
brew
==========================================================================
Strange Brew (brew@theMode.com)
Check out my Stock Option Covered Call website http://www.callpix.com
and my Musician's Online Database Exchange http://www.TheMode.com
==========================================================================
>> I'm sharing with 5 other small businesses a dedicated server with 60GB >> hard drive, 700GB monthly bandwidth on a 10Mbps link for $49/month. > > Where is this available? Not quite that package and I've never used them (thinking about it), but layeredtech.com has this as their cheapest: . Intel Celeron 2.0GHz . 80GB IDE Hard Drive . 512MB RAM . Bandwidth: 1000GB . IP Addresses: 8 (5 usable) . Private VLAN . Basic Resource Monitoring . FreeBSD, OpenBSD, Linux, Windows* . 100% Self Managed and Dedicated Monthly Fee Options: . $65 | $19 Setup (backup is extra...) If you click on their gaming server section (why they call it that I don't know) there's some 1gb, 36gb scsi configs for $90ish. Totally unmanaged, etc.. yadda yadda....
brew@theMode.com wrote: >>I'm sharing with 5 other small businesses a dedicated server with 60GB >>hard drive, 700GB monthly bandwidth on a 10Mbps link for $49/month. > > Where is this available? server4you.net offers such a system today (they claim to be the largest dedicated server host with 6500 dedicated servers and hundreds of thousands of shared servers); and I've seen ev1.net offer similar packages for the same price before. > The web host that I do programming for pays around $120 a month for a > Debian machine with an AMD Athlon 2200 Processor, 1GB Memory, an 80 GB > Hard Drive, 2000 GB Bandwidth at serverbeach.com. But it's not backedup, > etc. If the machine fails, they'll reload the operating system and turn > it back over to us to get going again. I keep it backed up with rsync to > other machines - which means if it does fail I'm in for an unscheduled few > days of restoration. We've got pretty much the same backup strategy. Our hosting place does offer backup services too for an additional fee; but we feel better having the backup in our own facilities. Though now we're drifting pretty far off topic so I'd happily continue discussing via email.