forum.lissyara.su

f0s · Непрочитанное сообщение **f0s** » 2008-03-05 19:40:39

есть вопрос касательно Postgresql. А именно версии 8.3, недавно вышедшей.

основные изменения в ней такие:

* миграция модуля для полнотекстового поиска (contrib/tsearch2) в ядро системы;
* реализация Heap Only Tuples (HOT);
* теперь autovacuum включён по умолчанию;
* возможен запуск сразу нескольких процессов autovacuum;
* заметное уменьшение дискового пространства, занимаемого базами данных;
* выполнение транзакций, не модифицирующих данные, не приводит к увеличению значения счётчика транзакций (xid);
* реализован механизм автонастройки параметров процесса bgwriter;
* оптимизирован механизм получения результата для запросов с использованием « …ORDER BY … LIMIT…» (т. н. Top-N sorting);
* поддержка XML, в том числе новый тип данных - xml;
* автоматическая инвалидация кэша плана запросов для PL/pgSQL-функций;
* конструкции «CREATE FUNCTION … RETURNS TABLE» и «RETURN TABLE…» для создания функций, результатом которых является таблица;
* поддержка операции обновления для курсоров;
* стандартная (ISO/ANSI SQL) конструкция «ORDER BY … NULLS FIRST/LAST» для упрощения установки порядка следования NULL-значений (также помогает при миграции с других СУБД);
* индексация NULL-значений в GiST-индексах.

Подробное описание на русском языке: http://postgresmen.ru/articles/view/78

интересует вопрос такого плана: что нужно дополнить из патчей 1с-овских для 1с8.1 на постгре 8.3 чтобы это все прекрасно взлетело? отовый постгре от 1с скачивать не предлагайте.. он под линух заточне.. а мне под фряхой нужно....

Хостинг HostFood.ru · **Хостинг HostFood.ru**

Тарифы на хостинг в России, от 12 рублей: https://www.host-food.ru/tariffs/hosting/
Тарифы на виртуальные сервера (VPS/VDS/KVM) в РФ, от 189 руб.: https://www.host-food.ru/tariffs/virtualny-server-vps/
Выделенные сервера, Россия, Москва, от 2000 рублей (HP Proliant G5, Intel Xeon E5430 (2.66GHz, Quad-Core, 12Mb), 8Gb RAM, 2x300Gb SAS HDD, P400i, 512Mb, BBU):
https://www.host-food.ru/tariffs/vydelennyi-server-ds/
Недорогие домены в популярных зонах: https://www.host-food.ru/domains/

hizel · Непрочитанное сообщение **hizel** » 2008-03-05 19:46:11

http://v8.1c.ru/overview/postgres_patches_notes.htm
гугел однако

сдается мне, что с 8.3 ничего не получится
разве, что лапками, если программировать умеете

f0s · Непрочитанное сообщение **f0s** » 2008-03-06 10:24:29

hizel писал(а):http://v8.1c.ru/overview/postgres_patches_notes.htm
гугел однако

сдается мне, что с 8.3 ничего не получится
разве, что лапками, если программировать умеете

а что гугл? данную ссылку я курил.. давай покурим вместе:

1) там указано для версии 8.2.4, я же говорю про 8.3
2) в одном из патчей: патч устраняющий проблему блокировок при использовании AUTOVACUUM (в 8.3 это уже есть)
3) с регистром там тоже что-то сделали

в общем походу я считаю лучше накатат из портов 8.3 идополнить однимм-двумя патчиками.. просто непонятно, что 1с-воцы имеет ввиду под: "пакет c исходными кодами PostgreSQL версии 8.2.4, включающий все необходимые патчи для обеспечения совместимости с сервером 1С:Предприятия 8.1".. а что значит все необходимые - х3

hizel · Непрочитанное сообщение **hizel** » 2008-03-06 10:34:45

помоему, читать там бесполезно
надо в исходники думаю смотреть

этот текст какой-то маркетолог там накатал, без знания предмета

aleksey.kravchenko

Я думаю, этим не стоит заниматься. Т.к. нет гарантий, что 1с будет корректно работать с версией 8.3. В свое время реализовывал проект 1с+постгрес, но на линухе. Так вот там не каждый релиз 8.1 будет работать с последней версией постгреса. Ну, например, PostgreSQL 8.2.4-6.1C работает с 1с 8.1.9.хх и т.д. Короче, используй 8.2, и не морочь себе яйца.

f0s · Непрочитанное сообщение **f0s** » 2008-08-18 12:23:18

ок, я согласен. вот что делал я
По данной ссылке: http://www.v8.1c.ru/overview/postgres_patches_notes.htm, скачал три патча:

http://www.v8.1c.ru/overview/postgresql ... 0.18.patch
http://www.v8.1c.ru/overview/postgresql ... -8.2.patch
http://www.v8.1c.ru/overview/postgresql ... .2.4.patch

На этой страничке: http://www.v8.1c.ru/overview/postgres_patches_notes.htm написано, что версия постгре должна быть 8.2.4... в портах только 8.2.9. в общем в supfile указал дату 2007 год, ноябрь, скачал ветку портов database, зашел в postgresql82-server, там как раз 8.2.4

Код: Выделить всё

