Unix Technical Forum

Installing PostgreSQL in Debian

This is a discussion on Installing PostgreSQL in Debian within the Pgsql General forums, part of the PostgreSQL category; --> Hello, PostgreSQL is distributed as .RPM files. How do I install this in Debian? Thanks __________________________________ Do you Yahoo!? ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql General

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-08-2008, 08:06 PM
S Ram
 
Posts: n/a
Default Installing PostgreSQL in Debian

Hello,

PostgreSQL is distributed as .RPM files. How do I
install this in Debian?

Thanks




__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-08-2008, 08:06 PM
jcradock@me3.com
 
Posts: n/a
Default Re: Installing PostgreSQL in Debian

On Debian install PostgreSQL via APT. If you have APT installed:

1. Change to root.
2. Type apt-update.
3. Type apt-get install postgresql postgresql-client

#2 updates your APT package list to the lastest-and-greatest. #3 installed
the server and client applications.

I'd read up on APT at the Debian home page:

http://www.debian.org

Regards,

Jim


> Hello,
>
> PostgreSQL is distributed as .RPM files. How do I
> install this in Debian?
>
> Thanks
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>




-----
James Cradock, jcradock@me3.com



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-08-2008, 08:06 PM
Lonni J Friedman
 
Posts: n/a
Default Re: Installing PostgreSQL in Debian

On Fri, 18 Mar 2005 08:39:46 +0800 (CST), S Ram <ramwebreg@yahoo.com.sg> wrote:
> Hello,
>
> PostgreSQL is distributed as .RPM files. How do I
> install this in Debian?


apt-get i'd imagine

or build from source.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-08-2008, 08:06 PM
Grant McLean
 
Posts: n/a
Default Re: Installing PostgreSQL in Debian

On Fri, 2005-03-18 at 08:39 +0800, S Ram wrote:
> Hello,
>
> PostgreSQL is distributed as .RPM files. How do I
> install this in Debian?


As others have said, apt-get will install PostgreSQL from the standard
Debian repositories. However, if you're running Debian stable, you
might want to use a more recent version of PostgreSQL than the 7.2.1.

Backports.org has 7.4.7 here:

http://www.backports.org/debian/dist...l/binary-i386/

So you'd need to put something like this in your /etc/apt/sources.list

deb http://www.backports.org/debian/ stable postgresql

Cheers
Grant


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-08-2008, 08:07 PM
Michael Ben-Nes
 
Posts: n/a
Default Re: Installing PostgreSQL in Debian

I recomend you to compile PG from source so you can use the new 8.0.1

Cheers


S Ram wrote:

>Hello,
>
>PostgreSQL is distributed as .RPM files. How do I
>install this in Debian?
>
>Thanks
>
>
>
>
>__________________________________
>Do you Yahoo!?
>Yahoo! Small Business - Try our new resources site!
>http://smallbusiness.yahoo.com/resources/
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>
>


--
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Cel: 972-52-8555757
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 04-08-2008, 08:08 PM
Peter Eisentraut
 
Posts: n/a
Default Re: Installing PostgreSQL in Debian

Michael Ben-Nes wrote:
> I recomend you to compile PG from source so you can use the new 8.0.1


PostgreSQL 8.0.1 is available in the Debian experimental suite, package
name "postgresql-8.0".

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 04-08-2008, 08:08 PM
Michael Ben-Nes
 
Posts: n/a
Default Re: Installing PostgreSQL in Debian

Yep

but that Expermental


Peter Eisentraut wrote:

>Michael Ben-Nes wrote:
>
>
>>I recomend you to compile PG from source so you can use the new 8.0.1
>>
>>

>
>PostgreSQL 8.0.1 is available in the Debian experimental suite, package
>name "postgresql-8.0".
>
>
>


--
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Cel: 972-52-8555757
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 04-08-2008, 08:32 PM
erico
 
Posts: n/a
Default Re: Installing PostgreSQL in Debian

Dear sirs,,

I hope you all can help me. I am a average linux user . I manage to
install it and its main packages on a AMD 2,4 GHZ with 256 RAM MB.
Everything is working fine . I use a brazilian version, namely Linux
2.4.25-klg #1 SMP Ter Abr 6 09:28:24 BRT 2004 i686 GNU/Linux.
The problem is that today I tried installing postgresql but I always
get the errors as follows:

