| From: | Nicolás Garfinkiel <nicolas(dot)garfinkiel(at)gmail(dot)com> |
|---|---|
| To: | Greg Smith <greg(at)2ndquadrant(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: migrate hashname function from 8.1.x to 8.4 |
| Date: | 2011-01-11 19:19:09 |
| Message-ID: | 5945057B-7116-4F74-BD7E-ADED0E07CCC0@genesis-manlab.com.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thanks a lot Greg!
On 11/01/2011, at 12:41, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:
> Nicolas Garfinkiel wrote:
>>
>>
>> I’m trying to upgrade our pgsql from 8.1 to 8.4, but our system’s login uses the hashname() function in order to get the proper password validation. Now pgsql’s 8.4 hashname function is not compatible with 8.1’s function. Do you have any ideas how I can reproduce 8.1 function in 8.4?
>
> https://github.com/petere/pgvihash provides the function you're looking for.
>
> I agree with Craig's concerns here, but this may let you convert toward a better long-term format more easily.
>
> --
> Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
> PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
> "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ing. Yunior Mesa Reyes | 2011-01-11 20:30:38 | Oferta de Entrenamientos en el marco del Cuarto PGDay Latinoamericano. |
| Previous Message | Karayappalli, Raghunath (Raghu) | 2011-01-11 18:11:12 | Re: database is growing... 1GB per day basis |