cd /usr/ports/databases/potgresql82-server
# make fetch
# make checksum
# make extract
# make patch
# cd work/postgresql-8.2.4/src/
patch -p1 < 1c_FULL_82-0.18.patch
 
 
[skip]
--------------------------
Patching file backend/parser/gram.y using Plan A...
Hunk #1 succeeded at 106.
Hunk #2 succeeded at 232.
Hunk #3 succeeded at 326.
Hunk #4 succeeded at 401.
Hunk #5 succeeded at 466.
Hunk #6 succeeded at 3862.
Hunk #7 succeeded at 3879.
Hunk #8 succeeded at 3891.
Hunk #9 succeeded at 5835.
Hunk #10 succeeded at 6410.
Hunk #11 succeeded at 6440.
Hunk #12 succeeded at 6449.
Hunk #13 succeeded at 7003.
Hunk #14 succeeded at 7015.
Hunk #15 succeeded at 7027.
Hunk #16 succeeded at 7039.
Hunk #17 succeeded at 7052.
Hunk #18 succeeded at 7062.
Hunk #19 succeeded at 7074.
Hunk #20 succeeded at 7084.
Hunk #21 succeeded at 8418.
Hunk #22 succeeded at 8483.
Hunk #23 succeeded at 8577.
Hunk #24 succeeded at 8733.
Hunk #25 succeeded at 9402.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/parser/keywords.c src/backend/parser/keywords.c
|*** src.orig/backend/parser/keywords.c Mon Sep 24 18:56:31 2007
|--- src/backend/parser/keywords.c      Mon Sep 24 19:06:09 2007
--------------------------
Patching file backend/parser/keywords.c using Plan A...
Hunk #1 succeeded at 239.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/parser/parse_clause.c src/backend/parser/parse_clause.c
|*** src.orig/backend/parser/parse_clause.c     Mon Sep 24 18:56:31 2007
|--- src/backend/parser/parse_clause.c  Mon Sep 24 19:06:09 2007
--------------------------
Patching file backend/parser/parse_clause.c using Plan A...
Hunk #1 succeeded at 1129.
Hunk #2 succeeded at 1165.
Hunk #3 succeeded at 1224.
Hunk #4 succeeded at 1256.
Hunk #5 succeeded at 1511.
Hunk #6 succeeded at 1586.
Hunk #7 succeeded at 1635.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/utils/adt/format_type.c src/backend/utils/adt/format_type.c
|*** src.orig/backend/utils/adt/format_type.c   Mon Sep 24 18:56:27 2007
|--- src/backend/utils/adt/format_type.c        Mon Sep 24 19:06:09 2007
--------------------------
Patching file backend/utils/adt/format_type.c using Plan A...
Hunk #1 succeeded at 396.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/utils/adt/selfuncs.c src/backend/utils/adt/selfuncs.c
|*** src.orig/backend/utils/adt/selfuncs.c      Mon Sep 24 18:56:27 2007
|--- src/backend/utils/adt/selfuncs.c   Mon Sep 24 19:06:09 2007
--------------------------
Patching file backend/utils/adt/selfuncs.c using Plan A...
Hunk #1 succeeded at 5036 (offset -26 lines).
Hunk #2 succeeded at 5077 (offset -26 lines).
Hunk #3 succeeded at 5108 (offset -26 lines).
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/include/access/skey.h src/include/access/skey.h
|*** src.orig/include/access/skey.h     Mon Sep 24 18:56:39 2007
|--- src/include/access/skey.h  Mon Sep 24 19:06:09 2007
--------------------------
Patching file include/access/skey.h using Plan A...
Hunk #1 succeeded at 106.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/include/nodes/relation.h src/include/nodes/relation.h
|*** src.orig/include/nodes/relation.h  Mon Sep 24 18:56:40 2007
|--- src/include/nodes/relation.h       Mon Sep 24 19:06:09 2007
--------------------------
Patching file include/nodes/relation.h using Plan A...
Hunk #1 succeeded at 525.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/include/optimizer/pathnode.h src/include/optimizer/pathnode.h
|*** src.orig/include/optimizer/pathnode.h      Mon Sep 24 18:56:40 2007
|--- src/include/optimizer/pathnode.h   Mon Sep 24 19:06:09 2007
--------------------------
Patching file include/optimizer/pathnode.h using Plan A...
Hunk #1 succeeded at 46.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/include/optimizer/paths.h src/include/optimizer/paths.h
|*** src.orig/include/optimizer/paths.h Mon Sep 24 18:56:40 2007
|--- src/include/optimizer/paths.h      Mon Sep 24 19:06:09 2007
--------------------------
Patching file include/optimizer/paths.h using Plan A...
Hunk #1 succeeded at 64 (offset -1 lines).
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/include/optimizer/planmain.h src/include/optimizer/planmain.h
|*** src.orig/include/optimizer/planmain.h      Mon Sep 24 18:56:40 2007
|--- src/include/optimizer/planmain.h   Mon Sep 24 19:06:09 2007
--------------------------
Patching file include/optimizer/planmain.h using Plan A...
Hunk #1 succeeded at 60.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/test/regress/expected/select.out src/test/regress/expected/select.out
|*** src.orig/test/regress/expected/select.out  Mon Sep 24 18:56:34 2007
|--- src/test/regress/expected/select.out       Mon Sep 24 19:06:09 2007
--------------------------
# на этом этапе он спросил что патчить, я ответил Makefile
 
File to patch:
No file found--skip this patch? [n] Makefile
File to patch: Makefile
Patching file Makefile using Plan A...
Hunk #1 succeeded at 512 with fuzz 2 (offset -1 lines).
patch: **** misordered hunks! output would be garbled

