Hi Tom,
First of all, Big Thx for answering.
Otherwise, thx also for all this hints.
What about my case seems to be more related to the fact 'tsearch2' is already
'integrated' in 8.4
Whereas in 8.1, one has to have it 'imported' on purpose.
All this leads to conflicts during 'restore' of my DB
Also Thx to Robert :) ...
- Mail original -
De: chanh tran chanh.t...@free.fr
À: Tom Lane t...@sss.pgh.pa.us
Cc: pgsql-admin@postgresql.org, Robert Treat r...@xzilla.net
Envoyé: Lundi 22 Avril 2013 13:27:29
Objet: Re: [ADMIN] Pb migrating database from Postgres 8.1 to 8.4
Hi Tom,
First
Hi I am working with version 9.1.9. The dabase is in archiving mode. The
archives are then sended to a hotstandby replication sever.
I have seen that under heavy load, the archive process will fall behind the
WAL generation and thuse some WAL segments won't get archived so the
replication stops.
Hello,
We have elements in our setup that have been around for quite awhile. We are
currently running 9.2 and I was wondering if there would be any significant
performance increase by moving the conditions out of the function into the
trigger... like would avoiding the function load save
I currently have 2 servers running PostgreSQL 9.0 under FreeBSD
configured with streaming replication.
DB1 is the primary server, and DB2 is the replicated server, which is
used for all of the read only queries.
I am having some hardware issues on DB1 which is affecting its
performance,
On Mon, 22 Apr 2013 12:06:52 -0600, Benjamin Krajmalnik wrote:
I currently have 2 servers running PostgreSQL 9.0 under FreeBSD
configured with streaming replication.
DB1 is the primary server, and DB2 is the replicated server, which is
used for all of the read only queries.
I am having