Обсуждение: doubt
Hi again
I just wanted to know for extending the database, is it
better to install postgres from a pre-installed package or source. I
have installed ubuntu and was trying to install from source. Please
give me some opinions.
Thank you
Mogin
Mogin Mohandas wrote: > Hi again > I just wanted to know for extending the database, is it > better to install postgres from a pre-installed package or source. I > have installed ubuntu and was trying to install from source. Please > give me some opinions. It depends on what you mean by Extend. If you mean adding contrib modules, custom functions etc... then just make sure that you have all of postgresql installed... libecpg-dev - development files for ECPG (Embedded PostgreSQL for C) libecpg4 - run-time library for ECPG programs libpq3 - PostgreSQL C client library postgresql - object-relational SQL database management system postgresql-client - front-end programs for PostgreSQL postgresql-dev - development files for libpq (PostgreSQL library) postgresql-doc - documentation for the PostgreSQL database management > Thank you > Mogin > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend -- Your PostgreSQL solutions provider, Command Prompt, Inc. 24x7 support - 1.800.492.2240, programming, and consulting Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit http://www.commandprompt.com / http://www.postgresql.org
According to Joshua D. Drake: > Date: Wed, 06 Jul 2005 20:52:22 -0700 > > It depends on what you mean by Extend. If you mean adding contrib > modules, custom functions etc... then just make sure that you have all > of postgresql installed... > > libecpg-dev - development files for ECPG (Embedded PostgreSQL for C) > libecpg4 - run-time library for ECPG programs > libpq3 - PostgreSQL C client library > postgresql - object-relational SQL database management system > postgresql-client - front-end programs for PostgreSQL > postgresql-dev - development files for libpq (PostgreSQL library) > postgresql-doc - documentation for the PostgreSQL database management > I also advise 'postgresql-autodoc'. With it you can generate htmlized documentation as well as Dia-based E-R diagram. Dong
Dong B. Calmada wrote: > According to Joshua D. Drake: > >>Date: Wed, 06 Jul 2005 20:52:22 -0700 >> >>It depends on what you mean by Extend. If you mean adding contrib >>modules, custom functions etc... then just make sure that you have all >>of postgresql installed... >> >>libecpg-dev - development files for ECPG (Embedded PostgreSQL for C) >>libecpg4 - run-time library for ECPG programs >>libpq3 - PostgreSQL C client library >>postgresql - object-relational SQL database management system >>postgresql-client - front-end programs for PostgreSQL >>postgresql-dev - development files for libpq (PostgreSQL library) >>postgresql-doc - documentation for the PostgreSQL database management >> > > > I also advise 'postgresql-autodoc'. With it you can generate htmlized > documentation as well as Dia-based E-R diagram. I don't show that as a package in my apt-cache? > > Dong -- Your PostgreSQL solutions provider, Command Prompt, Inc. 24x7 support - 1.800.492.2240, programming, and consulting Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit http://www.commandprompt.com / http://www.postgresql.org
# I don't show that as a package in my apt-cache? It's in mine on debian testing. Redhat's package cache isn't nearly as extensive; I've found numerous widely-available packages missing from it, even ones you can get on redhat CDs. -- Jonathan Daugherty Lead Programmer Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Replication & Support Services, (503) 667-4564
According to Joshua D. Drake: > > I don't show that as a package in my apt-cache? postgresql-autodoc is under the 'multiverse' category. Have you added the keyword to the sources.list's archive entry?
Dong B. Calmada wrote: > According to Joshua D. Drake: > >>I don't show that as a package in my apt-cache? > > > postgresql-autodoc is under the 'multiverse' category. Have you added the > keyword to the sources.list's archive entry? Aha! I had universe not multiverse. Thanks for the tip. J -- Your PostgreSQL solutions provider, Command Prompt, Inc. 24x7 support - 1.800.492.2240, programming, and consulting Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit http://www.commandprompt.com / http://www.postgresql.org