запустил следующий:

Код: Выделить всё

[f0s@fileserver] /usr/ports/databases/postgresql82-server/work/postgresql-8.2.4/src/> patch -p2 < postgresql-1c-8.2.patch
Hmm...  Looks like a unified diff to me...
The text leading up to this was:
--------------------------
|diff -u -r postgresql-8.2.0.orig/contrib/Makefile postgresql-8.2.0/contrib/Makefile
|--- postgresql-8.2.0.orig/contrib/Makefile     Sat Sep  9 08:07:52 2006
|+++ postgresql-8.2.0/contrib/Makefile  Fri Dec 15 17:14:33 2006
--------------------------
Patching file Makefile using Plan A...
Hunk #1 failed at 30.
1 out of 1 hunks failed--saving rejects to Makefile.rej
Hmm...  The next patch looks like a unified diff to me...
The text leading up to this was:
--------------------------
|diff -u -r postgresql-8.2.0.orig/src/backend/libpq/pg_hba.conf.sample postgresql-8.2.0/src/backend/libpq/pg_hba.conf.sample
|--- postgresql-8.2.0.orig/src/backend/libpq/pg_hba.conf.sample Thu Oct 12 03:01:46 2006
|+++ postgresql-8.2.0/src/backend/libpq/pg_hba.conf.sample      Fri Dec 15 17:23:39 2006
--------------------------
Patching file backend/libpq/pg_hba.conf.sample using Plan A...
Hunk #1 succeeded at 63.
Hmm...  The next patch looks like a unified diff to me...
The text leading up to this was:
--------------------------
|diff -u -r postgresql-8.2.0.orig/src/backend/utils/misc/postgresql.conf.sample postgresql-8.2.0/src/backend/utils/misc/postgresql.conf.sample
|--- postgresql-8.2.0.orig/src/backend/utils/misc/postgresql.conf.sample        Tue Nov 21 04:23:38 2006
|+++ postgresql-8.2.0/src/backend/utils/misc/postgresql.conf.sample     Fri Dec 15 17:22:31 2006
--------------------------
Patching file backend/utils/misc/postgresql.conf.sample using Plan A...
Hunk #1 succeeded at 53 (offset 3 lines).
Hunk #2 succeeded at 101 (offset 3 lines).
Hunk #3 succeeded at 198 (offset 3 lines).
Hunk #4 succeeded at 348 (offset 2 lines).
Hunk #5 succeeded at 367 with fuzz 2 (offset 5 lines).
Hunk #6 succeeded at 436 (offset 2 lines).
done

потом еще и третий.. тоже писал там вручную Makefile:

Код: Выделить всё

[f0s@fileserver] /usr/ports/databases/postgresql82-server/work/postgresql-8.2.4/src/> patch -p3 < applock-1c-8.2.4.patch
Hmm...  Looks like a unified diff to me...
The text leading up to this was:
--------------------------
|diff -r -u postgresql-8.2.3.orig/doc/src/sgml/ref/lock.sgml postgresql-8.2.3/doc/src/sgml/ref/lock.sgml
|--- postgresql-8.2.3.orig/doc/src/sgml/ref/lock.sgml   Sat Sep 16 04:30:19 2006
|+++ postgresql-8.2.3/doc/src/sgml/ref/lock.sgml        Mon Feb 12 17:42:31 2007
--------------------------
File to patch: Makefile
Patching file Makefile using Plan A...
Hunk #1 failed at 26.
1 out of 1 hunks failed--saving rejects to Makefile.rej
Hmm...  The next patch looks like a unified diff to me...
The text leading up to this was:
--------------------------
|diff -r -u postgresql-8.2.3.orig/src/backend/parser/gram.y postgresql-8.2.3/src/backend/parser/gram.y
|--- postgresql-8.2.3.orig/src/backend/parser/gram.y    Mon Feb 12 18:19:12 2007
|+++ postgresql-8.2.3/src/backend/parser/gram.y Mon Feb 12 18:08:35 2007
--------------------------
File to patch: Makefile
Patching file Makefile using Plan A...
Hunk #1 failed at 356.
Hunk #2 failed at 5486.
Hunk #3 failed at 8833.
3 out of 3 hunks failed--saving rejects to Makefile.rej
Hmm...  The next patch looks like a unified diff to me...
The text leading up to this was:
--------------------------
|diff -r -u postgresql-8.2.3.orig/src/backend/parser/keywords.c postgresql-8.2.3/src/backend/parser/keywords.c
|--- postgresql-8.2.3.orig/src/backend/parser/keywords.c        Mon Feb 12 18:19:12 2007
|+++ postgresql-8.2.3/src/backend/parser/keywords.c     Mon Feb 12 17:42:31 2007
--------------------------
File to patch: Makefile
Patching file Makefile using Plan A...
Hunk #1 failed at 46.
1 out of 1 hunks failed--saving rejects to Makefile.rej
Hmm...  The next patch looks like a unified diff to me...
The text leading up to this was:
--------------------------
|diff -r -u postgresql-8.2.3.orig/src/backend/storage/lmgr/lock.c postgresql-8.2.3.patched/src/backend/storage/lmgr/lock.c
|--- postgresql-8.2.3.orig/src/backend/storage/lmgr/lock.c      2006-10-04 04:29:57.000000000 +0400
|+++ postgresql-8.2.3/src/backend/storage/lmgr/lock.c   2007-03-09 13:20:04.348635100 +0300
--------------------------
File to patch: Makefile
Patching file Makefile using Plan A...
Hunk #1 failed at 93.
Hunk #2 failed at 114.
Hunk #3 failed at 124.
Hunk #4 failed at 136.
4 out of 4 hunks failed--saving rejects to Makefile.rej
Hmm...  The next patch looks like a unified diff to me...
The text leading up to this was:
--------------------------
|diff -r -u postgresql-8.2.3.orig/src/include/storage/lock.h postgresql-8.2.3/src/include/storage/lock.h
|--- postgresql-8.2.3.orig/src/include/storage/lock.h   Thu Nov 23 08:14:04 2006
|+++ postgresql-8.2.3/src/include/storage/lock.h        Mon Feb 12 18:10:28 2007
--------------------------
File to patch: Makefile
Patching file Makefile using Plan A...
Hunk #1 failed at 50.
Hunk #2 failed at 118.
2 out of 2 hunks failed--saving rejects to Makefile.rej
done