QUOTE
root@ericohg:/# apt-get update
Atingido http://ftp.fr.debian.org testing/main Packages
Atingido http://ftp.fr.debian.org testing/main Release
Atingido http://ftp.fr.debian.org testing/contrib Packages
Atingido http://ftp.fr.debian.org testing/contrib Release
Obtendo:1 http://www.backports.org stable/postgresql Packages [5288B]
Obtendo:2 http://www.backports.org stable/postgresql Release [141B]
Atingido http://ftp.fr.debian.org testing/non-free Packages
Atingido http://ftp.fr.debian.org testing/non-free Release
Atingido http://ftp.fr.debian.org testing/non-US/main Packages
Atingido http://ftp.fr.debian.org testing/non-US/main Release
Atingido http://ftp.fr.debian.org testing/non-US/contrib Packages
Atingido http://ftp.fr.debian.org testing/non-US/contrib Release
Atingido http://ftp.fr.debian.org testing/non-US/non-free Packages
Atingido http://ftp.fr.debian.org testing/non-US/non-free Release
Baixados 5429B em 6s (845B/s)
Lendo Lista de Pacotes... Pronto
root@ericohg:/# apt-get install postgresql postgresql-client
Lendo Lista de Pacotes... Pronto
Construindo Árvore de Dependências... Pronto
postgresql-client já é a versão mais nova.
Pacotes sugeridos :
libpg-perl libpgjava libpgtcl postgresql-doc postgresql-dev
postgresql-contrib pgdocs pgaccess
Os NOVOS pacotes a seguir serão instalados:
postgresql
0 pacotes atualizados, 1 pacotes novos instalados, 0 a serem removidos
e 66 não atualizados.
1 pacotes não totalmente instalados ou removidos.
É preciso fazer o download de 0B/3793kB de arquivos.
Depois de desempacotamento, 9806kB adicionais de espaço em disco serão
usados.
Preconfiguring packages ...
/tmp/postgresql.config.26871: line 12: Acquire: command not found
postgresql falhou na preconfiguração com estado de saída 127
(Lendo banco de dados ... 93942 arquivos e diretórios atualmente
instalados.)
Descompactando postgresql (de .../postgresql_7.4.7-3_i386.deb) ...
/var/lib/dpkg/tmp.ci/config: line 12: Acquire: command not found
dpkg: erro processando
/var/cache/apt/archives/postgresql_7.4.7-3_i386.deb (--unpack):
subprocesso pre-installation script retornou código de saída de error
127
Erros foram encontrados durante processamento de:
/var/cache/apt/archives/postgresql_7.4.7-3_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

UNQUOTE

I changed the source.list to get from another source (three, namely BR
(Brazil, US and FR) and, according to the information obtained here,
even added the content "http://www.backports.org stable/postgresql" to
the said file, as the default ftp sources have failed to work so far.

Although most of the output is in portuguese, one can learn that "
line 12: Acquire: command not found" is a mistake that i can not find
a solution to install Postgresql correctly.
I have been in many lists an web but I fail to find a hint to correct
that.
Do any of you have any hint to solve this problem?
Thanks in advance.
Érico




miki@canaan.co.il (Michael Ben-Nes) wrote in message news:<423ED7EC.9090601@canaan.co.il>...
> Yep
>
> but that Expermental
>
>
> Peter Eisentraut wrote:
>
> >Michael Ben-Nes wrote:
> >
> >
> >>I recomend you to compile PG from source so you can use the new 8.0.1
> >>
> >>

> >
> >PostgreSQL 8.0.1 is available in the Debian experimental suite, package
> >name "postgresql-8.0".
> >
> >
> >

>
> --
> --------------------------
> Canaan Surfing Ltd.
> Internet Service Providers
> Ben-Nes Michael - Manager
> Tel: 972-4-6991122
> Cel: 972-52-8555757
> Fax: 972-4-6990098
> http://www.canaan.net.il
> --------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 04-08-2008, 08:33 PM
Stephane Bortzmeyer
 
Posts: n/a
Default Re: Installing PostgreSQL in Debian

On Wed, Apr 13, 2005 at 03:48:59PM -0700,
erico <ericobr@click21.com.br> wrote
a message of 112 lines which said:

> Lendo Lista de Pacotes... Pronto
> Construindo Árvore de Dependências... Pronto


Before posting on an english-speaking mailing list, I suggest to set
your locale to C... ("export LC_MESSAGES=C" for instance)

> /tmp/postgresql.config.26871: line 12: Acquire: command not found


A mix between apt.conf or apt.conf.d and sources.list? Acquire is not
in Postgres sources so the error seems to be specific to your system
and not PostgreSQL-related. Show us these files.

Also, you mix "backports for stable" and "testing" in your sources.list
which is very surprising.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:55 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com