Questions tagged [postgresql-8.3]
PostgreSQL version 8.3
18
questions
16
votes
3
answers
36k
views
Is it possible to configure PostgreSQL to automatically close idle connections?
Clients connect to our PostgreSQL 8.3 database but leave the connections opened. Is it possible to configure PostgreSQL to close those connections after a certain amount of inactivity?
- 1,463
11
votes
1
answer
5k
views
Unexpected Seq Scan when doing query against boolean with value NULL
I have a database column called auto_review where column type is boolean.
There is an index for that field, created using the ActiveRecord ORM.
CREATE INDEX index_table_on_auto_renew ON table USING ...
- 341
11
votes
6
answers
48k
views
PostgreSQL import CSV File causes Syntax Error
I'm attempting to import a CSV file into a database via the "COPY" command; however, I get the (what seems common) error that I need to be a superuser and that I should use "\copy" instead. However, ...
- 253
5
votes
1
answer
4k
views
Passing ROWTYPE parameter to EXECUTE
I am developing a function in Postgres which aims to recover for each record of a query the value of a result of a check contained in a set of functions. Only one of these functions will return the ...
- 133
3
votes
2
answers
1k
views
PostgreSQL 8.3 - issues with autovacuum
I posted this on StackOverflow and it was suggested this query was better suited here.
I'm trying to encourage the use and monitoring of autovacuum in some PostgreSQL 8.3 databases.
One objection I ...
- 133
3
votes
2
answers
862
views
Bug in PL/pgSQL function creation
I don't know if this question better suits here or in SO ...
This is a script that I'd like to launch (the code of the function was copied from a question on SO):
\c mydb
create or replace function ...
- 8,651
3
votes
1
answer
29k
views
Using dynamic column names in PostgreSQL
I am using PostgreSSQL 8.3.
I want to execute this query:
select COALESCE(col_fr,col,'Unknown') from my_table where id = 'abc';
Twist in the story is column name colum_fr should be generated ...
- 31
3
votes
2
answers
2k
views
PostgreSQL 8.3: Slow GROUP BY on large table
I have a table with about 10 million records. I want to do a simple group by, but it's using a sequential scan and is slow...
select run_id, count(*) from result group by run_id;
I have an index ...
- 131
3
votes
1
answer
353
views
A 'deeper' PostgreSQL autovacuum
We have a PostgreSQL 8.3.7 database suffering severe bloat after an algorithmic change. Unfortunately upgrading isn't an option at this time.
For a particular group of partitioned count roll-up ...
- 33
3
votes
1
answer
6k
views
How can I create a dblink from Postgresql 8.3 to SQL Server (2000 and 2008)?
I have a Postgresql database that need to read data from two SQL Servers (one SQL Server 2000 and one SQL Server 2008).
I want to setup two dblinks to the SQL Servers.
After googling, foruming, ...
- 1,463
2
votes
3
answers
231
views
PostgreSQL: 8.3/8.4 interface chages?
I would like to upgrade a PostgreSQL 8.3 server to PostrgreSQL 8.4. There are many software components that interact with the server over the network, and I am concerned with compatibility issues.
Is ...
- 11.7k
1
vote
2
answers
6k
views
How to simulate postgresql recovery mode?
I would like to simulate putting postgresql into "recovery mode".
Few times i have situation where postgresql puted himself into recovery mode. In logs i had:
Oct 18 06:37:35 xx postgres[5738]: [19-1]...
- 113
1
vote
1
answer
4k
views
Trying to start a newly created cluster in PostgreSQL on Windows
I just created a new cluster using PostgreSQL 8.3 and looks like everything worked. What I am having issues with is trying to start the server of this new cluster. My two clusters are on different ...
- 289
1
vote
1
answer
35
views
Import Postgres 8.3 database in Postgres 10.5
I have a database in Postgres 8.3 (and PostGIS 4.2), which I need to import in Postgres 10.5.
I am a DB newbie and would appreciate any pointers to get started.
- 113
1
vote
0
answers
296
views
postgresql 8.3 possible checkpoint and memory misconfiguration
I am using postgresql 8.3 in a read/write heavy application where data are being written to the database from a background process while they are also being read/written from a web application.
At ...
John Papsi
0
votes
1
answer
1k
views
Postgres 8.3 faster than 9.3?
Our software product currently ships on Windows 7 with Postgres 8.3 as its database. On a busy site, there may be 24 automated systems generating 100 rows (x100 columns) per minute, with 3-10 human ...
- 123
0
votes
0
answers
729
views
postgresql suddenly stopped working "incomplete startup packet error"
I've searched and read a lot about these kind of errors, but none of them solved my question. Why does this error happens all of a sudden ? could this to be a problem of memory on the server ? (I ...
0
votes
1
answer
1k
views
Postgres 8.3 correct deletion of files in pgsql_tmp
We are talking about the PostgreSQL 8.3 RDBMS here. So, no pg_terminate_backend() is possible with this version.
Sometimes we have to kill running processes at Operating System level (kill -9 PID) to ...