что я делаю не так??

aleksey.kravchenko

Так, хорошо. Давай по-порядку:
1. Я использовал PostgreSQL в пакетах rpm на centos. На фре не пробовал. Хоть и хотелось)
2. У тебя версия 1с - выше 8.1.10? Тогда ты правильно используешь 1c_FULL_82-0.18.patch.
3. По идее патч 1c_FULL_82-0.18.patch содержит все необходимые изменения.
4. Еще раз сделай

Код: Выделить всё

patch -p0 < 1c_FULL_82-0.18.patch

5. Скомпилируй и установи постгрес
6. Проверь работу с 1с.
7. Отпишись)

Да, кстати, а зачем это: -p1. -p2, -p3? ) Этот аргумент не для номера патча, а для определения путей. Собственно, из-за этого патчи могли и не сработать.

f0s · Непрочитанное сообщение **f0s** » 2008-08-19 8:53:29

aleksey.kravchenko писал(а):Так, хорошо. Давай по-порядку:
1. Я использовал PostgreSQL в пакетах rpm на centos. На фре не пробовал. Хоть и хотелось)
2. У тебя версия 1с - выше 8.1.10? Тогда ты правильно используешь 1c_FULL_82-0.18.patch.
3. По идее патч 1c_FULL_82-0.18.patch содержит все необходимые изменения.
4. Еще раз сделай
Код: Выделить всё
patch -p0 < 1c_FULL_82-0.18.patch
5. Скомпилируй и установи постгрес
6. Проверь работу с 1с.
7. Отпишись)

Да, кстати, а зачем это: -p1. -p2, -p3? ) Этот аргумент не для номера патча, а для определения путей. Собственно, из-за этого патчи могли и не сработать.

да, версия 1с у меня 8.1.11.67

то есть мне нужно прикрутить только один патч?? а два других тогда зачем - почему они фигурироуют на сайте?

f0s · Непрочитанное сообщение **f0s** » 2008-08-19 8:58:28

и почему-то когда этот FULL_PATCH применяю.. все вроде сначала хорошо идет, а потом выдается:

Код: Выделить всё

--------------------------
|diff -c -r -N src.orig/test/regress/expected/select.out src/test/regress/expected/select.out
|*** src.orig/test/regress/expected/select.out  Mon Sep 24 18:56:34 2007
|--- src/test/regress/expected/select.out       Mon Sep 24 19:06:09 2007
--------------------------

File to patch:

что ему овтетить? пробовал написать Makefile:

Код: Выделить всё

No file found--skip this patch? [n] Makefile
File to patch: Makefile
Patching file Makefile using Plan A...
Hunk #1 succeeded at 512 with fuzz 2 (offset -1 lines).
patch: **** misordered hunks! output would be garbled

aleksey.kravchenko

Попробуй так:

Код: Выделить всё

cd /usr/ports/databases/potgresql82-server
# make fetch
# make checksum
# make extract
# make patch
# cd work/postgresql-8.2.4/
# wget http://v8.1c.ru/overview/postgresql_patches/1c_FULL_82-0.18.patch
# wget http://v8.1c.ru/overview/postgresql_patches/postgresql-1c-8.2.patch
# wget http://v8.1c.ru/overview/postgresql_patches/applock-1c-8.2.4.patch
# patch -p0 < 1c_FULL_82-0.18.patch
# patch -p1 < postgresql-1c-8.2.patch
# patch -p1 < applock-1c-8.2.4.patch

f0s · Непрочитанное сообщение **f0s** » 2008-08-19 14:54:44

начал применять первый патч... полезли глюки:

Код: Выделить всё


