[ANNOUNCEMENT] Test: postgresql-10.2-1

[ANNOUNCEMENT] Test: postgresql-10.2-1

[Marco Atzeri]

Version 10.2-1  of packages

   libecpg-compat3
   libecpg-devel
   libecpg6
   libpgtypes3
   libpq-devel
   libpq5
   postgresql
   postgresql-client
   postgresql-contrib
   postgresql-devel
   postgresql-doc
   postgresql-plperl
   postgresql-plpython

are available in the Cygwin distribution:

CHANGES
This is the latest upstream version, upstream info on
https://www.postgresql.org/about/news/1829/

  Migration to Version 10.x

For upgrade from previous 10.x see :
http://www.postgresql.org/docs/10/static/release-10.html

A dump/restore is required for those running 9.6.X.
http://www.postgresql.org/docs/9.6/static/release-10.html

ADVISE for major version UPGRADE
http://www.postgresql.org/support/versioning/

Major releases usually change the internal format of system tables
and data files. These changes are often complex, so we do not maintain
backward compatibility of all stored data. A dump/reload of the
database or use of the pg_upgrade module is required for major upgrades.

DESCRIPTION
PostgreSQL is a powerful, open source object-relational database system.
It has a proven architecture that has earned it a strong reputation for
reliability, data integrity, and correctness.
It is fully ACID compliant, has full support for foreign keys, joins, views,
triggers, and stored procedures (in multiple languages).
It includes most SQL:2008 data types
HOMEPAGE
http://www.postgresql.org

Marco Atzeri

If you have questions or comments, please send them to the
cygwin mailing list at: cygwin (at) cygwin (dot) com .

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: [ANNOUNCEMENT] Test: postgresql-10.2-1

[Thorsten Kampe]

* Marco Atzeri (Sat, 10 Feb 2018 14:50:30 +0100)
> Version 10.2-1  of packages
> 
>    libecpg-compat3
>    libecpg-devel
>    libecpg6
>    libpgtypes3
>    libpq-devel
>    libpq5
>    postgresql
>    postgresql-client
>    postgresql-contrib
>    postgresql-devel
>    postgresql-doc
>    postgresql-plperl
>    postgresql-plpython
> 
> are available in the Cygwin distribution:

Getting error "The procedure entry point 
PQencryptPasswordConn could not be located in the 
dynamic link library F:\cygwin\bin\psql.exe" trying to 
start psql. Server runs fine.

Thorsten



--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: [ANNOUNCEMENT] Test: postgresql-10.2-1

[Marco Atzeri]

On 11/02/2018 23:07, Thorsten Kampe wrote:
> * Marco Atzeri (Sat, 10 Feb 2018 14:50:30 +0100)
>> Version 10.2-1  of packages

> 
> Getting error "The procedure entry point
> PQencryptPasswordConn could not be located in the
> dynamic link library F:\cygwin\bin\psql.exe" trying to
> start psql. Server runs fine.
> 
> Thorsten
> 

of course not here.
------------
  $ psql postgres
psql (10.2)
Type "help" for help.

postgres=#
-------------

PQencryptPasswordConn belongs to cygpq-5.dll
in libpq5-10.2-1.

Can you check that is installed and eventually
provide the cygcheck.out

https://cygwin.com/problems.html

Regards
Marco

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: [ANNOUNCEMENT] Test: postgresql-10.2-1

[Thorsten Kampe]

* Marco Atzeri (Mon, 12 Feb 2018 08:39:09 +0100)
> 
> On 11/02/2018 23:07, Thorsten Kampe wrote:
> > * Marco Atzeri (Sat, 10 Feb 2018 14:50:30 +0100)
> >> Version 10.2-1  of packages
> 
> > 
> > Getting error "The procedure entry point
> > PQencryptPasswordConn could not be located in the
> > dynamic link library F:\cygwin\bin\psql.exe" trying to
> > start psql. Server runs fine.
> 
> of course not here.
> ------------
>   $ psql postgres
> psql (10.2)
> Type "help" for help.
> 
> postgres=#
> -------------
> 
> PQencryptPasswordConn belongs to cygpq-5.dll
> in libpq5-10.2-1.

