Question : I’m using debian squeeze package, it says function does not exist? Answer : You have to install the […]
Tag: postgresql-8.4
Where can I download an old version of PostgreSQL for Windows? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Tip of the iceberg – the question […]
What is the relevance of ‘SET default_with_oids = true’ in a Postgresql dump?
Question : I have an SQL backup from an old database which may have been a PostgreSQL 7 or 8 […]
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 […]
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 […]