Tag Info

New answers tagged

5

14.04 shipped with PostgreSQL 9.3, so that's what you're going to get if you use Ubuntu's repositories. If you want PostgreSQL 9.4 or newer releases you need to add a 3rd party package repository, like the official PostgreSQL repositories from http://apt.postgresql.org/ . See the instructions there for details. (You should also probably read ...


0

After thorough research, we determined that the problem was that WordPress was being attacked and it was causing MySQL to use the maximum amount of memory allotted to it in the configuration files. Even caching of WordPress pages could not stop this illegitimate traffic from using all of the memory because of the sheer volume of IP addresses the attackers ...


1

This is the same issue as described here (for MySQL): High CPU usage from MySQL with no queries at all running sudo date -s now Caused by leap second and a bug in the kernel.


0

Depending on the hardware you're moving from/to (or not moving), you could just take the data & config files, and copy them across to the new system. If the new system is set up the same for storage/memory, this might just work, but may need some tweaking of config to make it happen. If you're changing to hardware where you can't just copy the files, ...


1

You have to configure the following two files pg_hba.conf host all all 0.0.0.0/0 md5 postgresql.conf listen_addresses='*' Make sure to restart postgres service after changing the files. You have to check if the port 5432 is open: http://www.yougetsignal.com/tools/open-ports/ If it's not then add a rule to your iptables: iptables -A INPUT -s 0/0 -p ...


0

The slowness you're experiencing could be because of several reasons, one or more. It is important to note that 20K rows is relatively small number of rows. You may want to check for the following: What is the structure of the tables, engine, keys (indexes), and primary keys. Output the query after certain number of iterations to make sure your query ...



Top 50 recent answers are included