Thread: Change config of running PGSQL

Change config of running PGSQL

From
"McDougall, Marshall (FSH)"
Date:
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.

Regards, Marshall

Re: Change config of running PGSQL

From
Doug McNaught
Date:
"McDougall, Marshall (FSH)" <MarMcDouga@gov.mb.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

Re: Change config of running PGSQL

From
"McDougall, Marshall (FSH)"
Date:
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@mcnaught.org]
Sent: Tuesday, August 31, 2004 10:39 AM
To: McDougall, Marshall (FSH)
Cc: 'pgsql-general@postgresql.org'
Subject: Re: [GENERAL] Change config of running PGSQL


"McDougall, Marshall (FSH)" <MarMcDouga@gov.mb.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

Re: Change config of running PGSQL

From
Doug McNaught
Date:
"McDougall, Marshall (FSH)" <MarMcDouga@gov.mb.ca> writes:

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

You don't say what system you're on, but most Linux distributions
split library packages like readline into 'runtime' and 'devel'
packages.  You need the latter in order to compile software that ses
the library.  On HedHat/Fedora, it would be called 'readline-devel' or
some such.

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