Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [postgresql-8.3]

PostgreSQL version 8.3

Specifically for PostgreSQL version 8.3 (Released Feb 04, 2008)

18 questions
16
votes
3 answers

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?
Stephan
  • 1,513
  • 4
  • 18
  • 27
11
votes
1 answer

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 btree (auto_renew); When I query the field for a…
Simone Carletti
  • 341
  • 3
  • 14
11
votes
6 answers

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, when using \copy, I get a syntax error: ERROR: …
antjanus
  • 253
  • 1
  • 3
  • 7
5
votes
1 answer

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 correct value. These functions have a common prefix…
Geison Santos
  • 133
  • 1
  • 9
3
votes
1 answer

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 dynamically. my_table has different columns for different…
user36935
  • 31
  • 1
  • 1
  • 3
3
votes
2 answers

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 hit often is that people don't "trust" autovacuum…
azp74
  • 133
  • 3
3
votes
2 answers

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 defined on the run_id column. How can I speed this…
FogleBird
  • 131
  • 4
3
votes
1 answer

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, reading documentation, I struggle to find something…
Stephan
  • 1,513
  • 4
  • 18
  • 27
3
votes
1 answer

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 tables, we used to update them by selecting then either…
coltnz
  • 33
  • 2
3
votes
2 answers

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 truncate_tables(username in varchar) returns void…
Stephane Rolland
  • 8,911
  • 11
  • 33
  • 40
2
votes
3 answers

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 there any interface change between the different…
Adam Matan
  • 12,079
  • 30
  • 82
  • 96
2
votes
1 answer

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 ports. When looking online to start the new…
user972276
  • 309
  • 1
  • 4
  • 13
1
vote
2 answers

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] 2014-10-18 06:37:35.441 CEST|5738|xx|yy|FATAL: …
undefine
  • 113
  • 1
  • 5
1
vote
0 answers

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 peak hours, we notice performance problems in the…
John Papsi
1
vote
1 answer

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.
mitchus
  • 113
  • 4
1
2