I solved my problems by using the uninstall scripts located in the
share/contrib in 8.2 to get rid of tsearch2 and fuzzymatch and that
eliminated a lot of the errors I was running into.
2010/12/21 Adib amsl...@gmail.com
Is there some way to avoid restoring tsearch2 since full text searching is
Adib, contrib/tsearch2.sql is a compatibility interface in order to
avoid having to rewrite your application for 8.3 tsearch2.
In 8.3, tsearch2 was included in core. However, functions and procedures
changed. So, a contrib module was included in order to translate old
tsearch2 calls to new
Thanks for all the great advice.
In my case I have two java apps using the database with Hibernate so they
are not using any of the tsearch2 features, it seems when I ran the 8.2
installer many years ago i clicked the checkbox to install tsearch2 and
fuzzymatch into template1 which is why my two
Dear devs,
I just saw this EXPLAIN in PostgreSQL 8.3.12:
EXPLAIN UPDATE dbmail_messages SET recent_flag = 0 WHERE message_idnr IN
(3506054,3506052,3506050,3506048,3506046,3506044,3506042,3506040,3506038,3506036,3506034,3506032,3506030)
AND recent_flag = 1;
Hi Adib.
So, you will have no problems with tsearch2, but with data types it's
very possible. Check in depth your app before migrating production
environment. ;-)
If you only are going to migrate one database, use pg_dump from higher
version... from 9.0, pg_dump -d database -U username -h
On Wed, Dec 22, 2010 at 1:52 AM, kubus__pucha...@tlen.pl wrote:
In postgres im beginer .
How write procedure returned different types of value?
i need function to select different data types from table columns and
returned.
i try overload name of function but its bad idea.
it is
Michael Monnerie michael.monne...@is.it-management.at writes:
I just saw this EXPLAIN in PostgreSQL 8.3.12:
[ just like any other bitmap index scan ]
And it seems to me that could be optimized to skip the Recheck Cond as
that is already checked by the Index Scan? Should save some CPU cycles.
After some enlightening considerations by Scott Marlowe I'm actually now
considering a streaming replication with dedicated network connection
and two different data dirs on the same storage. This would bypass the
lock issue, make replication very fast and make my life easier with
one reliable
It's hard to say Robin, I'm still in testing.
At the beginning I'd say very low ... probably something between 2000
and 5000 transactions a day (even harder to imagine how this load it's
gonna be distributed within 24 hours)?!
Thanks for your reply.
On Tue, 2010-12-21 at 08:02 +, robin
I'm certain it was -f, not -F, since it's still in the script I use, albeit
commented out.
I understand the purpose of the clogs, but I would think that the transactions
would have been frozen on all dbs (I've got about 300 in my cluster) by now. My
logs go back to July 13th which, I think,
Scott Whitney sc...@journyx.com writes:
I understand the purpose of the clogs, but I would think that the
transactions would have been frozen on all dbs (I've got about 300 in my
cluster) by now. My logs go back to July 13th which, I think, is when the
server was last restarted.
It
Hi All,
I am looking for suggestions on how best to secure a server that is
accessible via the internet. Even account creation for the database is
open to the world. Does anybody have any extra changes they would make
to postgresql.conf or OS changes they would suggest? Perhaps some
default
Josh j...@saucetel.com wrote:
I am looking for suggestions on how best to secure a server that
is accessible via the internet. Even account creation for the
database is open to the world. Does anybody have any extra changes
they would make to postgresql.conf or OS changes they would
On Wed, Dec 22, 2010 at 3:30 PM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
Josh j...@saucetel.com wrote:
I am looking for suggestions on how best to secure a server that
is accessible via the internet. Even account creation for the
database is open to the world. Does anybody have any
Joshj...@saucetel.com wrote:
I am looking for suggestions on how best to secure a server that
is accessible via the internet. Even account creation for the
database is open to the world. Does anybody have any extra changes
they would make to postgresql.conf or OS changes they would
suggest?
Well, under this point of view I feel a bit lucky now. Having built-in
streaming replication is a big advantage and gives me the chance to
avoid third party applications. Despite there are good solutions out
there I believe that less complexity is always better.
Plus, I would really like to avoid
16 matches
Mail list logo
