Postgres Pro
Downloads
Home   >   mailing lists

Re: migrate hashname function from 8.1.x to 8.4 - Mailing list pgsql-general

From Greg Smith
Subject Re: migrate hashname function from 8.1.x to 8.4
Date
Msg-id 4D2C7A1F.4050600@2ndquadrant.com
Whole thread Raw
In response to migrate hashname function from 8.1.x to 8.4  ("Nicolas Garfinkiel" <nicolas.garfinkiel@genesis-manlab.com.ar>)
Responses Re: migrate hashname function from 8.1.x to 8.4  ("Nicolás Garfinkiel" <nicolas.garfinkiel@gmail.com>)
List pgsql-general
Tree view
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@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books

pgsql-general by date:

Previous
From: ๏̯͡๏ Guido Barosio
Date:
Subject: [ANNOUNCE] Re: [pgsql-es-ayuda] Para participantes extranjeros en el Tercer PGDay Latinoamericano.
Next
From: "Karayappalli, Raghunath (Raghu)"
Date:
Subject: Re: database is growing... 1GB per day basis