--------------------------
Patching file src/include/optimizer/planmain.h using Plan A...
Hunk #1 succeeded at 60.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/test/regress/expected/select.out src/test/regress/expected/select.out
|*** src.orig/test/regress/expected/select.out  Mon Sep 24 18:56:34 2007
|--- src/test/regress/expected/select.out       Mon Sep 24 19:06:09 2007
--------------------------
File to patch:
No file found--skip this patch? [n] y
Skipping patch...
Hunk #1 ignored at 513.
1 out of 1 hunks ignored--saving rejects to src/test/regress/expected/select.out.rej
Can't create src/test/regress/expected/select.out.rej, output is in /tmp//patchrFD1a6m: No such file or directory
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/test/regress/sql/select.sql src/test/regress/sql/select.sql
|*** src.orig/test/regress/sql/select.sql       Mon Sep 24 18:56:34 2007
|--- src/test/regress/sql/select.sql    Mon Sep 24 19:06:09 2007
--------------------------
File to patch:
No file found--skip this patch? [n] y
Skipping patch...
Hunk #1 ignored at 138.
1 out of 1 hunks ignored--saving rejects to src/test/regress/sql/select.sql.rej
Can't create src/test/regress/sql/select.sql.rej, output is in /tmp//patchrFD1a6m: No such file or directory
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N doc.orig/src/sgml/ref/select.sgml doc/src/sgml/ref/select.sgml
|*** doc.orig/src/sgml/ref/select.sgml  Mon Sep 24 18:56:42 2007
|--- doc/src/sgml/ref/select.sgml       Mon Sep 24 19:06:09 2007
--------------------------
File to patch: y
No file found--skip this patch? [n] y
Skipping patch...
Hunk #1 ignored at 27.
Hunk #2 ignored at 642.
Hunk #3 ignored at 705.
3 out of 3 hunks ignored--saving rejects to y.rej
done
[f0s@fileserver] /usr/ports/databases/postgresql82-server/work/postgresql-8.2.4/> cat y.rej
***************
*** 27,33 ****
      [ GROUP BY <replaceable class="parameter">expression</replaceable> [, ...] ]
      [ HAVING <replaceable class="parameter">condition</replaceable> [, ...] ]
      [ { UNION | INTERSECT | EXCEPT } [ ALL ] <replaceable class="parameter">select</replaceable> ]
!     [ ORDER BY <replaceable class="parameter">expression</replaceable> [ ASC | DESC | USING <replaceable class="parameter">operator</replaceable> ] [, ...] ]
      [ LIMIT { <replaceable class="parameter">count</replaceable> | ALL } ]
      [ OFFSET <replaceable class="parameter">start</replaceable> ]
      [ FOR { UPDATE | SHARE } [ OF <replaceable class="parameter">table_name</replaceable> [, ...] ] [ NOWAIT ] [...] ]
--- 27,33 ----
      [ GROUP BY <replaceable class="parameter">expression</replaceable> [, ...] ]
      [ HAVING <replaceable class="parameter">condition</replaceable> [, ...] ]
      [ { UNION | INTERSECT | EXCEPT } [ ALL ] <replaceable class="parameter">select</replaceable> ]
!     [ ORDER BY <replaceable class="parameter">expression</replaceable> [ ASC | DESC | USING <replaceable class="parameter">operator</replaceable> ] [ NULLS ( FIRST | LAST ) ] [, ...] ]
      [ LIMIT { <replaceable class="parameter">count</replaceable> | ALL } ]
      [ OFFSET <replaceable class="parameter">start</replaceable> ]
      [ FOR { UPDATE | SHARE } [ OF <replaceable class="parameter">table_name</replaceable> [, ...] ] [ NOWAIT ] [...] ]
***************
*** 642,648 ****
     <para>
      The optional <literal>ORDER BY</literal> clause has this general form:
  <synopsis>
! ORDER BY <replaceable class="parameter">expression</replaceable> [ ASC | DESC | USING <replaceable class="parameter">operator</replaceable> ] [, ...]
  </synopsis>
      <replaceable class="parameter">expression</replaceable> can be the
      name or ordinal number of an output column
--- 642,648 ----
     <para>
      The optional <literal>ORDER BY</literal> clause has this general form:
  <synopsis>
! ORDER BY <replaceable class="parameter">expression</replaceable> [ ASC | DESC | USING <replaceable class="parameter">operator</replaceable> ] [ NULLS ( FIRST | LAST ) ] [, ...]
  </synopsis>
      <replaceable class="parameter">expression</replaceable> can be the
      name or ordinal number of an output column
***************
*** 705,713 ****
     </para>

     <para>
!     The null value sorts higher than any other value. In other words,
!     with ascending sort order, null values sort at the end, and with
!     descending sort order, null values sort at the beginning.
     </para>

     <para>
--- 705,714 ----
     </para>

     <para>
!     By default, the null value sorts higher than any other value.
!       In other words, with ascending sort order, null values sort at the end,
!       and with descending sort order, null values sort at the beginning. Thats
!       can be changed by using NULLS ( FIRST | LAST ) options.
     </para>

     <para>

aleksey.kravchenko

Опять то же самое:

f0s писал(а): File to patch:
No file found--skip this patch? [n] y
Skipping patch...

Сделай так, как я написал в предыдущем ответе. Только внимательно. Дело в том, что я у себя только что патчил, и все было путем.

f0s · Непрочитанное сообщение **f0s** » 2008-08-19 15:29:10

что я делаю не так?

Код: Выделить всё



[f0s@fileserver] /usr/ports/databases/postgresql82-server/> make fetch


  =========== BACKUP YOUR DATA! =============
  As always, backup your data before
  upgrading. If the upgrade leads to a higher
  minor revision (e.g. 7.3.x -> 7.4), a dump
  and restore of all databases is
  required. This is *NOT* done by the port!

  Press ctrl-C *now* if you need to pg_dump.
  ===========================================

