Re: Enderbury Island disappeared from timezone database

2023-10-28 Thread Victor Wagner
if we just dropped it from the Default list. > (We could keep the Pacific.txt entry, although re-pointing it > to Pacific/Kanton seems advisable.) > > regards, tom lane > > -- Victor Wagner

Re: Enderbury Island disappeared from timezone database

2023-10-27 Thread Victor Wagner
В Fri, 27 Oct 2023 11:17:03 -0400 Tom Lane пишет: > Victor Wagner writes: > > Tom Lane пишет: > >> Did Ubuntu decide to remove *all* backzone links from their data? > >> Or just that one? Either way, I think they're going to get a > >> tsunami of pu

Re: Enderbury Island disappeared from timezone database

2023-10-27 Thread Victor Wagner
В Fri, 27 Oct 2023 10:25:57 -0400 Tom Lane пишет: > Victor Wagner writes: > > I've encountered following problem compiling PostgreSQL 15.4 with > > just released Ubuntu 23.10. > > > I'm compiling postgres with --with-system-tzdata and then regression >

Enderbury Island disappeared from timezone database

2023-10-27 Thread Victor Wagner
, Enderbury should be replaced by Kanton in src/timezone/tznames/Default and src/timezone/tznames/Pacific.txt? -- Victor Wagner

Re: OpenSSL deprectation warnings in Postgres 10-13

2022-04-06 Thread Victor Wagner
В Wed, 6 Apr 2022 15:01:42 +0200 Peter Eisentraut пишет: > On 06.04.22 11:55, Victor Wagner wrote: > > And found out that versions 10-13 produce a lot of warnings about > > deprecated OpenSSL functions. > > > > I've found discussion about this problem >

OpenSSL deprectation warnings in Postgres 10-13

2022-04-06 Thread Victor Wagner
re are more and more distributions switched to OpenSSL 3.0.x. Apart from Ubuntu I can see at least RH 9 beta and experimental packages for Debian which probably would be ready in time for Debian 12. -- Victor Wagner

Re: Postgres Windows build system doesn't work with python installed in Program Files

2020-05-06 Thread Victor Wagner
В Wed, 6 May 2020 21:23:57 -0300 Ranier Vilela пишет: > > The perl is: > Win32 strawberry-perl 5.30.1.1 > This perl would have problems when compiling PL/Perl (see my letter about week ago), but it have no problems running various build scripts for Postgres. I'm using it with MSVisualStudio 20

Re: Postgres Windows build system doesn't work with python installed in Program Files

2020-05-06 Thread Victor Wagner
В Thu, 7 May 2020 09:14:33 +0900 Michael Paquier пишет: > On Wed, May 06, 2020 at 03:58:15PM -0300, Ranier Vilela wrote: > > Hacking pgbison.pl, to print PATH, shows that the path inside > > pgbison.pl, returned to being the original, without the addition of > > c:\perl\bin;c:\bin. my $out = $ENV

Re: Postgres Windows build system doesn't work with python installed in Program Files

2020-05-06 Thread Victor Wagner
В Wed, 6 May 2020 10:21:41 -0300 Ranier Vilela пишет: > Em qua., 6 de mai. de 2020 às 09:53, Michael Paquier > escreveu: > > > On Tue, May 05, 2020 at 10:16:23AM +0300, Victor Wagner wrote: > > > I agree, it is better. > > > > Thanks, applied and ba

Re: Postgres Windows build system doesn't work with python installed in Program Files

2020-05-05 Thread Victor Wagner
В Tue, 5 May 2020 15:45:48 +0900 Michael Paquier пишет: > On Fri, May 01, 2020 at 12:48:17PM +0300, Victor Wagner wrote: > > Maybe. But probably original author of this code was afraid of using > > too long chain of ->{} in the string substitution. > > > >

Postgresql Windows build and modern perl (>=5.28)

2020-05-01 Thread Victor Wagner
Collegues, Postgresql embeded perl, plperl contain code long time ago copied from POSIX.xs file in the perl distribution. It is function setlocale_perl, which does some allocation of perl-specific locale data using functions(or macros) new_ctype, new_collate and new_numeric. This is used only for

Re: Postgres Windows build system doesn't work with python installed in Program Files

2020-05-01 Thread Victor Wagner
В Fri, 1 May 2020 17:52:15 +0900 Michael Paquier пишет: > On Thu, Apr 30, 2020 at 03:06:08PM +0300, Victor Wagner wrote: > > Fix is very simple, see attach. > > > > Patch is made against REL_12_STABLE, but probably applicable to > > other versions as

Postgres Windows build system doesn't work with python installed in Program Files

2020-04-30 Thread Victor Wagner
Collegues, Accidently I've come over minor bug in the Mkvcbuild.pm. It happens, that it doesn't tolerate spaces in the $config->{python} path, because it want to call python in order to find out version, prefix and so on, and doesn't properly quote command. Fix is very simple, see attach. Patch

Re: make check crashes on POWER8 machine

2020-03-14 Thread Victor Wagner
В Fri, 13 Mar 2020 10:56:15 -0400 Tom Lane пишет: > Victor Wagner writes: > > Justin Pryzby wrote: > >> On Fri, Mar 13, 2020 at 10:29:13AM +0300, Victor Wagner wrote: > >>> I've encountered a problem with Postgres on PowerPC machine.

Re: make check crashes on POWER8 machine

2020-03-13 Thread Victor Wagner
On Fri, 13 Mar 2020 07:43:59 -0500 Justin Pryzby wrote: > On Fri, Mar 13, 2020 at 10:29:13AM +0300, Victor Wagner wrote: > > Hi, > > > > I've encountered a problem with Postgres on PowerPC machine. > > Sometimes > > Is it related to > https://www.p

pg_basebackup from REL_12_STABLE hands on solaris/sparch

2019-10-01 Thread Victor Wagner
Collegues, I've encountered following problem on some old Sparc64 machine running solaris 10: When I compile postgresql 12 with --enable-tap-tests and run make check in src/bin, test src/bin/pg_basebackup/t/010_pg_basebackup.pl hangs and hangs infinitely. I've tried to attach gdb to the hanging

Re: PostgreSQL12 and older versions of OpenSSL

2019-09-24 Thread Victor Wagner
On Tue, 24 Sep 2019 18:49:17 +0900 Michael Paquier wrote: > On Tue, Sep 24, 2019 at 10:18:59AM +0300, Victor Wagner wrote: > > PostgreSQL 12 documentation states, that minimum required version of > > OpenSSL is 0.9.8. However, I was unable to сompile current > > PGPRO_1

PostgreSQL12 and older versions of OpenSSL

2019-09-24 Thread Victor Wagner
Dear hackers, PostgreSQL 12 documentation states, that minimum required version of OpenSSL is 0.9.8. However, I was unable to сompile current PGPRO_12_STABLE with OpenSSL 0.9.8j (from SLES 11sp4). -fno-strict-aliasing -fwrapv -g -O2 -I../../../src/include -D_GNU_SOURCE -I/usr/include/libxml2

Re: Perl 5.26 and windows build system

2018-10-17 Thread Victor Wagner
On Wed, 17 Oct 2018 18:45:42 +0530 Sandeep Thakkar wrote: > > Simple adding > > > > use lib "."; > > > > to the beginning of these script solves problem. > > > > > > We observed the same issue with Strawberry Perl 5.26. We use 5.24 > > to > execute the build.pl. Of course. This is (mis)featu

Perl 5.26 and windows build system

2018-10-17 Thread Victor Wagner
Colleagues, Since Active State stopped to distribute perl 5.22, we decided to upgrade installer builds to most use recent version available (5.26.1.2601 now). But upstream perl changes policy around this version and no longer adds current directory to the module search path. This doesn't break w

