public inbox for [email protected]
help / color / mirror / Atom feedpg_partman93
5+ messages / 3 participants
[nested] [flat]
* pg_partman93
@ 2015-10-15 21:35 Martín Marqués <[email protected]>
2015-10-16 11:58 ` Re: pg_partman93 Glauco Torres <[email protected]>
0 siblings, 1 reply; 5+ messages in thread
From: Martín Marqués @ 2015-10-15 21:35 UTC (permalink / raw)
To: pgsql-pkg-yum
Hi,
I was testing out a few things with partitioning and down the road I
installed pg_partman using the pgdg rpms.
Tests are on a 9.3 system so I installed the pg_partman93 package.
To my surprise, yum installed version 2.0.1 of pg_partman which is
compatible with PostgreSQL 9.4+, not with 9.3.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_partman93
2015-10-15 21:35 pg_partman93 Martín Marqués <[email protected]>
@ 2015-10-16 11:58 ` Glauco Torres <[email protected]>
2015-10-16 12:34 ` Re: pg_partman93 Martín Marqués <[email protected]>
0 siblings, 1 reply; 5+ messages in thread
From: Glauco Torres @ 2015-10-16 11:58 UTC (permalink / raw)
To: Martín Marqués <[email protected]>; +Cc: pgsql-pkg-yum
--94eb2c087ea8f0f5700522378197
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
2015-10-15 18:35 GMT-03:00 Mart=C3=ADn Marqu=C3=A9s <[email protected]=
>:
> Hi,
>
> I was testing out a few things with partitioning and down the road I
> installed pg_partman using the pgdg rpms.
>
> Tests are on a 9.3 system so I installed the pg_partman93 package.
>
> To my surprise, yum installed version 2.0.1 of pg_partman which is
> compatible with PostgreSQL 9.4+, not with 9.3.
>
> From the README I can see that Keith suggests using 1.8.7 tag for older
> versions of pg_partman.
>
> Any thoughts on this?
>
>
Hello,
I tested now on CentOS 6.7 and installed correctly, the version that was
available for yum is 1.8.2
yum install
http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noar=
ch.rpm
yum install pg_partman93.x86_64
yum info pg_partman93
Pacotes instalados
Name : pg_partman93
Arch : x86_64
Version : 1.8.2
Release : 1.rhel6
Size : 1.4 M
Repo : installed
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_partman93
2015-10-15 21:35 pg_partman93 Martín Marqués <[email protected]>
2015-10-16 11:58 ` Re: pg_partman93 Glauco Torres <[email protected]>
@ 2015-10-16 12:34 ` Martín Marqués <[email protected]>
2015-10-16 12:42 ` Re: pg_partman93 Glauco Torres <[email protected]>
2015-10-21 10:08 ` Re: pg_partman93 Devrim GÜNDÜZ <[email protected]>
0 siblings, 2 replies; 5+ messages in thread
From: Martín Marqués @ 2015-10-16 12:34 UTC (permalink / raw)
To: Glauco Torres <[email protected]>; +Cc: pgsql-pkg-yum
Damn, I feel really stupid. :(
I was working on a server with 9.3 but reading extension SQL files and
the python scripts from my laptop with the 9.4 package. :(
Going through the yum logs on the server I see that 1.8.2 was
installed, while on my laptop I have 2.0.0. :(
I think what really got me thinking it was 2.0 was when I checked the
spec file in the pgrpms git repository:
[martin@coruscant F-21]$ pwd
/home/martin/git/pgrpms/rpm/redhat/9.3/pg_partman/F-21
[martin@coruscant F-21]$ grep -i version pg_partman.spec
%global pgmajorversion 93
Name: %{sname}%{pgmajorversion}
Version: 2.1.0
Source0:
http://api.pgxn.org/dist/%{sname}/%{version}/%{sname}-%{version}.zip
BuildRequires: postgresql%{pgmajorversion}-devel
Requires: postgresql%{pgmajorversion}-server, python-psycopg2
BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-root-%(%{__id_u} -n)
%setup -q -n %{sname}-%{version}
So, that would build pg_partman93 2.1.0 for F21.
Anyway, sorry about the confusion related to the current package
version available with yum.
Regards,
2015-10-16 8:58 GMT-03:00 Glauco Torres <[email protected]>:
>
>
> 2015-10-15 18:35 GMT-03:00 Martín Marqués <[email protected]>:
>>
>> Hi,
>>
>> I was testing out a few things with partitioning and down the road I
>> installed pg_partman using the pgdg rpms.
>>
>> Tests are on a 9.3 system so I installed the pg_partman93 package.
>>
>> To my surprise, yum installed version 2.0.1 of pg_partman which is
>> compatible with PostgreSQL 9.4+, not with 9.3.
>>
>> From the README I can see that Keith suggests using 1.8.7 tag for older
>> versions of pg_partman.
>>
>> Any thoughts on this?
>>
>
>
> Hello,
>
> I tested now on CentOS 6.7 and installed correctly, the version that was
> available for yum is 1.8.2
>
> yum install
> http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm
>
> yum install pg_partman93.x86_64
>
> yum info pg_partman93
> Pacotes instalados
> Name : pg_partman93
> Arch : x86_64
> Version : 1.8.2
> Release : 1.rhel6
> Size : 1.4 M
> Repo : installed
> From repo : pgdg93
> Summary : A PostgreSQL extension to manage partitioned tables by time or
> ID
> URL : http://pgxn.org/dist/pg_partman/
> License : BSD
> Descrição : pg_partman is a PostgreSQL extension to manage partitioned
> tables by time or ID.
>
> ./usr/pgsql-9.3/share/extension/pg_partman--1.8.2.sql
>
> which repo you are using?
>
> Regards,
> Glauco Torres
>
>
>
>
>
>
--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-pkg-yum mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-pkg-yum
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_partman93
2015-10-15 21:35 pg_partman93 Martín Marqués <[email protected]>
2015-10-16 11:58 ` Re: pg_partman93 Glauco Torres <[email protected]>
2015-10-16 12:34 ` Re: pg_partman93 Martín Marqués <[email protected]>
@ 2015-10-16 12:42 ` Glauco Torres <[email protected]>
1 sibling, 0 replies; 5+ messages in thread
From: Glauco Torres @ 2015-10-16 12:42 UTC (permalink / raw)
To: Martín Marqués <[email protected]>; +Cc: pgsql-pkg-yum
Damn, I feel really stupid. :(
>
> I was working on a server with 9.3 but reading extension SQL files and
> the python scripts from my laptop with the 9.4 package. :(
>
> Going through the yum logs on the server I see that 1.8.2 was
> installed, while on my laptop I have 2.0.0. :(
>
> I think what really got me thinking it was 2.0 was when I checked the
> spec file in the pgrpms git repository:
>
> [martin@coruscant F-21]$ pwd
> /home/martin/git/pgrpms/rpm/redhat/9.3/pg_partman/F-21
> [martin@coruscant F-21]$ grep -i version pg_partman.spec
> %global pgmajorversion 93
> Name: %{sname}%{pgmajorversion}
> Version: 2.1.0
> Source0:
> http://api.pgxn.org/dist/%{sname}/%{version}/%{sname}-%{version}.zip
> BuildRequires: postgresql%{pgmajorversion}-devel
> Requires: postgresql%{pgmajorversion}-server, python-psycopg2
> BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-root-%(%{__id_u}
> -n)
> %setup -q -n %{sname}-%{version}
>
> So, that would build pg_partman93 2.1.0 for F21.
>
> Anyway, sorry about the confusion related to the current package
> version available with yum.
>
>
It happens.
Regards,
Glauco Torres
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_partman93
2015-10-15 21:35 pg_partman93 Martín Marqués <[email protected]>
2015-10-16 11:58 ` Re: pg_partman93 Glauco Torres <[email protected]>
2015-10-16 12:34 ` Re: pg_partman93 Martín Marqués <[email protected]>
@ 2015-10-21 10:08 ` Devrim GÜNDÜZ <[email protected]>
1 sibling, 0 replies; 5+ messages in thread
From: Devrim GÜNDÜZ @ 2015-10-21 10:08 UTC (permalink / raw)
To: Martín Marqués <[email protected]>; Glauco Torres <[email protected]>; +Cc: pgsql-pkg-yum
Hi,
On Fri, 2015-10-16 at 09:34 -0300, Martín Marqués wrote:
> I think what really got me thinking it was 2.0 was when I checked the
> spec file in the pgrpms git repository:
>
> [martin@coruscant F-21]$ pwd
> /home/martin/git/pgrpms/rpm/redhat/9.3/pg_partman/F-21
> [martin@coruscant F-21]$ grep -i version pg_partman.spec
> %global pgmajorversion 93
> Name: %{sname}%{pgmajorversion}
> Version: 2.1.0
*sigh*, my mistake. Will fix in a few days.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachments:
[application/pgp-signature] signature.asc (819B, 2-signature.asc)
download
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2015-10-21 10:08 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-10-15 21:35 pg_partman93 Martín Marqués <[email protected]>
2015-10-16 11:58 ` Glauco Torres <[email protected]>
2015-10-16 12:34 ` Martín Marqués <[email protected]>
2015-10-16 12:42 ` Glauco Torres <[email protected]>
2015-10-21 10:08 ` Devrim GÜNDÜZ <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox