Question : We recently suffered a power/connectivity outage at a data center housing two PostgreSQL 8.4 secondary servers, that remotely […]
Tag: postgresql-8.4
How to upgrade PostgreSQL from version 8.4 to 9.4?
Question : I want to upgrade my PostgreSQL from version 8.4 to 9.4. The documentation is not very clear to […]
Complex constraint across all data in a table
Question : We have a table to record processing that occurs on a system and we need to ensure that […]
Using TCP keepalive for terminating orphan postgres queries not working
Question : Problem: A user of some application executes a report which involves a heavy sql query. After some minutes, […]
Error: Could not read Block X of relation base/Y/Z
Question : We have some serious issues with our PostgreSQL-Server (Version 8.4). Our webapplication uses jdbc to connect to the […]
How to take pg_dump of a very large postgres database?
Question : I have a production database server running Postgres 8.4 on Cent OS 6.5.The volume of data has increased […]
How do I install pgcrypto in PostgreSQL 8.4?
Question : I’m using Ubuntu Server 10.10 and I have installed PostgreSQL 8.4 using apt-get install postgresql. I would like […]
Error granting access to sequence with PostgreSQL 8.4
Question : I’m attempting to run this query GRANT USAGE ON [db].users_uid_seq TO [user]; db and user are redacted (obviously). […]
Test/Verify Log-Shipping Backup
Question : We recently suffered a power/connectivity outage at a data center housing two PostgreSQL 8.4 secondary servers, that remotely […]
Degrading PostgreSQL 8.4 write performance
Question : Load testing of postgresql 8.4 for OLTP application suitability resulted in unpleasant situation when throughput of the database […]