pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL-9.0.1
9+ messages / 4 participants
[nested] [flat]
* PostgreSQL-9.0.1
@ 2011-08-18 11:36 Venkat Balaji <venkat.balaji@verse.in>
0 siblings, 2 replies; 9+ messages in thread
From: Venkat Balaji @ 2011-08-18 11:36 UTC (permalink / raw)
To: pgsql-admin
Hello Community,
I am getting the following error when trying to install PG-9.0.1 -
pg_backup_archiver.o: In function `SetOutput':
pg_backup_archiver.c:(.text+0x2b6f): undefined reference to `gzopen64'
pg_backup_files.o: In function `_StartBlob':
pg_backup_files.c:(.text+0x50d): undefined reference to `gzopen64'
pg_backup_files.o: In function `_StartData':
pg_backup_files.c:(.text+0x5e0): undefined reference to `gzopen64'
pg_backup_files.o: In function `_PrintFileData':
pg_backup_files.c:(.text+0x9f6): undefined reference to `gzopen64'
collect2: ld returned 1 exit status
make[3]: *** [pg_dump] Error 1
make[3]: Leaving directory `/home/postgres/postgresql-9.0.1/src/bin/pg_dump'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/home/postgres/postgresql-9.0.1/src/bin'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/home/postgres/postgresql-9.0.1/src'
make: *** [all] Error 2
Following is the operating system version -
"[root@localhost postgresql-9.0.1]# uname -a
Linux localhost.localdomain 2.6.18-164.el5PAE #1 SMP Thu Sep 3 04:10:44 EDT
2009 i686 i686 i386 GNU/Linux"
We have successfully installed the same on other RHEL servers.
Note : zlib-1.2.3, flex-2.5.35 are installed.
Thanks
Nag
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: PostgreSQL-9.0.1
@ 2011-08-18 12:17 Raghavendra <raghavendra.rao@enterprisedb.com>
parent: Venkat Balaji <venkat.balaji@verse.in>
1 sibling, 1 reply; 9+ messages in thread
From: Raghavendra @ 2011-08-18 12:17 UTC (permalink / raw)
To: Venkat Balaji <venkat.balaji@verse.in>; +Cc: pgsql-admin
I think you should also need 'zlib-devel', check with the rpm's list of zlib
in your OS.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Thu, Aug 18, 2011 at 5:06 PM, Venkat Balaji <venkat.balaji@verse.in>wrote:
> Hello Community,
>
> I am getting the following error when trying to install PG-9.0.1 -
>
> pg_backup_archiver.o: In function `SetOutput':
> pg_backup_archiver.c:(.text+0x2b6f): undefined reference to `gzopen64'
> pg_backup_files.o: In function `_StartBlob':
> pg_backup_files.c:(.text+0x50d): undefined reference to `gzopen64'
> pg_backup_files.o: In function `_StartData':
> pg_backup_files.c:(.text+0x5e0): undefined reference to `gzopen64'
> pg_backup_files.o: In function `_PrintFileData':
> pg_backup_files.c:(.text+0x9f6): undefined reference to `gzopen64'
> collect2: ld returned 1 exit status
> make[3]: *** [pg_dump] Error 1
> make[3]: Leaving directory
> `/home/postgres/postgresql-9.0.1/src/bin/pg_dump'
> make[2]: *** [all] Error 2
> make[2]: Leaving directory `/home/postgres/postgresql-9.0.1/src/bin'
> make[1]: *** [all] Error 2
> make[1]: Leaving directory `/home/postgres/postgresql-9.0.1/src'
> make: *** [all] Error 2
>
> Following is the operating system version -
>
> "[root@localhost postgresql-9.0.1]# uname -a
> Linux localhost.localdomain 2.6.18-164.el5PAE #1 SMP Thu Sep 3 04:10:44 EDT
> 2009 i686 i686 i386 GNU/Linux"
>
> We have successfully installed the same on other RHEL servers.
>
> Note : zlib-1.2.3, flex-2.5.35 are installed.
>
> Thanks
> Nag
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: PostgreSQL-9.0.1
@ 2011-08-18 12:41 Devrim GÜNDÜZ <devrim@gunduz.org>
parent: Venkat Balaji <venkat.balaji@verse.in>
1 sibling, 1 reply; 9+ messages in thread
From: Devrim GÜNDÜZ @ 2011-08-18 12:41 UTC (permalink / raw)
To: Venkat Balaji <venkat.balaji@verse.in>; +Cc: pgsql-admin
On Thu, 2011-08-18 at 17:06 +0530, Venkat Balaji wrote:
>
> I am getting the following error when trying to install PG-9.0.1 -
<snip>
Why don't you use RPMs for that?
http://yum.pgrpms.org
(and please use 9.0.4)
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: PostgreSQL-9.0.1
@ 2011-08-19 06:46 Venkat Balaji <venkat.balaji@verse.in>
parent: Devrim GÜNDÜZ <devrim@gunduz.org>
0 siblings, 1 reply; 9+ messages in thread
From: Venkat Balaji @ 2011-08-19 06:46 UTC (permalink / raw)
To: Devrim GÜNDÜZ <devrim@gunduz.org>; +Cc: pgsql-admin
Hi Devrim,
Great to get a reply from your end !
We would definitely use rpm based installers.
We have been using community version tars (source installers) for all our
production setups.
Could you let us know what things are to be looked at if we switch over to
rpm based installers ?
(things like prerequisites, compatibility issues etc). We use CentOS and
RHEL for PostgreSQL.
We would start preparing our implementation plan for production.
Thanks
Venkat
2011/8/18 Devrim GÜNDÜZ <devrim@gunduz.org>
> On Thu, 2011-08-18 at 17:06 +0530, Venkat Balaji wrote:
> >
> > I am getting the following error when trying to install PG-9.0.1 -
>
> <snip>
>
> Why don't you use RPMs for that?
>
> http://yum.pgrpms.org
>
> (and please use 9.0.4)
>
> Regards,
> --
> Devrim GÜNDÜZ
> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danýþmaný/Consultant, Red Hat Certified Engineer
> Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: PostgreSQL-9.0.1
@ 2011-08-19 06:48 Venkat Balaji <venkat.balaji@verse.in>
parent: Raghavendra <raghavendra.rao@enterprisedb.com>
0 siblings, 1 reply; 9+ messages in thread
From: Venkat Balaji @ 2011-08-19 06:48 UTC (permalink / raw)
To: Raghavendra <raghavendra.rao@enterprisedb.com>; +Cc: pgsql-admin
Hi Raghav,
I have zlib, zlib-devel installed in my system.
There seems to be some problem with ".o" files.
I tried to install after "make clean" and "make distclean" as well.
I believe, there must be some options to be used with make.
Thanks
Venkat N
On Thu, Aug 18, 2011 at 5:47 PM, Raghavendra <
raghavendra.rao@enterprisedb.com> wrote:
> I think you should also need 'zlib-devel', check with the rpm's list of
> zlib in your OS.
>
> ---
> Regards,
> Raghavendra
> EnterpriseDB Corporation
> Blog: http://raghavt.blogspot.com/
>
>
>
> On Thu, Aug 18, 2011 at 5:06 PM, Venkat Balaji <venkat.balaji@verse.in>wrote:
>
>> Hello Community,
>>
>> I am getting the following error when trying to install PG-9.0.1 -
>>
>> pg_backup_archiver.o: In function `SetOutput':
>> pg_backup_archiver.c:(.text+0x2b6f): undefined reference to `gzopen64'
>> pg_backup_files.o: In function `_StartBlob':
>> pg_backup_files.c:(.text+0x50d): undefined reference to `gzopen64'
>> pg_backup_files.o: In function `_StartData':
>> pg_backup_files.c:(.text+0x5e0): undefined reference to `gzopen64'
>> pg_backup_files.o: In function `_PrintFileData':
>> pg_backup_files.c:(.text+0x9f6): undefined reference to `gzopen64'
>> collect2: ld returned 1 exit status
>> make[3]: *** [pg_dump] Error 1
>> make[3]: Leaving directory
>> `/home/postgres/postgresql-9.0.1/src/bin/pg_dump'
>> make[2]: *** [all] Error 2
>> make[2]: Leaving directory `/home/postgres/postgresql-9.0.1/src/bin'
>> make[1]: *** [all] Error 2
>> make[1]: Leaving directory `/home/postgres/postgresql-9.0.1/src'
>> make: *** [all] Error 2
>>
>> Following is the operating system version -
>>
>> "[root@localhost postgresql-9.0.1]# uname -a
>> Linux localhost.localdomain 2.6.18-164.el5PAE #1 SMP Thu Sep 3 04:10:44
>> EDT 2009 i686 i686 i386 GNU/Linux"
>>
>> We have successfully installed the same on other RHEL servers.
>>
>> Note : zlib-1.2.3, flex-2.5.35 are installed.
>>
>> Thanks
>> Nag
>>
>>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: PostgreSQL-9.0.1
@ 2011-08-19 08:05 Devrim GÜNDÜZ <devrim@gunduz.org>
parent: Venkat Balaji <venkat.balaji@verse.in>
0 siblings, 0 replies; 9+ messages in thread
From: Devrim GÜNDÜZ @ 2011-08-19 08:05 UTC (permalink / raw)
To: Venkat Balaji <venkat.balaji@verse.in>; +Cc: pgsql-admin
On Fri, 2011-08-19 at 12:16 +0530, Venkat Balaji wrote:
>
> Could you let us know what things are to be looked at if we switch
> over to rpm based installers ?
> (things like prerequisites, compatibility issues etc). We use CentOS
> and RHEL for PostgreSQL.
Umm, nothing. You will no longer need -devel packages on your prod
system. Yum will pick up all prerequisites automagically.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: PostgreSQL-9.0.1
@ 2011-08-19 13:51 Tom Lane <tgl@sss.pgh.pa.us>
parent: Venkat Balaji <venkat.balaji@verse.in>
0 siblings, 1 reply; 9+ messages in thread
From: Tom Lane @ 2011-08-19 13:51 UTC (permalink / raw)
To: Venkat Balaji <venkat.balaji@verse.in>; +Cc: Raghavendra <raghavendra.rao@enterprisedb.com>; pgsql-admin
Venkat Balaji <venkat.balaji@verse.in> writes:
> I believe, there must be some options to be used with make.
No, the make command should just be "make". Any options that are needed
would be supplied at the configure step.
> pg_backup_archiver.o: In function `SetOutput':
> pg_backup_archiver.c:(.text+0x2b6f): undefined reference to `gzopen64'
FWIW, this seems to indicate a mismatch between the zlib.h you're using
and the libz.so you're linking to. The PG sources do not reference
gzopen64, but some versions of zlib.h conditionally #define gzopen as
gzopen64 --- in which case it'd better be used with a library that
actually provides that symbol. Evidently the one that the linker is
finding does not. If I had to bet based on this much information,
I'd bet on a manual zlib installation that doesn't match the system's
libz.so, and for which you forgot to do the ldconfig magic needed to get
the linker to actually pick yours instead of the /usr/lib one.
regards, tom lane
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: PostgreSQL-9.0.1
@ 2011-08-23 05:50 Venkat Balaji <venkat.balaji@verse.in>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 9+ messages in thread
From: Venkat Balaji @ 2011-08-23 05:50 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Raghavendra <raghavendra.rao@enterprisedb.com>; pgsql-admin
Hi Tom,
Thank you very much for your reply !
Before I read this post, I had successfully installed Postgres with
"--without-zlib" option.
Could you please let me know what could be the impact on the database and
application performance ?
I am installing PG on a brand new server (CentOS - 5.4) 32 bit. I would redo
the installation with "ldconfig" option as well (i never did before).
But, we did not face this problem before on any of our servers (both on 64
bit and 32 bit). I mean we never had to manually link our libraries using
"ldconfig".
Thanks
Venkat
On Fri, Aug 19, 2011 at 7:21 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Venkat Balaji <venkat.balaji@verse.in> writes:
> > I believe, there must be some options to be used with make.
>
> No, the make command should just be "make". Any options that are needed
> would be supplied at the configure step.
>
> > pg_backup_archiver.o: In function `SetOutput':
> > pg_backup_archiver.c:(.text+0x2b6f): undefined reference to `gzopen64'
>
> FWIW, this seems to indicate a mismatch between the zlib.h you're using
> and the libz.so you're linking to. The PG sources do not reference
> gzopen64, but some versions of zlib.h conditionally #define gzopen as
> gzopen64 --- in which case it'd better be used with a library that
> actually provides that symbol. Evidently the one that the linker is
> finding does not. If I had to bet based on this much information,
> I'd bet on a manual zlib installation that doesn't match the system's
> libz.so, and for which you forgot to do the ldconfig magic needed to get
> the linker to actually pick yours instead of the /usr/lib one.
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: PostgreSQL-9.0.1
@ 2011-08-23 06:52 Venkat Balaji <venkat.balaji@verse.in>
parent: Venkat Balaji <venkat.balaji@verse.in>
0 siblings, 0 replies; 9+ messages in thread
From: Venkat Balaji @ 2011-08-23 06:52 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Raghavendra <raghavendra.rao@enterprisedb.com>; pgsql-admin
Hi Tom,
The "ldconfig" magic worked !!!!!
I included "/usr/local/lib" in "/etc/ld.so.conf" and fired "ldconfig".
It worked. I installed PostgreSQL with zlib option.
Thanks a ton for your reply !
One request -
We only use community version of PostgreSQL. We need to standardize the
installation procedure for our production boxes.
Could you please let us know what other precautions are to be taken to get
the PostgreSQL setup smooth.
As mentioned in my previous email, we never faced this problem before.
Note : We use RHEL or CentOS (32 and 64 bit).
On Tue, Aug 23, 2011 at 11:20 AM, Venkat Balaji <venkat.balaji@verse.in>wrote:
> Hi Tom,
>
> Thank you very much for your reply !
>
> Before I read this post, I had successfully installed Postgres with
> "--without-zlib" option.
>
> Could you please let me know what could be the impact on the database and
> application performance ?
>
> I am installing PG on a brand new server (CentOS - 5.4) 32 bit. I would
> redo the installation with "ldconfig" option as well (i never did before).
>
> But, we did not face this problem before on any of our servers (both on 64
> bit and 32 bit). I mean we never had to manually link our libraries using
> "ldconfig".
>
>
> Thanks
> Venkat
>
>
> On Fri, Aug 19, 2011 at 7:21 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>> Venkat Balaji <venkat.balaji@verse.in> writes:
>> > I believe, there must be some options to be used with make.
>>
>> No, the make command should just be "make". Any options that are needed
>> would be supplied at the configure step.
>>
>> > pg_backup_archiver.o: In function `SetOutput':
>> > pg_backup_archiver.c:(.text+0x2b6f): undefined reference to `gzopen64'
>>
>> FWIW, this seems to indicate a mismatch between the zlib.h you're using
>> and the libz.so you're linking to. The PG sources do not reference
>> gzopen64, but some versions of zlib.h conditionally #define gzopen as
>> gzopen64 --- in which case it'd better be used with a library that
>> actually provides that symbol. Evidently the one that the linker is
>> finding does not. If I had to bet based on this much information,
>> I'd bet on a manual zlib installation that doesn't match the system's
>> libz.so, and for which you forgot to do the ldconfig magic needed to get
>> the linker to actually pick yours instead of the /usr/lib one.
>>
>> regards, tom lane
>>
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2011-08-23 06:52 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-08-18 11:36 PostgreSQL-9.0.1 Venkat Balaji <venkat.balaji@verse.in>
2011-08-18 12:17 ` Raghavendra <raghavendra.rao@enterprisedb.com>
2011-08-19 06:48 ` Venkat Balaji <venkat.balaji@verse.in>
2011-08-19 13:51 ` Tom Lane <tgl@sss.pgh.pa.us>
2011-08-23 05:50 ` Venkat Balaji <venkat.balaji@verse.in>
2011-08-23 06:52 ` Venkat Balaji <venkat.balaji@verse.in>
2011-08-18 12:41 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2011-08-19 06:46 ` Venkat Balaji <venkat.balaji@verse.in>
2011-08-19 08:05 ` Devrim GÜNDÜZ <devrim@gunduz.org>
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