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"
I am trying to transfer accounts between servers by using whm transfer (with root password) and all the accounts that had databases are missing tables.
So for some reason the transfer does not transfer databases fully, it does not matter with the size of them not all tables are getting transferred over.
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.
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.
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.
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!
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.
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)
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?
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:
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.
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.