libpq was still version 9.6. Shouldn't it be selected 
for upgrading automatically as a dependency?

Thorsten


--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: [ANNOUNCEMENT] Test: postgresql-10.2-1

[Marco Atzeri]

On 12/02/2018 12:30, Thorsten Kampe wrote:
> * Marco Atzeri (Mon, 12 Feb 2018 08:39:09 +0100)

>>
>> PQencryptPasswordConn belongs to cygpq-5.dll
>> in libpq5-10.2-1.
> 
> libpq was still version 9.6. Shouldn't it be selected
> for upgrading automatically as a dependency?
> 
> Thorsten
> 

It should be upgraded.
The setup.ini "requires" is correctly reporting it.


@ postgresql-client
sdesc: "front-end programs for PostgreSQL"
ldesc: "object-relational SQL database management system"
category: Database
requires: crypt cygwin libintl8 libpq5 libreadline7 openssl zlib0

Regards
Marco

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: [ANNOUNCEMENT] Test: postgresql-10.2-1

[Brian Inglis]

On 2018-02-12 04:53, Marco Atzeri wrote:
> On 12/02/2018 12:30, Thorsten Kampe wrote:
>> * Marco Atzeri (Mon, 12 Feb 2018 08:39:09 +0100)
>>> PQencryptPasswordConn belongs to cygpq-5.dll
>>> in libpq5-10.2-1.
>> libpq was still version 9.6. Shouldn't it be selected
>> for upgrading automatically as a dependency?
> It should be upgraded.
> The setup.ini "requires" is correctly reporting it.
> @ postgresql-client
> sdesc: "front-end programs for PostgreSQL"
> ldesc: "object-relational SQL database management system"
> category: Database
> requires: crypt cygwin libintl8 libpq5 libreadline7 openssl zlib0

As that version 10.2-1 is also test, doesn't either that version or the Test
control need to be explicitly selected?

-- 
Take care. Thanks, Brian Inglis, Calgary, Alberta, Canada

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: [ANNOUNCEMENT] Test: postgresql-10.2-1

[Marco Atzeri]

On 12/02/2018 16:17, Brian Inglis wrote:
> On 2018-02-12 04:53, Marco Atzeri wrote:
>> On 12/02/2018 12:30, Thorsten Kampe wrote:
>>> * Marco Atzeri (Mon, 12 Feb 2018 08:39:09 +0100)
>>>> PQencryptPasswordConn belongs to cygpq-5.dll
>>>> in libpq5-10.2-1.
>>> libpq was still version 9.6. Shouldn't it be selected
>>> for upgrading automatically as a dependency?
>> It should be upgraded.
>> The setup.ini "requires" is correctly reporting it.
>> @ postgresql-client
>> sdesc: "front-end programs for PostgreSQL"
>> ldesc: "object-relational SQL database management system"
>> category: Database
>> requires: crypt cygwin libintl8 libpq5 libreadline7 openssl zlib0
> 
> As that version 10.2-1 is also test, doesn't either that version or the Test
> control need to be explicitly selected?

If test checkbox is selected,  all installed packages should be
proposed for upgrade (9.6.7-1 -> 10.2-1)

I just verified and it works as expected on both the current 2.884
and the test version 2.887 of setup.

However if you select manually the 10.2-1 of postgresql-client,
without checking the test checkbox, the 10.2-1 of libpq5 will
not be proposed for update; this happens on both versions of setup.



Regards
Marco








--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

Re: [ANNOUNCEMENT] Test: postgresql-10.2-1

[Marco Atzeri]

On 10/02/2018 14:50, Marco Atzeri wrote:
> Version 10.2-1  of packages
> 
>    libecpg-compat3
>    libecpg-devel
>    libecpg6
>    libpgtypes3
>    libpq-devel
>    libpq5
>    postgresql
>    postgresql-client
>    postgresql-contrib
>    postgresql-devel
>    postgresql-doc
>    postgresql-plperl
>    postgresql-plpython
> 
> are available in the Cygwin distribution:


I am planning to move next 10.3-1 release to current
by end of the week leaving 9.6.7 as prev

Please consider dump/restore before upgrade from 9.6.x
http://www.postgresql.org/docs/10/static/release-10.html

Regards
Marco

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple