Re: [ADMIN] upper and UTF-8

2010-07-27 Thread Michael Gould
Benjamin, We're using the contrib module citext for all text columns so that we can do case insensitive searches and so far we haven't found any that it doesn't find. Best Regards Mike Gould   "Benjamin Krajmalnik" wrote: > > >I just used the upper(text) function on a database which i

Re: [ADMIN] Database level encryption

2010-04-07 Thread Michael Gould
d procedures and triggers but overall I agree that a encrypted drive is probably the best thing and require ssl connections. Best Regards Michael Gould "Timothy Madden" wrote: > Andreas 'ads' Scherbaum wrote: > >> If someone captures the machine the bad gu

Re: [ADMIN] Virtualization vs. sharing a server

2010-03-29 Thread Michael Gould
others with platinum certifications from the various vendors (Citrix/ Windows Servers and VMWare).  When we finish our commerical application to production we will probably contract with EnterpriseDB to help us with tuning Postgres and the servers they run on.   Best Regards   -- Mic

[ADMIN] 8.4 contrib binaries

2009-07-17 Thread Michael Gould
Enterprise DB? Best Regards -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Questions on setup and usage

2009-07-06 Thread Michael Gould
I know that by using lowercase object names that I can work with those object in a case insensitive way, however is there a way through maybe a locale or character set to make the data and the indexes case insensitive such that you don't need to use ILIKE? Best Regards Michael Gould &

[ADMIN] Questions on setup and usage

2009-07-02 Thread Michael Gould
uire that a login be manually entered.  For those companies that use active directory we try to have our application validate the AD so that the user isn't required to multiple applications. Best Regard -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax