E.6. �汾 7.4.2

E.6.1. ��ֲ���汾 7.4.2

�������� 7.4.X ���û�������Ҫת��/���ء�������ת��/�������޸��� 7.4.X �汾��ϵͳ������������������򵥵ķ����� ʹ�� 7.4.2 �� initdb Ȼ����һ��ת��/initdb/�������н��Զ��޸���Щ���⡣

�����������и����ص����������� anyarray �Ķ����ǩ�Ǵ���ģ� �������������Ϊ pg_statistic ϵͳ��ʹ�� anyarray �ֶΡ� �����ǩ������ܵ��¹滮���ڹ滮�漰ʹ��˫���ȶ�����ֶΣ����� float8 �� timestamp���� WHERE �Ӿ��ʱ����ƴ��������DZ���������ǿ�ҽ������а�װ���޸��������Ҫô��ͨ�� initdb��Ҫô��ʹ��������ܵ��ֹ��޸�������

��һЩ�Ĵ�����ϵͳ��ͼ pg_settings Ӧ�ñ�־Ϊ�����ĸ��·��ʣ� ������ UPDATE pg_settings ���� SET ������� ���Ҳ����ͨ�� initdb �����ֹ��޸���������������ʹ�� UPDATE pg_settings�������DZ���ġ�

����㲻���� initdb������IJ�������޸� pg_statistic�� �����ݿⳬ���û���ݣ�������IJ�����

-- ��� pg_statistic ��ľ����ݣ�
DELETE FROM pg_statistic;
VACUUM pg_statistic;
-- �������� 1 ��
UPDATE pg_type SET typalign = 'd' WHERE oid = 2277;
-- �������� 6 ��
UPDATE pg_attribute SET attalign = 'd' WHERE atttypid = 2277;
--
-- ���ʱ�����������һ���µĺ���Ա��������
--
-- ������� pg_statistic��
ANALYZE;

��Щ����������һ����Ծ�����ݿ��ﴦ������Ҫע���ڰ�ȫ��������� pg_statistic ֮ǰ�� �����ڸ��ĵ����ݿ������еĺ�˶�Ҫ������

Ҫ�޸� pg_settings ���󣬼򵥵أ�

GRANT SELECT, UPDATE ON pg_settings TO PUBLIC;

����Ĺ��̱�����һ����װ�е�ÿ�����ݿ���ִ�У� ���� template1�����Ҳ���� template0�� ����㲻�޲�ģ�����ݿ⣬��ô��󴴽������ݿ⽫��Ҳ����ͬ���Ĵ��� template1 �������������ݿ������޲������޲� template0 ��ҪһЩ����IJ��衣 ���ȣ����������ݿ��﷢��

UPDATE pg_database SET datallowconn = true WHERE datname = 'template0';

Ȼ�����ӵ� template0 Ȼ��ִ��������޸����̡����

-- ���¶��� template0��
VACUUM FREEZE;
-- Ȼ�󱣻��������һ���ĸ��ģ�
UPDATE pg_database SET datallowconn = false WHERE datname = 'template0';

E.6.2. �޸�

�汾 7.4.2 �������а汾 7.3.6 �IJ���������������Щ�޲���

• Fix pg_statistics alignment bug that could crash optimizer

  See above for details about this problem.

• Allow non-super users to update pg_settings

• Fix several optimizer bugs, most of which led to "variable not found in subplan target lists" errors

• Avoid out-of-memory failure during startup of large multiple index scan

• Fix multibyte problem that could lead to "out of memory" error during COPY IN

• Fix problems with SELECT INTO / CREATE TABLE AS from tables without OIDs

• Fix problems with alter_table regression test during parallel testing

• Fix problems with hitting open file limit, especially on OS X (Tom)

• Partial fix for Turkish-locale issues

  initdb will succeed now in Turkish locale, but there are still some inconveniences associated with the i/I problem.

• Make pg_dump set client encoding on restore

• Other minor pg_dump fixes

• Allow ecpg to again use C keywords as column names (Michael)

• Added ecpg WHENEVER NOT_FOUND to SELECT/INSERT/UPDATE/DELETE (Michael)

• Fix ecpg crash for queries calling set-returning functions (Michael)

• Various other ecpg fixes (Michael)

• Fixes for Borland compiler

• Thread build improvements (Bruce)

• Various other build fixes

• Various JDBC fixes