Building 64-bit postgres with GSS support on windows

2018-10-17 Thread Victor Wagner
Colleagues, I've encountered some problems trying to enable gss support in MSVC build of Postgres (I've experemented with REL_10_STABLE branch, but code in question seems to be same in all supported releases, including master). As it is recommended in the documentation, I've downloaded MIT Kerber

Re: Bug fix for glibc broke freebsd build in REL_11_STABLE

2018-09-04 Thread Victor Wagner
On Tue, 4 Sep 2018 17:51:30 -0700 Andres Freund wrote: > #endif > in an autoconf test, and have configure complain if that > fails. Something roughly along the lines of > "Compiling PostgreSQL with clang, on 32bit x86, requires SSE2 > support. Use -msse2 or use gcc." Adding CFLAGS=-msse2 to con

Re: Bug fix for glibc broke freebsd build in REL_11_STABLE

2018-09-04 Thread Victor Wagner
what I should have searched on. > > Anyway, my estimation is that this is a compiler bug that's been > repaired, and it probably isn't widespread enough to justify our > inserting some klugy workaround. It doesn't look so, as bug persists after I've upgraded system to current 11.2-RELEASE with clang 6.0.0. -- Victor Wagner

Re: Bug fix for glibc broke freebsd build in REL_11_STABLE

2018-09-04 Thread Victor Wagner
o current 11.2 with clang 6.0.0. It haven't eliminated problem. I can publish my KVM images both of old system (11.0 witth clang 3.8.0) and new one (current 11.2 with clang 6.0.0) > > The OP reported clang 3.8.0, so a minor version behind what I tested. > > I did learn that "make check" fails in rolenames if your Unix user is > called "user". > -- Victor Wagner

Bug fix for glibc broke freebsd build in REL_11_STABLE

2018-09-04 Thread Victor Wagner
Collegues, Few days ago commit 1f349aa7d9a6633e87db071390c73a39ac279ba4 Fix 8a934d67 for libc++ and make more include order resistant. was introduced into branch REL_11_STABLE. It seems that it deals with GLIBC-based systems (i.e Linux and Hurd) only, and shouldn't affect systems with non-

Re: Non-portable shell code in pg_upgrade tap tests

