Hi.

I has compiled a postgresql 7.1.3 into a Debian GNU/Linux. The
"configure" option has the 'max-backends', 'enable-locale' and
'enable-syslog' options.
When I make a:
	pg_dump -O -x -Fc <database> > backupdatabase.sql
The program tell me a "warning" like this:

Archiver: WARNING - requested compression not available in this
installation - archive will be uncompressed

What I make to do for obtain the necessary compression for the "-Fc"
flag and work after with pg_restore?

Thank you very much.

Have a nice day ;-)
TooManySecrets

-- 
Manuel Trujillo         manueltrujillo@dorna.es
Technical Engineer      http://www.motograndprix.com
Dorna Sports S.L.       +34 93 4702864

Tue, 4 Dec 2001 09:45:13 +0100
Manuel Trujillo <manueltrujillo@dorna.es>
compression -Fx "problem"
Manuel Trujillo <manueltrujillo@dorna.es> writes:
> The program tell me a "warning" like this:
> Archiver: WARNING - requested compression not available in this
> installation - archive will be uncompressed
> What I make to do for obtain the necessary compression for the "-Fc"
> flag and work after with pg_restore?

You need to install zlib, then reconfigure and rebuild Postgres.
Pay attention to whether the configure run finds zlib...

			regards, tom lane

Tue, 04 Dec 2001 09:56:38 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: compression -Fx "problem" 
Tom Lane writes:

> You need to install zlib, then reconfigure and rebuild Postgres.
> Pay attention to whether the configure run finds zlib...

This has got to stop.  We've seen "my cursor keys don't work in psql", now
we see "compression doesn't work" every so often.  Somehow we have to get
deterministic output from configure without "paying attention".  Either
require these libraries by default (my preference) or not, but not "take
what's there".

-- 
Peter Eisentraut   peter_e@gmx.net


Tue, 4 Dec 2001 22:21:46 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: [ADMIN] compression -Fx "problem" 
Peter Eisentraut <peter_e@gmx.net> writes:
> This has got to stop.  We've seen "my cursor keys don't work in psql", now
> we see "compression doesn't work" every so often.  Somehow we have to get
> deterministic output from configure without "paying attention".  Either
> require these libraries by default (my preference) or not, but not "take
> what's there".

So you're thinking "error out unless user said --without-zlib or
--without-readline"?

I could live with that, assuming that the error message mentioned that
switch as the way to build without the library.

			regards, tom lane

Tue, 04 Dec 2001 16:26:37 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [ADMIN] compression -Fx "problem" 
> Peter Eisentraut <peter_e@gmx.net> writes:
> > This has got to stop.  We've seen "my cursor keys don't work in psql", now
> > we see "compression doesn't work" every so often.  Somehow we have to get
> > deterministic output from configure without "paying attention".  Either
> > require these libraries by default (my preference) or not, but not "take
> > what's there".
> 
> So you're thinking "error out unless user said --without-zlib or
> --without-readline"?

Or --my_cursor_keys_will_never_work_in_psql.  :-)

Not sure if they are going to make the connection between
--without-readline and psql cursor keys.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 4 Dec 2001 16:43:20 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [ADMIN] compression -Fx "problem"
> Peter Eisentraut <peter_e@gmx.net> writes:
> > This has got to stop.  We've seen "my cursor keys don't work in psql", now
> > we see "compression doesn't work" every so often.  Somehow we have to get
> > deterministic output from configure without "paying attention".  Either
> > require these libraries by default (my preference) or not, but not "take
> > what's there".
> 
> So you're thinking "error out unless user said --without-zlib or
> --without-readline"?
> 
> I could live with that, assuming that the error message mentioned that
> switch as the way to build without the library.

What I have seen some packages do is to report unusual configure
findings just a configure exits.  Something like:

	Your psql cursor keys will not work because readline wasn't found

or something like that for zlib.

Added to TODO:

	* Report failure to find readline or zlib at end of configure run

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 28 Dec 2001 14:47:23 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [ADMIN] compression -Fx "problem"
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Added to TODO:
> 	* Report failure to find readline or zlib at end of configure run

Peter will certainly not consider that an acceptable answer, since it
helps not at all for non-interactive builds.

			regards, tom lane

Fri, 28 Dec 2001 15:05:15 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [ADMIN] compression -Fx "problem" 
On Sat, 2001-12-29 at 09:05, Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Added to TODO:
> > 	* Report failure to find readline or zlib at end of configure run
> 
> Peter will certainly not consider that an acceptable answer, since it
> helps not at all for non-interactive builds.
> 

Doing that sort of thing is a huge improvement though.  Hopefully the
people who are doing auto builds have done them manually a few times
first!

To take it a bit further though, you could perhaps have it refuse to
continue beyond that without an explicit configure option.  That would
then stop the auto build as well.

Regards,
					Andrew.
-- 
--------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/        PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201    MOB: +64(21)635-694    OFFICE: +64(4)499-2267
       Are you enrolled at http://schoolreunions.co.nz/ yet?


29 Dec 2001 10:50:55 +1300
Andrew McMillan <andrew@catalyst.net.nz>
Re: [ADMIN] compression -Fx "problem"