All Questions
Tagged with postgresql postgresql-8.4
52 questions
0
votes
2
answers
209
views
Test/Verify Log-Shipping Backup
We recently suffered a power/connectivity outage at a data center housing two PostgreSQL 8.4 secondary servers, that remotely back up our two primaries via log-shipping replication. Backup power kept ...
4
votes
1
answer
243
views
Create WAL at interval, but only if data changed
I have a PostgreSQL 8.4 installation, and I have configured the archive_timeout setting to 5 minutes to improve the odds that I always have complete WAL file to apply in case of system failure.
...
- 193
4
votes
1
answer
16k
views
Where can I download an old version of PostgreSQL for Windows? [closed]
I need version 8.4 for a legacy system, but EnterpriseDB (the official link) only shows 9.x
On the PostgreSQL FTP Mirror I see the 8.4.22 binary, but only have binary for solaris:
1
vote
1
answer
846
views
Postgres row count
I have a table with a row count of 985 records. But it is really slow to query this table.
# select count(*) from movie;
count
-------
985
Then I perform query using EXPLAIN ANALYZE The row ...
- 113
1
vote
1
answer
2k
views
Error granting access to sequence with PostgreSQL 8.4
I'm attempting to run this query
GRANT USAGE ON [db].users_uid_seq TO [user];
db and user are redacted (obviously).
I get this error:
ERROR: syntax error at or near "GRANT"
I've tried a number of ...
- 58
1
vote
0
answers
123
views
postgres 8.4: makeslave it's own master
For a DR test, I've tried to split the slave from the master. To do this, I edited the master postgresql.conf, turned off archive_mode and restarted. No problem.
Now I'm trying to make the slave a ...
- 694
2
votes
1
answer
952
views
delete hung soon after vacuum verbose analyse
I have a fairly large java webapp system that connects to a postgres8.4 db on rhel.
This app only does inserts and reads.
This has been running without issue for 2.5 years and for the last year or so ...
- 71
6
votes
1
answer
5k
views
Using TCP keepalive for terminating orphan postgres queries not working
Problem: A user of some application executes a report which involves a heavy sql query. After some minutes, the user then quits the application (or even worse, the app crashes, or the connection to ...
1
vote
1
answer
1k
views
ERROR: "4.9E-324" is out of range for type double precision
I saw this error when trying to perform the following insert into a PostgreSQL 8.4.20:
java.sql.BatchUpdateException: Batch entry 12 insert into perf_raw_2017_03_16 values ('3129', '182', '818', '...
- 193
20
votes
7
answers
6k
views
Form groups of consecutive rows with same value
I have a situation I think can be solved using window function but I'm not sure.
Imagine the following table
CREATE TABLE tmp (
date timestamp
, id_type integer
) ;
INSERT INTO tmp (date, id_type)
...
- 303
0
votes
1
answer
102
views
Giving a session-local temporary name to a schema
I have a schema foo_bar but also foo_x. During a particular session, is it possible to just set foo_bar to bar in PostgreSQL (8.4)?
1
vote
1
answer
961
views
Function pg_indexes_size(oid) does not exist
I'm attempting an operation on a pg_class c, but getting this:
ERROR: function pg_indexes_size(oid) does not exist
LINE 10: , pg_indexes_size(c.oid) AS index_bytes
...
- 113
2
votes
1
answer
1k
views
How to reset a postgres database that has used all of the available disk space?
I have a small ~10G PostgreSQL 8.4 database used for development that has filled up the /var directory and is now unusable. I am unable to connect to the database in this state to delete any data or ...
- 123
3
votes
2
answers
18k
views
Declare variable for SELECT statement in Postgres function
I have modified my function, but I have problems with declaring variables. I use Postgres 8.4.
CREATE OR REPLACE FUNCTION requestcounterid(_mindate timestamptz, _maxdate timestamptz)
RETURNS TABLE ...
- 33
6
votes
2
answers
4k
views
Improve performance for order by with columns from many tables
Using PostgreSQL 8.4, I'm trying to consult two tables with 1 million records using order by with indexed columns of the two tables, and I'm losing performance (with 1 column takes 30 ms and with two ...
