Postgres Pro
Downloads
Home   >   mailing lists

Thread: doubt

doubt

From
Mogin Mohandas
Date:
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

Re: doubt

From
"Joshua D. Drake"
Date:
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

Re: doubt

From
"Dong B. Calmada"
Date:
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

Re: doubt

From
"Joshua D. Drake"
Date:
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

Re: doubt

From
Jonathan Daugherty
Date:
# 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

Re: doubt

From
"Dong B. Calmada"
Date:
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?

Re: doubt

From
"Joshua D. Drake"
Date:
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