It seems postgres is suffering from a file system condition, so your solution
lies there and not with postgres. There are many reasons why a file system can
become read-only. For example, if you are using virtual machines and run in to
a low I/O bandwidth condition, the vm software can put the
When this discussion first started, I immediately thought about people who full
text index their server's log files. As a test I copied /var/log/messages to
$PGDATA and then used the same pg_read_file() function you mentioned earlier to
pull the data into a column of type text. The original fil
I found another post where you asked the same questions 5 months ago. Have you
tested in that time? http://www.spinics.net/lists/pgsql-admin/msg19438.html
A text search vector is an array of distinct lexemes (less any stopwords) and
their positions. Taking your example we get ...
select to_ts
Did you configure a system DSN or user DSN? If connections fail for postgres
and succeed for other users, then look in the postgres user's home for hidden
file ~/.odbc.ini. Each user can have one of these hidden files.
-Mark
-Original Message-
From: 최재원 [mailto:jwc...@modernlimes.com]
Sen
I too have been looking into this as a new user of PostgreSQL 9.0.
1. Before you install PostgreSQL you might want to verify the LDAP packages are
installed. For example, on CentOS I might run "yum list openldap
openldap-devel".
2. If you install PostgreSQL from source code, one of the steps is
Yes, understood and agreed. My mail server adds it automatically. I can
manually remove it prior to sending to the mail list.
-Mark
-Original Message-
From: Simon Riggs [mailto:si...@2ndquadrant.com]
Sent: Tuesday, May 3, 2011 10:33 AM
To: 'Mark Johnson'
Cc: 'pgsql-admin
Is there a particular one of Oracle's memory clearning features you want to use
in PostgreSQL? In Oracle you cannot flush the entire SGA without a restart, but
you can flush three parts of the SGA using three separate commands.
1. In Oracle you can flush the redo buffer by issuing a COMMIT or by
I am in the same boat, and I do not think SE-PG or the pending PG 9.1 will do
what we want. I don't see where it provides per-user row filtering or column
filtering as is possible with Oracle (well, certain Oracle editions and/or
certain extra cost software). I think even in PG 9.1 you will nee
I have a question about using pg_upgrade on a very large database. It is not
feasible to copy the data location, so I am looking at the link option
(pg_upgrade -k). That is, for the same reason it is not practical to run
pg_dumpall / restore it is not practical to copy several tens of terabytes