PostgreSQL, Big Disk, Modest Bandwidth
Aug 2, 2008
I saw the note about Request threads, but I've had no luck with the requester form or sponsors and my requirements are perhaps a little uncommon. I just opened an account with a certain host only to find that the inode thing will be an issue, so already searching for a new place. Recommendations?
I'm flexible on pricing.. up to $20 / month?
My sites:
3x domains
3x Gallery2 installs
20Gb total (~ 70k inodes)
REQUIREMENTS:
PostgreSQL *
PHP 5
30Gb storage (and no harsh inode limit)
5-20Gb traffic (typically closer to 1Gb, if that)
SSH & rsync
PREFERABLE:
PostgreSQL 8.x (many times faster than 7.x)
PHP 5.2.3+ (supports phpdoctrine)
Proper domain management (ability to add arbitrary records)
View 3 Replies
ADVERTISEMENT
Dec 20, 2008
I just moved to my new server and I have noticed a problem with the mail server.
The mail doesn't send unless I press "Send Mail Queue" inside WHM.
Does any one know if there is a cron-job for me to run?
Also, for all of my clients it is showing 0mb disk usage, how would I fix it to show their real disk usage and bandwidth usage? I believe that there is again, a cron-job to run.
View 3 Replies
View Related
Aug 28, 2008
OK so I've been in the hosting industry a very long time now and I have noticed that overselling has got more and more crazy over time. 7 years ago, 2GB of disk and 10GB bandwidth was considered overselling. Today, its common to see offers at 1000GB/1000TB.
So my question, to all you looking for web hosting, do you really think you will need all that space and bandwidth?
I'm going to let you in on a little secret. (Some might hate me for this!) Out of all my customers, 99% use less than 1GB disk and 5GB transfer.
Every hosting provider out there knows this, and will tack on a bunch of 0s to their offer to make it look more enticing . The thing is, if you aren't using the space, you aren't getting any extra value. If you come even close to the amount they offer, I am willing to bet you will be suspended faster than you can blink. This advertising tactic is very misleading and a lot of newcomers base their decision off the meaningless numbers they see. <<Snip>>
Bloggers - Think again if you believe you need anything more than 1GB of space. You could type blog posts until you are blue in the face before you come close to using 1GB(unless you incorporate a lot of videos and images)
Forum owners - Considering most forums are text based, forums use hardly any bandwidth. If you run a highly active forum, eventually you will start consuming decent amounts of disk space. However, there is no way that a shared host would allow such a forum to exist on the servers. You will be shut down before you use even a fraction of that 100gb/1000tb.
What should you consider than? If you see a host offering such impossible amounts of resources for an even more impossible price, look elsewhere. If you want a decent service, look to spend $5-10/m for a reasonable amount of disk space and bandwidth.
View 14 Replies
View Related
Aug 28, 2008
I've been in the hosting industry a very long time now and I have noticed that overselling has got more and more crazy over time.
7 years ago, 2GB of disk and 10GB bandwidth was considered overselling.
Today, its common to see offers at 1000GB/1000TB.
So my question, to all you looking for web hosting, do you really think you will need all that space and bandwidth?
I'm going to let you in on a little secret. (Some might hate me for this!) Out of all my customers, 99% use less than 1GB disk and 5GB transfer.
Every hosting provider out there knows this, and will tack on a bunch of 0s to their offer to make it look more enticing . The thing is, if you aren't using the space, you aren't getting any extra value. If you come even close to the amount they offer, I am willing to bet you will be suspended faster than you can blink. This advertising tactic is very misleading and a lot of newcomers base their decision off the meaningless numbers they see. Here is an article that covers web host overselling a little more.
Bloggers - Think again if you believe you need anything more than 1GB of space. You could type blog posts until you are blue in the face before you come close to using 1GB(unless you incorporate a lot of videos and images)
Forum owners - Considering most forums are text based, forums use hardly any bandwidth.
If you run a highly active forum, eventually you will start consuming decent amounts of disk space. However, there is no way that a shared host would allow such a forum to exist on the servers. You will be shut down before you use even a fraction of that 100gb/1000tb.
What should you consider than? If you see a host offering such impossible amounts of resources for an even more impossible price, look elsewhere. If you want a decent service, look to spend $5-10/m for a reasonable amount of disk space and bandwidth.
View 14 Replies
View Related
Jun 2, 2008
how much disk space and bandwidth would be needed to run a single Wordpress blog. I'm not a popular name, so I doubt I will have too many viewers besides my closest friends. In addition, I tend to make layouts which are a "teensy-bit" graphic-heavy :p
Is 2GB (disk space) and 30GB (bandwidth) supposedly enough?
View 16 Replies
View Related
Apr 1, 2008
The most important requirement is that the webhost must be fast. It must have alot of bandwidth.
The disc space is not so important. 200 MB would be enough.
It must have PHP, MySQL and phpmyadmin installed.
Must be accesable through FTP.
There are offcourse more requirements. But the main thing is that i want it to be fast.
My pages will be only informative and exists of just mainly text and an image every now and then.
Do you know any fast webhosts that is good to handle websites with large amounts of visitors?
I'm looking for something around 6 dollars per month.
I dont know much about webhosting at all, so i'd appreciate any help i can get
Also i see websites where you can register a domain. But the prices vary, isn't a domain just a domain? What makes this price difference?
View 10 Replies
View Related
Apr 29, 2008
My server has a small SAS disk(about 73G), if I use 90% diskspace of it, is it good idea, will it harm the physical HDD?
View 6 Replies
View Related
Oct 29, 2009
does anyone know about a windows web host with postgresql database (possibly running 8.4) and .net 3.5 ?
View 4 Replies
View Related
May 26, 2008
I just bought a VPS to do some testing on.
I have cPanel installed, and I did the "/scripts/installpostgres" and the config/password in WHM.
Now when I login to a cPanel account, and create a user or database, it just simply doesn't show up on the page.
View 2 Replies
View Related
Feb 19, 2007
i'm having isues with postgresql, 1 on 2 times i get this error:
Fatal error: Uncaught exception 'Exception' with message 'Unable to connect to database on localhost' in /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/AbstractDb.php:96 Stack trace: #0 /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/AbstractDb.php(321): AbstractDb->connect(NULL) #1 /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/Server.php(227): AbstractDb->execSqlUniqueRes('SELECT server_i...', NULL, false, true) #2 /home/lavals/public_html/auth1/wifidog-auth/wifidog/include/common.php(107): Server::getCurrentServer(true) #3 /home/lavals/public_html/auth1/wifidog-auth/wifidog/index.php(52): require_once('/home/lavals/pu...') #4 {main} thrown in /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/AbstractDb.php on line 96
the people of wifidog auth server told me to check Ulimit -a and to set it up a bit
but what should i change, here is my curent ulimit -a:
Code:
[/root]# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 1000
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
what should i boost?
i'm using a VPS with 256Ram, 1meg burst, cpanel,virtuozzo
View 13 Replies
View Related
Feb 12, 2007
i have a domain running a Wifi auth server, my problem is that i find it very slow when i try to connect to the site.
i know i'm using postgreSQL 7.4, is there a way to speed up the connection?
maybe tweak Postgresql or something,i'm new to this database system.
the link is [url]
i'm running this on a VPS with 256Ram, 1024 burst, cpanel, virtuozzo, OPTERON 246
View 5 Replies
View Related
Jul 18, 2007
When I try add data I got this error
INSERT INTO night_prices (id_prices, id_data, id_services, price_oldi, price_weekend, type_prices) VALUES (DEFAULT, 8, 18, '33', '12', 2)
[nativecode=ERROR: permission denied for sequence night_prices_id_prices_seq]
How to fix that?
I have root access.
View 1 Replies
View Related
Dec 3, 2008
I would like to install a tomcat application on my domain. Where do I upload the .war file and how can I manage the tomcat and access this application? I have root access to my Cpanel/WHM box. Also, I did apply a servlet already via WHM.
Also, I need to restore my postgres backup file as well but its too big to be done via pgmyadmin. How can I go about doing this via command line?
I'm aware of how to restore a mysql db via command line (1st create db in cpanel, 2nd run command in ssh). Never done so with a postgresql database.
View 2 Replies
View Related
Apr 30, 2009
I am looking for a webhost with a package that supports both ASP.NET *and* Postgres. So far, I have been able to find ones that support one but not the other.
View 8 Replies
View Related
Apr 7, 2008
I wanted to get a sense of the usage of Postgres versus MySQL. Does anyone here prefer Postgres over MySQL?
View 14 Replies
View Related
Oct 18, 2007
for running PostgreSQL on a VPS,
Take a look what moderator of MySource Matrix forums says (enterprise-CMS based on PHP4+pgSQL):
Quote:
Yes, installing onto a virtual server is great, because its like you have an entire server to yourself. However, running PostgreSQL in a VM is not recommended for performance reasons. Obviously this isn't a concern on low-traffic sites. The ultimate solution would be a virtual server for Apache/PHP/MySource Matrix and a dedicated server for PostgreSQL. Though, I don't know of any virtual server providers that also provide dedicated database server access.
(...)
The problem with PostgreSQL (or any database) under virtualisation is that there is no IO prioritization given. So, the database just waits along with everything else for the hypervisor to deliver IO, with no consideration for priorities. This leads to a performance hit of about 70-80%. In testing, we've seen PostgreSQL under VMware ESX/GSX perform horribly, even with fibre-attached SAN storage. Though, sticking PostgreSQL on a Xen DomU seems better. The sysadmins have done some testing on this too.
If you run PostgreSQL across multiple virtual servers on the same hardware, you're just compounding the IO bottlenecks, so I can't recommend it at all.
Source: forums.matrix.squiz.net/index.php?showtopic=3929&st=15&start=15
Can anyone comment and share thoughts on using PostgreSQL on private virtual server?
View 3 Replies
View Related
Feb 5, 2007
way to upgrade postgresql 7.4 to 8.1, i heard that V8 is less consuming
View 6 Replies
View Related
Feb 7, 2007
i cant find Postgresql log file
can any1 tell where to find it (v. 7.3)
i have cpanel,virtuozzo installed
View 6 Replies
View Related
Jan 8, 2009
I am looking for better disk performance. Due to the tight budget, I have to choose one of following options as my disk choice:
2 SATAII disk w/RAID0, 7200rpm, 32M cache for each disk
1 SAS disk, 15000rpm, 16M cache.
which one will be better and how better if other things(hardware & OS) are same?
View 14 Replies
View Related
Sep 1, 2008
can a Xen disk image be converted to a diskpartition?
Someone is asking whether I can host his disk image at his current host, which he is leaving for poor I/O (wonder why that would be ). I can host a diskimage, but I don't like diskimages (slow, and 100GB isn't very 'comfortable' either). Is there any way out there to convert a disk image into a normal partition?
View 3 Replies
View Related
Jan 9, 2008
Transferred a domain from one cpanel server to another using whm > copy account feature, but now this error arises
---------------
pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: database "udre" does not exist
---------------
Found this in the copy accounts log
Grabbing PostgreSQL databases............
could not change directory to "/root"
could not change directory to "/root"
could not change directory to "/root"
...............
Done
Grabbing PostgreSQL privileges...could not change directory to "/root"
could not change directory to "/root"
could not change directory to "/root"
View 4 Replies
View Related
Mar 15, 2007
I need to create a postgresql database in latin1 encoding with database name "db" and owner "tobe" and the password I select.
I am using PG v8.x and on cpanel box.
Please kindly list simple, straightforward step by step instructions for ssh method. I've done this a long time ago, can't remember how though.
The db is already created too, just need to convert from utf8 to latin1
I tried this:
-bash-3.00$ createdb --encoding='LATIN1' db
CREATE DATABASE
However, how do I change owner to "tobe"
I see two, one owned by root and other was created by user tobe
-bash-3.00$ psql -l
List of databases
Name | Owner | Encoding
-----------+----------+----------
db | postgres | LATIN1
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8
tobe_db | tobe | UTF8
(5 rows)
View 6 Replies
View Related
Dec 21, 2007
The postgresql not start on my server. Use REDHAT Enterprise 4, I tried to install the command:
/scripts /installpostgres
But I returned the following error:
[root@s2 backups]# /scripts/installpostgres
This script will install Postgres 7.3.x or later
If you have an older version installed you wil need to
Dump your databases to a file and then restore them
after the install as 7.3.x is not backwards compatible.
If you do not have any databases, you can just run:
mv /var/lib/pgsql /var/lib/pgsql.old
/sbin/service postgresql stop
/sbin/service postgresql start
to force creating a 7.3.x style setup. Do not do this if
you have databases that you wish to keep!
Are you sure you wish to proceed? y
Fetching Obsoletes list for channel: rhel-i386-es-4...
Fetching rpm headers...
Name Version Rel
----------------------------------------------------------
The following packages you requested were not found:
rh-postgresql
rh-postgresql-devel
rh-postgresql-libs
rh-postgresql-server
The following packages you requested are already updated:
postgresql-libs
postgresql-server
postgresql
postgresql-devel
Stopping postgresql service: [FAILED]
postmaster: no process killed
postmaster: no process killed
Starting postgresql service: [FAILED]
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
View 3 Replies
View Related
Jun 7, 2007
where pgsql keeps growing and eating up disk space on my vps.
my vps' disk space is at 4G on the directory:
var/lib/pgsql/data/base/17230
What is causing pgsql to keep growing when I did not even add anything to the vps for days?
logs are not a big problem as they consume only less than 300mb.
View 5 Replies
View Related
Mar 2, 2008
Looking for dedicated server that allows adult and proxy hosting and comes with PostgreSQL. Really looking for a more established host and not some one that’s going to steal my money and run. am open for your ideas on what you think is the best.
View 5 Replies
View Related
Apr 10, 2008
As the topic says, I need a host who knows what they are doing with PostgreSQL and is located in the US.
Budget is $40/month. 40GB+ bandwidth and 2GB+ HDD.
View 10 Replies
View Related
May 4, 2007
A customer is asking to open the port to access PostgreSQL on a shared server because he needs remote access to his database. Is it a good idea to grant remote access to PostgreSQL?
View 1 Replies
View Related
Jun 29, 2007
Haven't seen much debate lately on what processors to use within dedicated database servers. We're currently considering Dell 2950s and 2970s with the following:
Two Dual Core AMD Opteron™ 2212
- 2.0GHz, 2X1MB Cache, 1Ghz HyperTransport
Two Quad Core Intel® Xeon® E5310
- 1.60GHz, 2x4MB Cache, 1066MHz FSB
8GB RAM, single SAS, 3.5-inch, 15K RPM Hard Drive for OS, single SAS, 3.5-inch, 15K RPM Hard Drive for SWAP, and four SAS, 3.5-inch, 15K RPM Hard Drives in a RAID10 array for database storage.
We'll be getting one server just for MySQL applications and one server for just PostgreSQL applications.
View 14 Replies
View Related
Jan 26, 2013
I have installed Apache 2.4.3, and PHP 5.4.5 64-bit, and I have installed PostgreSQL 9.2 64-bits under my new system windows 7 64 bits. Apache and PHP could work nicely, and PostgreSQL run fine too. However, PHP couldn't access the PostgreSQL. pg_connect(), and followed by echo select version(), didn't give any error. When PostgreSQL module was not loaded (because my php dir was d:php, but inside httpd.conf i type D:/PHP), I got message saying something like "undefined pg_connect()." I fixed it, but select version() or any other echo after pg_connect() didn't give any output.
View 5 Replies
View Related
