On Fri, Jul 31, 2009 at 3:02 AM, Daniel Verite <dan...@manitou-mail.org>wrote:

>        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)
>



Thanks.Yes, it was still there. I un-installed it.
Should I still add the pg_config to the $PATH ?
>> export PATH=/opt/PostgreSQL/8.4/bin/:$PATH




> 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.
>


r...@ubuntu-904-jaunty-64-minimal:~# dpkg -l 'postgresql*'
Desired=Unknown/Install/Remove/Purge/Hold
|
Status=Not/Inst/Cfg-files/Unpacked/Failed-cfg/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err:
uppercase=bad)
||/ Name                       Version                    Description
+++-==========================-==========================-====================================================================
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?



> > 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.
>


Ok, that's good to hear. I must have missed un-installing the package
mentioned above.
What I did was to uninstall the postgresql-common which then removed some
other depending packages.I am not sure how this package got installed.



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


Sincerely / Jennifer

Reply via email to