Thread: How to find out about zlib compression
Dear all,
It says in the postgresql 8 documentation :
"If PostgreSQL was built on a system with the zlib compression library installed, the custom dump format will compress data as it writes it to the output file"
My question, if we are using binaries on a rpm based system and without looking at the src.rpm is there a way to query the postgresql server to find out whether it was built against the zlib compression library ?
Thank you in advance
Low Kian Seong
It says in the postgresql 8 documentation :
"If PostgreSQL was built on a system with the zlib compression library installed, the custom dump format will compress data as it writes it to the output file"
My question, if we are using binaries on a rpm based system and without looking at the src.rpm is there a way to query the postgresql server to find out whether it was built against the zlib compression library ?
Thank you in advance
Low Kian Seong
On Sunday 22 October 2006 09:43, Low Kian Seong wrote: | It says in the postgresql 8 documentation : | | "If PostgreSQL was built on a system with the zlib compression library | installed, the custom dump format will compress data as it writes it to the | output file" | | My question, if we are using binaries on a rpm based system and without | looking at the src.rpm is there a way to query the postgresql server to | find out whether it was built against the zlib compression library ? ldd /path/to/your/bin/postgres | grep libz Ciao, Thomas -- Thomas Pundt <thomas.pundt@rp-online.de> ---- http://rp-online.de/ ----
On Sun, Oct 22, 2006 at 09:55:23AM +0200, Thomas Pundt wrote: > On Sunday 22 October 2006 09:43, Low Kian Seong wrote: > | It says in the postgresql 8 documentation : > | > | "If PostgreSQL was built on a system with the zlib compression library > | installed, the custom dump format will compress data as it writes it to the > | output file" > | > | My question, if we are using binaries on a rpm based system and without > | looking at the src.rpm is there a way to query the postgresql server to > | find out whether it was built against the zlib compression library ? > > ldd /path/to/your/bin/postgres | grep libz You should be checking the libraries used by pg_dump, not postgres. It's pg_dump that does the compression, the actual server does not use an external compression library (directly anyway). Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment
"Low Kian Seong" <postgresql.low@gmail.com> writes:
> My question, if we are using binaries on a rpm based system and without
> looking at the src.rpm is there a way to query the postgresql server to find
> out whether it was built against the zlib compression library ?
pg_config --configure | grep -e '--without-zlib'
In practice, there is 0 chance that an RPM distribution would be built
without zlib.
regards, tom lane
On 10/23/06, Tom Lane <tgl@sss.pgh.pa.us> wrote: > "Low Kian Seong" <postgresql.low@gmail.com> writes: > > My question, if we are using binaries on a rpm based system and without > > looking at the src.rpm is there a way to query the postgresql server to find > > out whether it was built against the zlib compression library ? > > pg_config --configure | grep -e '--without-zlib' I am using pclinuxos and it seems to come without pg_config. > > In practice, there is 0 chance that an RPM distribution would be built > without zlib. > > regards, tom lane >
"Low Kian Seong" <postgresql.low@gmail.com> writes:
> On 10/23/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> pg_config --configure | grep -e '--without-zlib'
> I am using pclinuxos and it seems to come without pg_config.
It might be in the -devel RPM.
If it's not there at all, get a real linux distro ...
regards, tom lane