Questions tagged [postgresql-8.4]
PostgreSQL version 8.4
57 questions
0
votes
2
answers
220
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
248
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
854
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
124
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
959
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
0
votes
1
answer
71
views
postgresql v8.4 function runs but doesn't work
I have a postgresql v8.4 database. I need to update several hundred tables with about 3 million rows of data each.
The customer wants a new column added (which I added) and now I'm trying to update ...
- 103
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
2k
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
7k
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
115
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
973
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
0
votes
1
answer
449
views
PostgreSQL directory very full
In the /var/lib/pgsql/data/base Postgres that in version 8.4 and it was identified that the error single bank is with 37G which is absurd, is not already realized vacuum full declined nothing and also ...
- 1
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