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 a
Josh 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? Perhaps some default
On Wed, Dec 22, 2010 at 3:30 PM, Kevin Grittner
wrote:
> Josh 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 p
Josh 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? Perhaps som
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 pe
Scott Whitney 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 doesn't really try t
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, is
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 wrote:
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 (r
Michael Monnerie 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.
You evidently don't understand
On Wed, Dec 22, 2010 at 1:52 AM, 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 possible?
>
>
>
> an
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 hostna
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;
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 p
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 tsearc
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
> Is there some way to avoid restoring tsearch2 since full text searching is
> now part of pos
16 matches
Mail list logo
