版本 v1.01

如果你需要这么做，你必须在顶级数据目录（通常是你的环境变量$PGDATA的值）里创建一个名为 "pg_hba" 的文件．我们在例子语法里用 src/libpq/pg_hba 代表．

如果你不需要这样以主机为基础的认证，你可以把 src/Makefile.global 里的下面这行注释掉

        HBA = 1

in src/Makefile.global

要注意缺省时以主机为基础的认证（HBA）是打开的，而且如果你不做上面所说的步骤A或B中的其中一步，其他主机上（out-of-the-box）的1.01版本将不允许你与1.0的数据库联接．

在进行下一步之前，宕掉1.0的postmaster进程，然后备份你现有的 $PGDATA 目录．

把你的 PGDATA 环境变量设置为你的 1.0 的库（的位置），但是把路径设置成1.01的可执行文件路径．

把文件 $PGDATA/PG_VERSION 从5.0修改成5.1

运行新的1.01的postmaster．

把1.01的新的内建的函数和操作符追加到1.0的数据库中去．着一步是通过在你的1.0的库上运行1.01的服务器，并且对之运行下面的查询来实现的．假如我们把下面查询拷贝到一个文件 1.0_to_1.01.sql 里去，那么我们可以通过psql很容易完整升级工作．假设你的1.0数据库名为"testdb"：

        % psql testdb -f 1.0_to_1.01.sql

-- add builtin functions that are new to 1.01

create function int4eqoid (int4, oid) returns bool as 'foo'
language 'internal';
create function oideqint4 (oid, int4) returns bool as 'foo'
language 'internal';
create function char2icregexeq (char2, text) returns bool as 'foo'
language 'internal';
create function char2icregexne (char2, text) returns bool as 'foo'
language 'internal';
create function char4icregexeq (char4, text) returns bool as 'foo'
language 'internal';
create function char4icregexne (char4, text) returns bool as 'foo'
language 'internal';
create function char8icregexeq (char8, text) returns bool as 'foo'
language 'internal';
create function char8icregexne (char8, text) returns bool as 'foo'
language 'internal';
create function char16icregexeq (char16, text) returns bool as 'foo'
language 'internal';
create function char16icregexne (char16, text) returns bool as 'foo'
language 'internal';
create function texticregexeq (text, text) returns bool as 'foo'
language 'internal';
create function texticregexne (text, text) returns bool as 'foo'
language 'internal';

-- add builtin functions that are new to 1.01

create operator = (leftarg = int4, rightarg = oid, procedure = int4eqoid);
create operator = (leftarg = oid, rightarg = int4, procedure = oideqint4);
create operator ~* (leftarg = char2, rightarg = text, procedure = char2icregexeq);
create operator !~* (leftarg = char2, rightarg = text, procedure = char2icregexne);
create operator ~* (leftarg = char4, rightarg = text, procedure = char4icregexeq);
create operator !~* (leftarg = char4, rightarg = text, procedure = char4icregexne);
create operator ~* (leftarg = char8, rightarg = text, procedure = char8icregexeq);
create operator !~* (leftarg = char8, rightarg = text, procedure = char8icregexne);
create operator ~* (leftarg = char16, rightarg = text, procedure = char16icregexeq);
create operator !~* (leftarg = char16, rightarg = text, procedure = char16icregexne);
create operator ~* (leftarg = text, rightarg = text, procedure = texticregexeq);
create operator !~* (leftarg = text, rightarg = text, procedure = texticregexne);