2018-07-20 Thread Victor Wagner
On Fri, 20 Jul 2018 10:25:47 -0400 Tom Lane wrote: > Victor Wagner writes: > > I've discovered that in the branch REL_11_STABLE there is shell > > script src/bin/pg_upgrade/test.sh which doesn't work under Solaris > > 10. (it uses $(command) syntax with

Non-portable shell code in pg_upgrade tap tests

2018-07-20 Thread Victor Wagner
Collegues, I've discovered that in the branch REL_11_STABLE there is shell script src/bin/pg_upgrade/test.sh which doesn't work under Solaris 10. (it uses $(command) syntax with is not compatible with original Solaris /bin/sh) I was quite surprised that this problem goes unnoticed on big buildfar

Re: MSVC builld of 9.5.12 is broken?

2018-02-27 Thread Victor Wagner
platforms. Or there exist somewhere fake Win32 module which would satisfy dependencies and do nothing? -- Victor Wagner

Re: MSVC builld of 9.5.12 is broken?

2018-02-27 Thread Victor Wagner
On Tue, 27 Feb 2018 14:14:04 +0100 Magnus Hagander wrote: > > Thanks. I've pushed this for 9.3-9.5. > > Please verify that it looks good if you can (it takes a while for the > buildfarm to get around to it) Works at least for 9.5, although I haven't run tap tests on this build. ---

Re: MSVC builld of 9.5.12 is broken?

2018-02-27 Thread Victor Wagner
On Tue, 27 Feb 2018 13:49:29 +0100 Magnus Hagander wrote: > Does not apply cleanly to 9.5 at least for me. Probably easy to fix, > but I still feel we shouldn't mess around with the buildsystem in > back branches unless we actually have to. How interesting - somewhere between 9.3 (for which

Re: MSVC builld of 9.5.12 is broken?

2018-02-27 Thread Victor Wagner
On Tue, 27 Feb 2018 13:35:33 +0100 Magnus Hagander wrote: > > Note that said commit (91f3ffc5249) is not limited to rearranging > > makefile. It also changes a lot into C code itself. So it is not a > > question of reverting commit - it is making new commit, which > > reverts changes in just one

Re: MSVC builld of 9.5.12 is broken?

2018-02-27 Thread Victor Wagner
On Tue, 27 Feb 2018 11:43:34 +0100 Magnus Hagander wrote: > I'm unsure why this was introduced in 9.5 and earlier, but not in the > newer ones. This smells like a possible backpatch mistake, in which > case that part should probably be backed out of the old branches > rather than teaching mkvcb

Re: MSVC builld of 9.5.12 is broken?

2018-02-27 Thread Victor Wagner
On Tue, 27 Feb 2018 11:43:34 +0100 Magnus Hagander wrote: > On Tue, Feb 27, 2018 at 11:27 AM, Victor Wagner > wrote: > > > Hello, hackers. > > > > I've tried to build last state of REL9_5_STABLE branch (commit > > 1f19e46124eee8c6a54834) and under W

MSVC builld of 9.5.12 is broken?

2018-02-27 Thread Victor Wagner
Hello, hackers. I've tried to build last state of REL9_5_STABLE branch (commit 1f19e46124eee8c6a54834) and under Win32 encountered following errors: C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\bin\amd64\link.exe /ERRORREPORT:QUEUE /OUT:".\Release\createdb\createdb.exe" /INCREMENT

Re: master make check fails on Solaris 10

2018-01-18 Thread Victor Wagner
On Thu, 18 Jan 2018 09:56:48 -0500 Tom Lane wrote: > Marina Polyakova writes: > > Applying your patch on commit > > f033462d8f77c40b7d6b33c5116e50118fb4699d and using the > > configuration command from [1], I got: checking for __int128... yes > > checking for __int128 alignment bug... broken > >

Re: master make check fails on Solaris 10

2018-01-18 Thread Victor Wagner
On Thu, 18 Jan 2018 01:47:46 -0500 Tom Lane wrote: > Victor Wagner writes: > > Tom Lane wrote: > > checking for __int128 alignment bug... ok > > As far as I understand your patch, there should be: > > checking for __int128 alignment bug... broken > > Yes,

Re: master make check fails on Solaris 10

2018-01-17 Thread Victor Wagner
On Wed, 17 Jan 2018 11:33:09 -0500 Tom Lane wrote: > Attached is a draft patch to incorporate Victor's slimmed-down test > into configure. If you have a chance, could you confirm it does > the right thing on your Sparc machine? It seems that what it does is not exactly a right thing. I've appli

Re: master make check fails on Solaris 10

2018-01-17 Thread Victor Wagner
g comminity buildfarm. So, I'll register it in the big buildfarm as soon as I figure out how to distribute limited resources of this machine between two buildfarms. -- Victor Wagner

Re: master make check fails on Solaris 10

2018-01-17 Thread Victor Wagner
On Wed, 17 Jan 2018 10:07:37 -0500 Tom Lane wrote: > Marina Polyakova writes: > Yeah, I can work with this. What I propose to do is use a somewhat > stripped-down version of this test as an AC_RUN_IFELSE test normally, > but if cross-compiling, fall back to just seeing if we can link. I'd sug

Re: master make check fails on Solaris 10

2018-01-17 Thread Victor Wagner
On Wed, 17 Jan 2018 18:02:26 +0300 Marina Polyakova wrote: > > Attached is a possible test program. I can confirm it passes on a > > machine with working __int128, but I have no idea whether it will > > detect the problem on yours. If not, maybe you can tweak it? > > Thank you! Using gcc 5.5.