New answers tagged postgresql-9.1
If you have pgpool running on two servers with a "floating ip" then there's your HA! Direct services at the floating ip/port and if one disappears, requests should begin to be served by the other? No need for an extra HAProxy layer.
Perfectly ok - especially since you can add and subtract integer to / from date directly in Postgres. However, int2 might not be better than a plain integer. True, integer occupies 4 bytes instead of 2, but many operations are optimized for integer. Among other things, integer is the default numeric type for numbers without decimal point. For int2 you ...
There are basically three ways of upgrading PostgreSQL from different major versions (e.g. 9.1 to 9.3). Upgrading with pg_dump The first one, and recommended if possible, is to do a dump of the old (9.1) version using the binary of the newer (9.3) version and restore it on a new cluster created of the newer version. This approach is, generally, the slower ...
It has been about 24 hours now since I have implemented the change that fixed this, so I think it is safe to call. I will update this however if this kind of spike happens again. In the system logs we were getting this message and I had my data center replace the RAM in the machine. Mar 3 18:40:24 hubble kernel: sbridge: HANDLING MCE MEMORY ERROR Mar 3 ...
After researching, I found that we need to find the pg_hba.conf file under C:\Program Files\PostgreSQL\9.3\data Run the notepad++ as administrator (or the editor you usually use to edit the files) Open the file and at the very bottom, look for # TYPE DATABASE USER ADDRESS METHOD For all the entries for TYPE "host", ...
check out pg_freespacemap module: http://www.postgresql.org/docs/9.3/static/pgfreespacemap.html
Top 50 recent answers are included