pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

pguint Installation error in PostgreSQL server version 11.2
3+ messages / 2 participants
[nested] [flat]

* pguint Installation error in PostgreSQL server version 11.2
@ 2019-07-19 06:01  Suresh Seema <suresh.seema@opsveda.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Suresh Seema @ 2019-07-19 06:01 UTC (permalink / raw)
  To: pgsql-admin

  Hi Everyone,

I have installed PostgresSQL 11.2 version on Centos 7 and try to install
*pguint* from source to install *TINYINT* datatype .
But installation   had problem not able to resolve dependency packages. I
have followed below method to install , please help me to resolve this
issue.

1. yum install centos-release-scl-rh
2.yum install llvm-toolset-7-clang-tools-extra
3.yum install devtoolset-7
4.yum install llvm-toolset-5
5.make PG_CONFIG=/usr/pgsql-11/bin/pg_config
6.make PG_CONFIG=/usr/pgsql-11/bin/pg_config install
Installed llvm5.0 packages successfully but when try to create pg extension
getting below error ,




*[postgres] # CREATE EXTENSION  uint;ERROR:  XX000: could not load library
"/usr/pgsql-11/lib/uint.so": /usr/pgsql-11/lib/uint.so: undefined symbol:
GET_1_BYTELOCATION:  internal_load_library, dfmgr.c:240Time: 17.247 ms*

Please help me to resolve this issue.

Regards,
Suresh Seema

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: pguint Installation error in PostgreSQL server version 11.2
@ 2019-07-21 18:23  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Suresh Seema <suresh.seema@opsveda.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2019-07-21 18:23 UTC (permalink / raw)
  To: Suresh Seema <suresh.seema@opsveda.com>; +Cc: pgsql-admin

Suresh Seema <suresh.seema@opsveda.com> writes:
> I have installed PostgresSQL 11.2 version on Centos 7 and try to install
> *pguint* from source to install *TINYINT* datatype .
> ...
> *[postgres] # CREATE EXTENSION  uint;ERROR:  XX000: could not load library
> "/usr/pgsql-11/lib/uint.so": /usr/pgsql-11/lib/uint.so: undefined symbol:
> GET_1_BYTE

This is not a dependency problem.  GET_1_BYTE() was a macro defined in
PG10 and before, but it doesn't exist anymore as of PG11.  There are
two fairly plausible reasons why you might get this failure:

1. You built pguint against pre-v11 Postgres header files.

2. pguint actually contains a direct reference to GET_1_BYTE(), in
which case it's going to need some source-code fixes.

I don't know which applies.  But check your build process first.

			regards, tom lane





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: pguint Installation error in PostgreSQL server version 11.2
@ 2019-07-24 07:09  Suresh Seema <suresh.seema@opsveda.com>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Suresh Seema @ 2019-07-24 07:09 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

Hi Tom,

Thanks for your support, but i have installed PostgreSQL packages from RPM
repo not from Source code.

Please find RPM repo below.




*[pgdg11-source]name=PostgreSQL 11 $releasever - $basearch -
Sourcefailovermethod=prioritybaseurl=https://download.postgresql.org/pub/repos/yum/srpms/11/redhat/rhel-$releasever-$basearch
<https://download.postgresql.org/pub/repos/yum/srpms/11/redhat/rhel-$releasever-$basearch>*

Please suggest me on this.

Regards,
Suresh Seema

On Sun, Jul 21, 2019 at 11:53 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Suresh Seema <suresh.seema@opsveda.com> writes:
> > I have installed PostgresSQL 11.2 version on Centos 7 and try to install
> > *pguint* from source to install *TINYINT* datatype .
> > ...
> > *[postgres] # CREATE EXTENSION  uint;ERROR:  XX000: could not load
> library
> > "/usr/pgsql-11/lib/uint.so": /usr/pgsql-11/lib/uint.so: undefined symbol:
> > GET_1_BYTE
>
> This is not a dependency problem.  GET_1_BYTE() was a macro defined in
> PG10 and before, but it doesn't exist anymore as of PG11.  There are
> two fairly plausible reasons why you might get this failure:
>
> 1. You built pguint against pre-v11 Postgres header files.
>
> 2. pguint actually contains a direct reference to GET_1_BYTE(), in
> which case it's going to need some source-code fixes.
>
> I don't know which applies.  But check your build process first.
>
>                         regards, tom lane
>


-- 
Regards,
Suresh Seema

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2019-07-24 07:09 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-07-19 06:01 pguint Installation error in PostgreSQL server version 11.2 Suresh Seema <suresh.seema@opsveda.com>
2019-07-21 18:23 ` Tom Lane <tgl@sss.pgh.pa.us>
2019-07-24 07:09   ` Suresh Seema <suresh.seema@opsveda.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox