Thread: pg_config --sharedir points to the wrong folder.. is this a problem?

On 07/30/2009 08:38 PM, Jennifer Trey wrote:
> Hi,
>
> First I installed postgres using the apt-get utility on ubuntu, and
> then later uninstalled it to install postgres though the one-click
> installer.
>
> Trying to find the share folder i ran pg_config and it shows the old
> path : /usr/share/postgresql/8.3
>
> I have a pg_config under my new installation as well
> : /opt/PostgreSQL/8.4/bin/pg_config
> but apperantly this is not being used in the global scope.
>
> Am I missing something? Did I un-install incorrectly perhaps? Is this
> a problem, could other files, pg_programs possibly have the same issue?
>
> Sincerely / Jennifer
It seems your uninstallation dint worked well. as you still have apt-get
installed pg_config which might be possible if you tried uninstalling
before stopping postgres server. (I am not so sure about it).

You can include /opt/PostgreSQL/8.4/bin folder to your PATH environment
variable to have one-click installers pg_config being used in global
scope. (Make sure you remove the apt-gets installation correctly)

--
Regards,
Sachin Srivastava
www.enterprisedb.com

    Jennifer Trey wrote:

> >> locate pg_config
> /opt/PostgreSQL/8.4/bin/pg_config
> /opt/PostgreSQL/8.4/include/ecpg_config.h
> /opt/PostgreSQL/8.4/include/pg_config.h
> /opt/PostgreSQL/8.4/include/pg_config_manual.h
> /opt/PostgreSQL/8.4/include/pg_config_os.h
> /opt/PostgreSQL/8.4/include/postgresql/server/pg_config.h
> /opt/PostgreSQL/8.4/include/postgresql/server/pg_config_manual.h
> /opt/PostgreSQL/8.4/include/postgresql/server/pg_config_os.h
> /opt/PostgreSQL/8.4/share/man/man1/pg_config.1
> /usr/bin/pg_config
> /usr/share/man/man1/pg_config.1.gz

> >> echo $PATH
> /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
>
> I am guessing I should delete the pg_config (or else there would be a
> conflict, right?) in the /usr/bin

Actually you should restrain from doing that, because it would break the
package that installed that file, and then your system would become harder to
manage in the long run. It's better to act at the package level with the dpkg
command.

/usr/bin/pg_config is part of the libpq-dev package (this can be found with
dpkg -S /usr/bin/pg_config)

Probably you haven't uninstalled this package, which you can check by
running:
dpkg -s libpq-dev (look at the Status field). In this case, remove it
(apt-get remove libpq-dev)

You can also remove the postgresql-common and postgresql-client-8.3 packages
if they're still there and you want to avoid any possible conflict with your
other postgresql installation.
dpkg -l 'postgresql*' also displays the list of most PG-related packages and
whether they're installed or not.

> Is there other things that could have been destroyed by the bad
> un-installment other than pg_config or was that it ?

It doesn't look like the uninstallation of the server itself has gone bad in
any way. You mentioned removing the package without stopping the server
beforehand, but personally I doubt that the package uninstall process doesn't
do it automatically.

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org

    Jennifer Trey wrote:

> Should I still add the pg_config to the $PATH ?
> >> export PATH=/opt/PostgreSQL/8.4/bin/:$PATH

Yes.

> pn  postgresql                 <none>                     (no description
> available)
> un  postgresql-7.4             <none>                     (no description
> available)
> un  postgresql-8.0             <none>                     (no description
> available)
> rc  postgresql-8.3             8.3.7-1                    object-relational
> SQL database, version 8.3 server
> pn  postgresql-client          <none>                     (no description
> available)
> pn  postgresql-client-8.3      <none>                     (no description
> available)
> pn  postgresql-client-common   <none>                     (no description
> available)
> rc  postgresql-common          97                         PostgreSQL
> database-cluster manager
> un  postgresql-dev             <none>                     (no description
> available)
> un  postgresql-doc-8.3         <none>                     (no description
> available)
>
> Looks fine?

Definitely.

Best regards,
--
 Daniel
 PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org