Re: Change config of running PGSQL

Thanks for the response Doug. I started down the path that you suggested
and quickly found out why it was compiled that way. When the configure
script gets to checking readline libraries, it says it can't find them and
stops there ala:

<snip>
checking for main in -lresolv... yes
checking for library containing getopt_long... none required
checking for main in -lunix... no
checking for library containing crypt... -lcrypt
checking for __inet_ntoa in -lbind... no
checking for library containing fdatasync... none required
checking for shmget in -lcygipc... no
checking for readline... no
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.
</snip>

I made sure that readline was indeed installed to no avail. The configure
still does not see the libs. Any ideas?

Regards, Marshall

-----Original Message-----
From: Doug McNaught [mailto:doug(at)mcnaught(dot)org]
Sent: Tuesday, August 31, 2004 10:39 AM
To: McDougall, Marshall (FSH)
Cc: 'pgsql-general(at)postgresql(dot)org'
Subject: Re: [GENERAL] Change config of running PGSQL

"McDougall, Marshall (FSH)" <MarMcDouga(at)gov(dot)mb(dot)ca> writes:

> I have an existing installation of 7.3.4 that appears to have been made
with
> "--without-readline and --without-zlib" parameters used at build time.
How
> do I change those parms without reinstalling the whole thing. I would
> normally go through the archives, but they appear to be unavailable. All
> replies appreciated.

The minumum you can do is recompile with the configure options you
want, move the affected new binaries into place, and restart. There's
really no reason not to do a full "make install" though--you won't have
to dump and reload your data, and it's easier than figuring out by
hand what you need to upgrade...

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863