===>  Vulnerability check disabled, database not found
===>  Found saved configuration for postgresql-server-8.2.4_1
[f0s@fileserver] /usr/ports/databases/postgresql82-server/> make checksum


  =========== BACKUP YOUR DATA! =============
  As always, backup your data before
  upgrading. If the upgrade leads to a higher
  minor revision (e.g. 7.3.x -> 7.4), a dump
  and restore of all databases is
  required. This is *NOT* done by the port!

  Press ctrl-C *now* if you need to pg_dump.
  ===========================================

===>  Vulnerability check disabled, database not found
===>  Found saved configuration for postgresql-server-8.2.4_1
=> MD5 Checksum OK for postgresql/postgresql-base-8.2.4.tar.bz2.
=> SHA256 Checksum OK for postgresql/postgresql-base-8.2.4.tar.bz2.
=> MD5 Checksum OK for postgresql/postgresql-opt-8.2.4.tar.bz2.
=> SHA256 Checksum OK for postgresql/postgresql-opt-8.2.4.tar.bz2.
[f0s@fileserver] /usr/ports/databases/postgresql82-server/> make extract
[f0s@fileserver] /usr/ports/databases/postgresql82-server/> make patch
[f0s@fileserver] /usr/ports/databases/postgresql82-server/> cd work/postgresql-8.2.4/
[f0s@fileserver] /usr/ports/databases/postgresql82-server/work/postgresql-8.2.4/> cp /tmp/1c_FULL_82-0.18.patch ./
[f0s@fileserver] /usr/ports/databases/postgresql82-server/work/postgresql-8.2.4/> cp /tmp/postgresql-1c-8.2.patch ./
[f0s@fileserver] /usr/ports/databases/postgresql82-server/work/postgresql-8.2.4/> cp /tmp/applock-1c-8.2.4.patch ./
[f0s@fileserver] /usr/ports/databases/postgresql82-server/work/postgresql-8.2.4/> patch -p0 < 1c_FULL_82-0.18.patch

