Базы данныхИнтернетКомпьютерыОперационные системыПрограммированиеСетиСвязьРазное
Поиск по сайту:
Подпишись на рассылку:

Назад в раздел


> > >Выпуск v1.01 > NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet version 1.18"> REL="HOME"
TITLE="Руководство администратора по PostgreSQL"
HREF="671.html"> REL="UP"
TITLE="Замечания по выпускам"
HREF="5861.html"> REL="PREVIOUS"
TITLE="Выпуск v1.02"
HREF="5875.html"> REL="NEXT"
TITLE="Выпуск v1.0"
HREF="5877.html">

WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
> > COLSPAN="3"
ALIGN="center"
>Руководство администратора по PostgreSQL
>
> > WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
> HREF="5875.html"
>Предыдущий
>
> WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
>Глава 15. Замечания по выпускам
> WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
> HREF="5877.html"
>Следующий
>
>
> > ALIGN="LEFT"
WIDTH="100%"> CLASS="SECT1"
> NAME="AEN2228"
>Выпуск v1.01
>
> CLASS="SECT2"
> NAME="AEN2230"
>Переход с v1.0 на v1.01
>
> >Следующие замечания о том что выиграют пользователи, кто хотел бы
перейти с базы данных postgres95 1.0 на postgres95 1.01.
> >Если ты первый раз ставишь postgres95 1.01 и тебе не нужно переносить
старые базы, то читать дальше тебе не нужно.
> >In order to postgres95 version 1.01 with databases created with
postgres95 version 1.0, the following steps are required:
> TYPE="1"
> > >Set the definition of NAMEDATALEN in src/Makefile.global to 16
and OIDNAMELEN to 20.
>
> > >Decide whether you want to use Host based authentication. > CLASS="SUBSTEPS"
TYPE="a"
> > >If you do, you must create a file name "pg_hba" in your top-level data
directory (typically the value of your $PGDATA). src/libpq/pg_hba
shows an example syntax.
>
> > >If you do not want host-based authentication, you can comment out
the line
CLASS="PROGRAMLISTING"
> HBA = 1
>
in src/Makefile.global
> > Note that host-based authentication is turned on by default, and if
you do not take steps A or B above, the out-of-the-box 1.01 will
not allow you to connect to 1.0 databases.
>
>
>
> > >Compile and install 1.01, but DO NOT do the initdb step. > > > >Before doing anything else, terminate your 1.0 postmaster, and
backup your existing $PGDATA directory.
>
> > >Set your PGDATA environment variable to your 1.0 databases, but set up
path up so that 1.01 binaries are being used.
>
> > >Modify the file $PGDATA/PG_VERSION from 5.0 to 5.1 > > > >Start up a new 1.01 postmaster > > > >Add the new built-in functions and operators of 1.01 to 1.0
databases. This is done by running the new 1.01 server against
your own 1.0 database and applying the queries attached and saving
in the file 1.0_to_1.01.sql. This can be done easily through psql.
If your 1.0 database is name "testdb":

CLASS="PROGRAMLISTING"
> % psql testdb -f 1.0_to_1.01.sql
>

and then execute the following commands (cut and paste from here):

CLASS="PROGRAMLISTING"
>-- 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);
>
>
>
> CLASS="SECT2"
> NAME="AEN2261"
>Подробный список изменений
>
> > CLASS="PROGRAMLISTING"
>Incompatibilities:
* 1.01 is backwards compatible with 1.0 database provided the user
follow the steps outlined in the MIGRATION_from_1.0_to_1.01 file.
If those steps are not taken, 1.01 is not compatible with 1.0 database.

Enhancements:
* added PQdisplayTuples() to libpq and changed monitor and psql to use it
* added NeXT port (requires SysVIPC implementation)
* added CAST .. AS ... syntax
* added ASC and DESC keywords
* added 'internal' as a possible language for CREATE FUNCTION
internal functions are C functions which have been statically linked
into the postgres backend.
* a new type "name" has been added for system identifiers (table names,
attribute names, etc.) This replaces the old char16 type. The
of name is set by the NAMEDATALEN #define in src/Makefile.global
* a readable reference manual that describes the query language.
* added host-based access control. A configuration file ($PGDATA/pg_hba)
is used to hold the configuration data. If host-based access control
is not desired, comment out HBA=1 in src/Makefile.global.
* changed regex handling to be uniform use of Henry Spencer's regex code
regardless of platform. The regex code is included in the distribution
* added functions and operators for case-insensitive regular expressions.
The operators are ~* and !~*.
* pg_dump uses COPY instead of SELECT loop for better performance

Bug fixes:
* fixed an optimizer bug that was causing core dumps when
functions calls were used in comparisons in the WHERE clause
* changed all uses of getuid to geteuid so that effective uids are used
* psql now returns non-zero status on errors when using -c
* applied public patches 1-14
>
> ALIGN="LEFT"
WIDTH="100%"> WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
> > WIDTH="33%"
ALIGN="left"
VALIGN="top"
> HREF="5875.html"
>Предыдущий
>
> WIDTH="34%"
ALIGN="center"
VALIGN="top"
> HREF="671.html"
>Начало
>
> WIDTH="33%"
ALIGN="right"
VALIGN="top"
> HREF="5877.html"
>Следующий
>
>
> > WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Выпуск v1.02
> WIDTH="34%"
ALIGN="center"
VALIGN="top"
> HREF="5861.html"
>В начало главы
>
> WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Выпуск v1.0
>
>
> > >

  • Главная
  • Новости
  • Новинки
  • Скрипты
  • Форум
  • Ссылки
  • О сайте




  • Emanual.ru – это сайт, посвящённый всем значимым событиям в IT-индустрии: новейшие разработки, уникальные методы и горячие новости! Тонны информации, полезной как для обычных пользователей, так и для самых продвинутых программистов! Интересные обсуждения на актуальные темы и огромная аудитория, которая может быть интересна широкому кругу рекламодателей. У нас вы узнаете всё о компьютерах, базах данных, операционных системах, сетях, инфраструктурах, связях и программированию на популярных языках!
     Copyright © 2001-2024
    Реклама на сайте