Обсуждение: BUG #14292: Error in installing the postgresql 9.3
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDI5MgpMb2dnZWQgYnk6ICAg ICAgICAgIG5hZ2VuZHJhIGthc2h5YXAKRW1haWwgYWRkcmVzczogICAgICBr YXNoeWFwLm5hZ2VuZHJhQHhlcm94LmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDkuMy4xNApPcGVyYXRpbmcgc3lzdGVtOiAgIFJIRUw3CkRlc2NyaXB0aW9u OiAgICAgICAgCgpXaGlsZSBjb25maWd1cmluZyBwb3N0Z3Jlc3FsIDkuMyB3 ZSByZWNlaXZlZCBiZWxvdyBlcnJvcnMuDQoqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqDQpjb25maWd1cmU6IGVycm9yOiByZWFkbGluZSBs aWJyYXJ5IG5vdCANCmZvdW5kDQpJZiB5b3UgaGF2ZSByZWFkbGluZSBhbHJl YWR5IGluc3RhbGxlZCwgc2VlIGNvbmZpZy5sb2cgZm9yIGRldGFpbHMgb24g dGhlCmZhaWx1cmUuICBJdCBpcyBwb3NzaWJsZSB0aGUgY29tcGlsZXIgaXNu J3QgbG9va2luZyBpbiB0aGUgcHJvcGVyCmRpcmVjdG9yeS4NClVzZSAtLXdp dGhvdXQtcmVhZGxpbmUgdG8gZGlzYWJsZSByZWFkbGluZSBzdXBwb3J0DQoq KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKg0KY29uZmlndXJl OiBlcnJvcjogemxpYiBsaWJyYXJ5IG5vdCBmb3VuZA0KSWYgeW91IGhhdmUg emxpYiBhbHJlYWR5IGluc3RhbGxlZCwgc2VlIGNvbmZpZy5sb2cgZm9yIGRl dGFpbHMgb24gdGhlDQpmYWlsdXJlLiAgSXQgaXMgcG9zc2libGUgdGhlIGNv bXBpbGVyIGlzbid0IGxvb2tpbmcgaW4gdGhlIHByb3BlcgpkaXJlY3Rvcnku DQpVc2UgLS13aXRob3V0LXpsaWIgdG8gZGlzYWJsZSB6bGliIHN1cHBvcnQu DQoqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKg0KU28gd2Ug aGFkIHRvIHVzZSBiZWxvdyBjb25maWd1cmF0aW9uIGNvbW1hbmQuDQoqKioq KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqDQouL2NvbmZpZ3Vy ZSAtLW1hbmRpcj0vdTAxL0RhdGFiYXNlL1Bvc3RncmVTUUwvOS4zL21hbgot LXByZWZpeD0vdTAxL0RhdGFiYXNlL1Bvc3RncmVTUUwvOS4zIC0td2l0aG91 dC1yZWFkbGluZSAtLXdpdGhvdXQtemxpYg0KKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqKioNCkJ1dCBJIGJlbGlldmUgdGhlcmUgd291 bGQgYmUgc29tZSBpc3N1ZSBpbiB0aGUgZnV0dXJlIGlmIHdlIGRpc2FibGUg emxpYi4gU28KY291bGQgeW91IHBsZWFzZSAgaWYgd2UgY2FuIHJlY29uZmln dXJlIHRoZSBwb3N0Z3Jlc3FsIHdpdGggemxpYiB3aXRoIG91dApkaXN0dXJi aW5nIHRoZSBleGlzdGluZyBzeXN0ZW0gb3Igc2hvdWxkIGJlIHJlaW5zdGFs bCB0aGUgZGF0YWJhc2U/DQoNClBsZWFzZSBsZXQgdXMga25vdy4NCg0KCgo=
On Wed, Aug 24, 2016 at 3:56 AM, <kashyap.nagendra@xerox.com> wrote: > The following bug has been logged on the website: > The following wasn't a bug. =E2=80=8B[...]=E2=80=8B > if we can reconfigure the postgresql with zlib with out > disturbing the existing system or should be reinstall the database? > =E2=80=8BIf installing zlib (or other optional packages) on the system cons= titutes "disturbing the existing system" you are out-of-luck. The lack of these packages shouldn't cause problems - otherwise they wouldn't be optional. Now that you've compiled the application you will need to re-compile and re-install if you wish to take advantage of the additional capabilities. David J.=E2=80=8B
RGF2aWQsDQoNClRoYW5rcyBhIGxvdCBmb3IgdGhlIGluZm9ybWF0aW9uLg0KQ291bGQgeW91IHBs ZWFzZSBsZXQgbWUga25vdyB0aGUgcG9zc2libGUgaXNzdWVzIGR1ZSB0byBub3QgaW5zdGFsbGlu ZyB0aGUgc3BlY2lmaWVkIHBhY2thZ2VzLg0KDQpUaGFua3MgJiBSZWdhcmRzLA0KTmFnZW5kcmEg S2FzaHlhcA0KRnJvbTogRGF2aWQgRy4gSm9obnN0b24gW21haWx0bzpkYXZpZC5nLmpvaG5zdG9u QGdtYWlsLmNvbV0NClNlbnQ6IFdlZG5lc2RheSwgQXVndXN0IDI0LCAyMDE2IDU6MDkgUE0NClRv OiBOYWdlbmRyYSwgS2FzaHlhcA0KQ2M6IHBnc3FsLWJ1Z3NAcG9zdGdyZXNxbC5vcmcNClN1Ympl Y3Q6IFJlOiBbQlVHU10gQlVHICMxNDI5MjogRXJyb3IgaW4gaW5zdGFsbGluZyB0aGUgcG9zdGdy ZXNxbCA5LjMNCg0KT24gV2VkLCBBdWcgMjQsIDIwMTYgYXQgMzo1NiBBTSwgPGthc2h5YXAubmFn ZW5kcmFAeGVyb3guY29tPG1haWx0bzprYXNoeWFwLm5hZ2VuZHJhQHhlcm94LmNvbT4+IHdyb3Rl Og0KVGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOg0KDQpU aGUgZm9sbG93aW5nIHdhc24ndCBhIGJ1Zy4NCg0K4oCLWy4uLl3igIsNCmlmIHdlIGNhbiByZWNv bmZpZ3VyZSB0aGUgcG9zdGdyZXNxbCB3aXRoIHpsaWIgd2l0aCBvdXQNCmRpc3R1cmJpbmcgdGhl IGV4aXN0aW5nIHN5c3RlbSBvciBzaG91bGQgYmUgcmVpbnN0YWxsIHRoZSBkYXRhYmFzZT8NCg0K 4oCLSWYgaW5zdGFsbGluZyB6bGliIChvciBvdGhlciBvcHRpb25hbCBwYWNrYWdlcykgb24gdGhl IHN5c3RlbSBjb25zdGl0dXRlcyAiZGlzdHVyYmluZyB0aGUgZXhpc3Rpbmcgc3lzdGVtIiB5b3Ug YXJlIG91dC1vZi1sdWNrLg0KDQpUaGUgbGFjayBvZiB0aGVzZSBwYWNrYWdlcyBzaG91bGRuJ3Qg Y2F1c2UgcHJvYmxlbXMgLSBvdGhlcndpc2UgdGhleSB3b3VsZG4ndCBiZSBvcHRpb25hbC4NCg0K Tm93IHRoYXQgeW91J3ZlIGNvbXBpbGVkIHRoZSBhcHBsaWNhdGlvbiB5b3Ugd2lsbCBuZWVkIHRv IHJlLWNvbXBpbGUgYW5kIHJlLWluc3RhbGwgaWYgeW91IHdpc2ggdG8gdGFrZSBhZHZhbnRhZ2Ug b2YgdGhlIGFkZGl0aW9uYWwgY2FwYWJpbGl0aWVzLg0KDQpEYXZpZCBKLuKAiw0KDQo=
On Wed, Aug 24, 2016 at 7:41 AM, Nagendra, Kashyap < Kashyap.Nagendra@xerox.com> wrote: > David, > > > > Thanks a lot for the information. > > Could you please let me know the possible issues due to not installing th= e > specified packages. > > > =E2=80=8BI'm reasonably certain both pertain to the psql (and zlib to pg_du= mp and maybe other) client tools provided as part of PostgreSQL. Readline makes using the psql prompt easier while zlib provides transfer compression between the client and server. There may be other aspects too, I'm mostly going off of what the applications do. David J.
On Wed, Aug 24, 2016 at 6:54 AM, David G. Johnston <david.g.johnston@gmail.com> wrote: > On Wed, Aug 24, 2016 at 7:41 AM, Nagendra, Kashyap <Kashyap.Nagendra@xerox.com> wrote: >> Could you please let me know the possible issues due to not installing the >> specified packages. > > I'm reasonably certain both pertain to the psql (and zlib to pg_dump and > maybe other) client tools provided as part of PostgreSQL. Readline makes > using the psql prompt easier while zlib provides transfer compression > between the client and server. > > There may be other aspects too, I'm mostly going off of what the > applications do. I'm pretty sure that pg_dump and pg_restore (and probably other applications) won't be able to deal with compression without zlib. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On 8/24/2016 12:56 AM, kashyap.nagendra@xerox.com wrote: > While configuring postgresql 9.3 we received below errors. > ********************************** > configure: error: readline library not > found > If you have readline already installed, see config.log for details on the > failure. It is possible the compiler isn't looking in the proper > directory. > Use --without-readline to disable readline support > *********************************** > configure: error: zlib library not found > If you have zlib already installed, see config.log for details on the > failure. It is possible the compiler isn't looking in the proper > directory. > Use --without-zlib to disable zlib support. yum install zlib-devel readline-devel but why are you compiling postgres 9.3 and not using the yum.postgresql.org version ? -- john r pierce, recycling bits in santa cruz
On Wed, 2016-08-24 at 07:56 +0000, kashyap.nagendra@xerox.com wrote: > The following bug has been logged on the website: >=20 > Bug reference:=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A014292 > Logged by:=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0nag= endra kashyap > Email address:=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0kashyap.nagendra@xerox.= com > PostgreSQL version: 9.3.14 > Operating system:=C2=A0=C2=A0=C2=A0RHEL7 > Description:=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 >=20 > While configuring postgresql 9.3 we received below errors. Preferred approach is to use PGDG rpms from yum.postgresql.org enable repo: yum install=C2=A0https://download.postgresql.org/pub/repos/yum/9.3/redhat/r= h el-7-x86_64/pgdg-redhat93-9.3-2.noarch.rpm install postgresql: yum install postgresql93-server postgresql93-contrib > ********************************** > configure: error: readline library not=C2=A0 > found > If you have readline already installed, see config.log for details on > the > failure.=C2=A0=C2=A0It is possible the compiler isn't looking in the prop= er > directory. > Use --without-readline to disable readline support > *********************************** > configure: error: zlib library not found > If you have zlib already installed, see config.log for details on the > failure.=C2=A0=C2=A0It is possible the compiler isn't looking in the prop= er > directory. > Use --without-zlib to disable zlib support. > *********************************** > So we had to use below configuration command. > ************************************* > ./configure --mandir=3D/u01/Database/PostgreSQL/9.3/man > --prefix=3D/u01/Database/PostgreSQL/9.3 --without-readline --without- > zlib > ************************************** > But I believe there would be some issue in the future if we disable > zlib. So > could you please=C2=A0=C2=A0if we can reconfigure the postgresql with zli= b with > out > disturbing the existing system or should be reinstall the database? >=20 > Please let us know. >=20 >=20 >=20 >=20 Without readline library (some of them): 1 command editing is not possible in psql 2 history navigation not possible in psql Without zlib: pg_dump, pg_restore, pg_baseback will not support compression/uncompression --=20 Kind Regards, Yogesh Sharma Data Architect Crunchy Data -=C2=A0http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development