[skip]

Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/executor/nodeIndexscan.c src/backend/executor/nodeIndexscan.c
|*** src.orig/backend/executor/nodeIndexscan.c  Mon Sep 24 18:56:29 2007
|--- src/backend/executor/nodeIndexscan.c       Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/backend/executor/nodeIndexscan.c using Plan A...
Hunk #1 succeeded at 722.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/nodes/outfuncs.c src/backend/nodes/outfuncs.c
|*** src.orig/backend/nodes/outfuncs.c  Mon Sep 24 18:56:33 2007
|--- src/backend/nodes/outfuncs.c       Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/backend/nodes/outfuncs.c using Plan A...
Hunk #1 succeeded at 1105.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/optimizer/path/allpaths.c src/backend/optimizer/path/allpaths.c
|*** src.orig/backend/optimizer/path/allpaths.c Mon Sep 24 18:56:31 2007
|--- src/backend/optimizer/path/allpaths.c      Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/backend/optimizer/path/allpaths.c using Plan A...
Hunk #1 succeeded at 220.
Hunk #2 succeeded at 242.
Hunk #3 succeeded at 397.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/optimizer/path/indxpath.c src/backend/optimizer/path/indxpath.c
|*** src.orig/backend/optimizer/path/indxpath.c Mon Sep 24 18:56:31 2007
|--- src/backend/optimizer/path/indxpath.c      Tue Oct  9 18:27:51 2007
--------------------------
Patching file src/backend/optimizer/path/indxpath.c using Plan A...
Hunk #1 succeeded at 36.
Hunk #2 succeeded at 1196.
Hunk #3 succeeded at 1897 (offset -11 lines).
Hunk #4 succeeded at 2116 (offset -11 lines).
Hunk #5 succeeded at 2500 (offset -11 lines).
Hunk #6 succeeded at 2644 (offset -11 lines).
Hunk #7 succeeded at 2746 (offset -11 lines).
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/optimizer/path/joinpath.c src/backend/optimizer/path/joinpath.c
|*** src.orig/backend/optimizer/path/joinpath.c Mon Sep 24 18:56:31 2007
|--- src/backend/optimizer/path/joinpath.c      Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/backend/optimizer/path/joinpath.c using Plan A...
Hunk #1 succeeded at 852 (offset -19 lines).
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/optimizer/path/orindxpath.c src/backend/optimizer/path/orindxpath.c
|*** src.orig/backend/optimizer/path/orindxpath.c       Mon Sep 24 18:56:31 2007
|--- src/backend/optimizer/path/orindxpath.c    Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/backend/optimizer/path/orindxpath.c using Plan A...
Hunk #1 succeeded at 15.
Hunk #2 succeeded at 227.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/optimizer/plan/createplan.c src/backend/optimizer/plan/createplan.c
|*** src.orig/backend/optimizer/plan/createplan.c       Mon Sep 24 18:56:31 2007
|--- src/backend/optimizer/plan/createplan.c    Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/backend/optimizer/plan/createplan.c using Plan A...
Hunk #1 succeeded at 18.
Hunk #2 succeeded at 73.
Hunk #3 succeeded at 499.
Hunk #4 succeeded at 515.
Hunk #5 succeeded at 530.
Hunk #6 succeeded at 1770 (offset -4 lines).
Hunk #7 succeeded at 1791 (offset -4 lines).
Hunk #8 succeeded at 1811 (offset -4 lines).
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/optimizer/plan/setrefs.c src/backend/optimizer/plan/setrefs.c
|*** src.orig/backend/optimizer/plan/setrefs.c  Mon Sep 24 18:56:31 2007
|--- src/backend/optimizer/plan/setrefs.c       Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/backend/optimizer/plan/setrefs.c using Plan A...
Hunk #1 succeeded at 1226.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/optimizer/util/pathnode.c src/backend/optimizer/util/pathnode.c
|*** src.orig/backend/optimizer/util/pathnode.c Mon Sep 24 18:56:31 2007
|--- src/backend/optimizer/util/pathnode.c      Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/backend/optimizer/util/pathnode.c using Plan A...
Hunk #1 succeeded at 637.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/parser/analyze.c src/backend/parser/analyze.c
|*** src.orig/backend/parser/analyze.c  Mon Sep 24 18:56:31 2007
|--- src/backend/parser/analyze.c       Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/backend/parser/analyze.c using Plan A...
Hunk #1 succeeded at 2358 (offset -4 lines).
Hunk #2 succeeded at 2479 (offset -4 lines).
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/parser/gram.y src/backend/parser/gram.y
|*** src.orig/backend/parser/gram.y     Mon Sep 24 18:56:31 2007
|--- src/backend/parser/gram.y  Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/backend/parser/gram.y using Plan A...
Hunk #1 succeeded at 106.
Hunk #2 succeeded at 232.
Hunk #3 succeeded at 326.
Hunk #4 succeeded at 401.
Hunk #5 succeeded at 466.
Hunk #6 succeeded at 3862.
Hunk #7 succeeded at 3879.
Hunk #8 succeeded at 3891.
Hunk #9 succeeded at 5835.
Hunk #10 succeeded at 6410.
Hunk #11 succeeded at 6440.
Hunk #12 succeeded at 6449.
Hunk #13 succeeded at 7003.
Hunk #14 succeeded at 7015.
Hunk #15 succeeded at 7027.
Hunk #16 succeeded at 7039.
Hunk #17 succeeded at 7052.
Hunk #18 succeeded at 7062.
Hunk #19 succeeded at 7074.
Hunk #20 succeeded at 7084.
Hunk #21 succeeded at 8418.
Hunk #22 succeeded at 8483.
Hunk #23 succeeded at 8577.
Hunk #24 succeeded at 8733.
Hunk #25 succeeded at 9402.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/parser/keywords.c src/backend/parser/keywords.c
|*** src.orig/backend/parser/keywords.c Mon Sep 24 18:56:31 2007
|--- src/backend/parser/keywords.c      Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/backend/parser/keywords.c using Plan A...
Hunk #1 succeeded at 239.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/parser/parse_clause.c src/backend/parser/parse_clause.c
|*** src.orig/backend/parser/parse_clause.c     Mon Sep 24 18:56:31 2007
|--- src/backend/parser/parse_clause.c  Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/backend/parser/parse_clause.c using Plan A...
Hunk #1 succeeded at 1129.
Hunk #2 succeeded at 1165.
Hunk #3 succeeded at 1224.
Hunk #4 succeeded at 1256.
Hunk #5 succeeded at 1511.
Hunk #6 succeeded at 1586.
Hunk #7 succeeded at 1635.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/utils/adt/format_type.c src/backend/utils/adt/format_type.c
|*** src.orig/backend/utils/adt/format_type.c   Mon Sep 24 18:56:27 2007
|--- src/backend/utils/adt/format_type.c        Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/backend/utils/adt/format_type.c using Plan A...
Hunk #1 succeeded at 396.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/backend/utils/adt/selfuncs.c src/backend/utils/adt/selfuncs.c
|*** src.orig/backend/utils/adt/selfuncs.c      Mon Sep 24 18:56:27 2007
|--- src/backend/utils/adt/selfuncs.c   Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/backend/utils/adt/selfuncs.c using Plan A...
Hunk #1 succeeded at 5036 (offset -26 lines).
Hunk #2 succeeded at 5077 (offset -26 lines).
Hunk #3 succeeded at 5108 (offset -26 lines).
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/include/access/skey.h src/include/access/skey.h
|*** src.orig/include/access/skey.h     Mon Sep 24 18:56:39 2007
|--- src/include/access/skey.h  Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/include/access/skey.h using Plan A...
Hunk #1 succeeded at 106.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/include/nodes/relation.h src/include/nodes/relation.h
|*** src.orig/include/nodes/relation.h  Mon Sep 24 18:56:40 2007
|--- src/include/nodes/relation.h       Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/include/nodes/relation.h using Plan A...
Hunk #1 succeeded at 525.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/include/optimizer/pathnode.h src/include/optimizer/pathnode.h
|*** src.orig/include/optimizer/pathnode.h      Mon Sep 24 18:56:40 2007
|--- src/include/optimizer/pathnode.h   Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/include/optimizer/pathnode.h using Plan A...
Hunk #1 succeeded at 46.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/include/optimizer/paths.h src/include/optimizer/paths.h
|*** src.orig/include/optimizer/paths.h Mon Sep 24 18:56:40 2007
|--- src/include/optimizer/paths.h      Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/include/optimizer/paths.h using Plan A...
Hunk #1 succeeded at 64 (offset -1 lines).
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/include/optimizer/planmain.h src/include/optimizer/planmain.h
|*** src.orig/include/optimizer/planmain.h      Mon Sep 24 18:56:40 2007
|--- src/include/optimizer/planmain.h   Mon Sep 24 19:06:09 2007
--------------------------
Patching file src/include/optimizer/planmain.h using Plan A...
Hunk #1 succeeded at 60.
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|diff -c -r -N src.orig/test/regress/expected/select.out src/test/regress/expected/select.out
|*** src.orig/test/regress/expected/select.out  Mon Sep 24 18:56:34 2007
|--- src/test/regress/expected/select.out       Mon Sep 24 19:06:09 2007
--------------------------
File to patch:

f0s · Непрочитанное сообщение **f0s** » 2008-08-19 15:31:01

ну нету у меян в каталоге src папки test:

Код: Выделить всё

[f0s@fileserver] /usr/ports/databases/postgresql82-server/work/postgresql-8.2.4/src/> ll
total 62
-rw-r--r--   1 root  wheel    120 10 июл  2006 DEVELOPERS
-rw-r--r--   1 root  wheel   1998 23 июн  2006 Makefile
-rw-r--r--   1 root  wheel  16284  8 окт  2006 Makefile.global.in
-rw-r--r--   1 root  wheel  11981 19 сен  2006 Makefile.shlib
drwxr-xr-x  21 root  wheel    512 20 апр  2007 backend
-rw-r--r--   1 root  wheel   1396  6 окт  2006 bcc32.mak
drwxr-xr-x  12 root  wheel    512 20 апр  2007 bin
drwxr-xr-x  20 root  wheel   1024 20 апр  2007 include
drwxr-xr-x   4 root  wheel    512 20 апр  2007 interfaces
drwxr-xr-x   2 root  wheel   1024 19 авг 16:22 makefiles
-rw-r--r--   1 root  wheel   3628  5 апр  2006 nls-global.mk
drwxr-xr-x   6 root  wheel    512 19 авг 16:22 pl
drwxr-xr-x   2 root  wheel   1024 20 апр  2007 port
drwxr-xr-x   2 root  wheel    512 20 апр  2007 template
drwxr-xr-x   4 root  wheel    512 20 апр  2007 timezone
drwxr-xr-x  11 root  wheel    512 20 апр  2007 tools
drwxr-xr-x   2 root  wheel    512 20 апр  2007 tutorial
-rw-r--r--   1 root  wheel   1075  9 авг  2006 win32.mak
[f0s@fileserver] /usr/ports/databases/postgresql82-server/work/postgresql-8.2.4/src/>

f0s · Непрочитанное сообщение **f0s** » 2008-08-19 15:32:54

aleksey.kravchenko писал(а): Сделай так, как я написал в предыдущем ответе. Только внимательно. Дело в том, что я у себя только что патчил, и все было путем.

какая у тебюя версия freebsd и скажу дату дерева портов... я тсавил дату 2007-07-11, версия postgre 8.2.4_1

aleksey.kravchenko

У меня FreeBSD 7.0-RELEASE, версия PostgreSQL - 8.2.9. Но это в вмваре.
Вообще на лептопе стоит альт линух. Скачивал postgresql-8.2.4,-8.2.5.tar.bz2
Везде - нормально патчится. И везде есть src/test.
Но! после этого решил попробовать скомпилировать - не получилось. Всегда с одинаковой ошибкой:

Код: Выделить всё

keywords.c:49: error: ‘APPLICATION’ undeclared here (not in a function)
keywords.c:243: error: ‘NULLS_P’ undeclared here (not in a function)
make[3]: *** [keywords.o] Error 1
make[3]: Leaving directory `/home/krav/postgresql-my/postgresql-8.2.4/src/backend/parser'
make[2]: *** [parser-recursive] Error 2
make[2]: Leaving directory `/home/krav/postgresql-my/postgresql-8.2.4/src/backend'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/home/krav/postgresql-my/postgresql-8.2.4/src'
make: *** [all] Error 2

хз что за ошибка...

f0s · Непрочитанное сообщение **f0s** » 2008-08-19 15:50:37

aleksey.kravchenko писал(а):У меня FreeBSD 7.0-RELEASE, версия PostgreSQL - 8.2.9. Но это в вмваре.
Вообще на лептопе стоит альт линух. Скачивал postgresql-8.2.4,-8.2.5.tar.bz2
Везде - нормально патчится. И везде есть src/test.
Но! после этого решил попробовать скомпилировать - не получилось. Всегда с одинаковой ошибкой:
Код: Выделить всё
keywords.c:49: error: ‘APPLICATION’ undeclared here (not in a function)
keywords.c:243: error: ‘NULLS_P’ undeclared here (not in a function)
make[3]: *** [keywords.o] Error 1
make[3]: Leaving directory `/home/krav/postgresql-my/postgresql-8.2.4/src/backend/parser'
make[2]: *** [parser-recursive] Error 2
make[2]: Leaving directory `/home/krav/postgresql-my/postgresql-8.2.4/src/backend'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/home/krav/postgresql-my/postgresql-8.2.4/src'
make: *** [all] Error 2
хз что за ошибка...

так патчил ты 8.2.4 или 8.2.9? есоли первое, то какую дату для портов указывал?

aleksey.kravchenko

патчил 8.2.4(линух), 8.2.5(линух), 8.2.9(фря в вмваре). Какая дата портов - не помню, надо загружаться в винду...

forum.lissyara.su

8.3

8.3

Услуги хостинговой компании Host-Food.ru

Re: 8.3

Re: 8.3

Re: 8.3

Re: 8.3

Re: 8.3

Re: 8.3

Re: 8.3

Re: 8.3

Re: 8.3

Re: 8.3

Re: 8.3

Re: 8.3

Re: 8.3

Re: 8.3

Re: 8.3

Re: 8.3

Re: 8.3