PostgreSQL version 9.1
Questions tagged [postgresql-9.1]
279 questions
10
votes
3 answers
Replication has failed; how to get going on again?
I'm running Postgres 9.1.6 on Ubuntu and I have streaming replication setup between a master and slave. Everything has been running smoothly until the database crashed and we had to restart both of the boxes.
Now, replication has stopped and when…
Mark Hoffman
- 201
- 2
- 4
3
votes
1 answer
Is it possible to run VACUUM FULL in Postgres asynchronously?
I am working on some unused data purging scripts on Postgres 9.1. VACUUM FULL is necessary to reclaim physical space after purging. However, with my data volume (5M+ rows), it takes several minutes to execute it. Since the vacuum needs to be…
amphibient
- 354
- 1
- 6
- 17
2
votes
1 answer
How to change the default delimiter in PostgreSQL 9.1.9 using SET?
From within a bash script I tried to use a replace and a detection on a field containing a pipe like:
IF position ('|' in var) IS NOT NULL THEN ...
...REPLACE(field, '|', '#')
The data itself was loaded into the DB using the COPY statement e.g.…
Tom
- 27
- 1
- 2
- 5
2
votes
1 answer
delete rows in 3 tables with on delete cascade
For a relation 0..n between two tables (t1,t2), the mpd generates an intermediate table (t3) with two fk.
Let two constraints on the t3 table, each one with "on delete cascade", if I do:
delete from t1 where id1=$id1;
I want to delete all rows of…
Bertaud
- 123
- 1
- 1
- 5
1
vote
0 answers
Veryfing integrity of custom order column with pure SQL
I have two tables, one stores structure (using so called parent field), the other entities that can be embeded into that structure. As certain level of structure can contain both entities and deeper elements of structure both tables have sort column…
Jacek Prucia
- 341
- 1
- 2
- 4
1
vote
1 answer
After installing postgresql and postgres-xc with apt-get, I have psql but not postgres, initdb, pg_ctl
I used apt-get on Linux Mint to install postgresql and postgres-xc.
I have access to psql, the postgres user exists, it's possible to create databases.
However, the server seems to be running on port 5433 and another process wants it to be on…
Mercutio
- 11
- 1
- 4
1
vote
1 answer
RIGHT() function in postgresql 9.1 not behaving as anticipated?
The following is with regard to PostgresQL 9.1 :
I am using the right() and left() string functions to fix a few instances where data was input into my database being “off by one” .. so I’m doing something along the lines of…
Joishi Bodio
- 3,378
- 2
- 16
- 19
0
votes
2 answers
Big table size in PostgreSQL while number of rows is small
Tables' size in the PostgreSQL DB are big while the number of rows is relatively small (less then 500K rows).
Vacuum of the specific table did not solve the problem.
Only by deleting and importing the table from a previous dump file did solve the…
Invigo Support
0
votes
1 answer
To get rid of heavy archive logs in PostgreSQL 9.1
In our production server which is having PostgreSQL 9.1 installed, too heavy archive logs are being generated, approximately 41 GB/day. Heavy updates, deletes and inserts are the cause of this. Can anyone help us to reduce the amount of archive log…
Arun Raut
- 57
- 3
- 6