Re: [GENERAL] Installing postgresql on Debian Lenny--my /etc/apt/sources.list.
Le vendredi 11 septembre 2009, Ricky Tompu Breaky a écrit :
Dear Peter Eisentraut.
My aptitude still can not find it.
you didn't search with aptitude but tried to install. My guess is that it is
already installed. try a 'dpkg -l postgresql-8.3' it will output something
like :
[...]
ii postgresql-8.3 8.3.8-1 object-relational SQL database, version 8.3 server
if it is installed.
You have probably a misconfigured server which don't start *or* (more
proabaly) the server is listenning on another port than 5432.
Please keep telling me.
Thank you very much in advance.
Here is the output of my postgres installation attempt with aptitude and
my current '/etc/apt/sources.list':
lenny:/etc/apt# dpkg-reconfigure gforge-db-postgresql
lenny:/etc/apt# aptitude install postgresql-8.3 postgresql-client-8.3
postgresql-client Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading extended state information
Initializing package states... Done
Reading task descriptions... Done
The following partially installed packages will be configured:
gforge-web-apache2
0 packages upgraded, 0 newly installed, 0 to remove and 199 not
upgraded. Need to get 0B of archives. After unpacking 0B will be used.
Writing extended state information... Done
Setting up gforge-web-apache2 (4.7~rc2-7lenny1) ...
Calculating defaults
Reading defaults from /etc/gforge/gforge.conf
Creating /etc/gforge/gforge.conf
SSL Enabled
Creating /etc/gforge/httpd.conf
Creating /etc/gforge/httpd.secrets
Creating /etc/gforge/local.inc
Creating other includes
DBI connect('dbname=gforge','gforge',...) failed: could not connect to
server: No such file or directory Is the server running locally and
accepting connections on Unix domain socket
/var/run/postgresql/.s.PGSQL.5432? at /usr/lib/gforge/lib/include.pl
line 37 Error while connecting to database:
at /usr/lib/gforge/lib/include.pl line 39. dpkg: error processing
gforge-web-apache2 (--configure): subprocess post-installation script
returned error exit status 255 Errors were encountered while
processing: gforge-web-apache2 E: Sub-process /usr/bin/dpkg returned an
error code (1) A package failed to install. Trying to recover:
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading extended state information
Initializing package states... Done
Reading task descriptions... Done
lenny:/etc/apt#
my '/etc/apt/sources.list':
#
# deb cdrom:[Debian GNU/Linux 5.0.2 _Lenny_ - Official i386 NETINST
Binary-1 20090629-11:06]/ lenny main
#deb cdrom:[Debian GNU/Linux 5.0.2 _Lenny_ - Official i386 NETINST
Binary-1 20090629-11:06]/ lenny main
deb http://ftp.de.debian.org/debian/ lenny main
deb-src http://ftp.de.debian.org/debian/ lenny main
deb http://security.debian.org/ lenny/updates main
deb-src http://security.debian.org/ lenny/updates main
deb http://volatile.debian.org/debian-volatile lenny/volatile main
deb-src http://volatile.debian.org/debian-volatile lenny/volatile main
deb http://ftp2.de.debian.org/debian/ lenny main non-free
deb-src http://ftp2.de.debian.org/debian/ lenny main non-free
deb http://security.debian.org/ lenny/updates main non-free
deb-src http://security.debian.org/ lenny/updates main non-free
deb http://www.lamaresh.net/apt lenny main
deb http://dl.google.com/linux/deb/ stable non-free
deb http://download.skype.com/linux/repos/debian/ stable non-free
deb ftp://ftp.it.debian.org/debian/ lenny main contrib non-free
deb-src ftp://ftp.it.debian.org/debian/ lenny main contrib non-free
deb ftp://ftp.it.debian.org/debian/ lenny-proposed-updates main contrib
non-free deb-src ftp://ftp.it.debian.org/debian/ lenny-proposed-updates
main contrib non-free
deb http://deb.opera.com/opera/ stable non-free
deb http://pkg-voip.buildserver.net/debian etch main
deb http://mirror.noreply.org/pub/tor lenny main
deb-src http://mirror.noreply.org/pub/tor lenny main
deb http://javadesktop.org/lg3d/debian stable contrib
deb http://ftp.bononia.it/debian lenny main contrib non-free
deb http://ftp.bononia.it/debian lenny-proposed-updates main contrib
non-free
deb http://ftp.debian.org/debian/ lenny main contrib non-free
===
On Fri, 11 Sep 2009 09:56:33 +0300
Peter Eisentraut pete...@gmx.net wrote:
On Fri, 2009-09-11 at 13:17 +0700, Ricky Tompu Breaky wrote:
It seems that the aptitude can not find the postgresql.
Please post the exact output from the screen.
--
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org
signature.asc
Description: This is a digitally signed message part.
[GENERAL] Installing postgresql on Debian Lenny--my /etc/apt/sources.list.
Dear my friends, I want to install PostgreSQL in my Debian Lenny box. I can't install PostgreSQL with aptitude: aptitude install postgresql . It seems that the aptitude can not find the postgresql. This is my '/etc/apt/sources.list'. I have done aptitude update too. And it was completed properly. Please tell me what is my mistake. Thank you very much in advance. === deb http://security.debian.org/ stable/updates main contrib deb ftp://packages.debian.org/debian/ stable main contrib non-free deb-src ftp://packages.debian.org/debian/ stable main contrib non-free deb http://kambing.ui.edu/debian/ stable main contrib non-free deb http://kambing.ui.edu/debian-security/ stable/updates main contrib non-free deb-src http://kambing.ui.edu/debian/ stable main contrib non-free deb-src http://kambing.ui.edu/debian-security/ stable/updates main contrib non-free deb http://security.debian.org/ testing/updates main contrib deb ftp://packages.debian.org/debian/ testing main contrib non-free deb-src ftp://packages.debian.org/debian/ testing main contrib non-free deb http://kambing.ui.edu/debian/ testing main contrib non-free deb http://kambing.ui.edu/debian-security/ testing/updates main contrib non-free deb-src http://kambing.ui.edu/debian/ testing main contrib non-free deb-src http://kambing.ui.edu/debian-security/ testing/updates main contrib non-free -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Installing postgresql on Debian Lenny--my /etc/apt/sources.list.
On Fri, 2009-09-11 at 13:17 +0700, Ricky Tompu Breaky wrote: It seems that the aptitude can not find the postgresql. Please post the exact output from the screen. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Installing postgresql on Debian Lenny--my /etc/apt/sources.list.
Ricky Tompu Breaky wrote: Dear my friends, I want to install PostgreSQL in my Debian Lenny box. I can't install PostgreSQL with aptitude: aptitude install postgresql . What Peter said, but you might also want to do aptitude search postgresql. That should find packages including postgresql, postgresql-client, postgresql-8.3, postgresql-client-8.3. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Installing postgresql on Debian Lenny--my /etc/apt/sources.list.
Dear Peter Eisentraut.
My aptitude still can not find it.
Please keep telling me.
Thank you very much in advance.
Here is the output of my postgres installation attempt with aptitude and
my current '/etc/apt/sources.list':
lenny:/etc/apt# dpkg-reconfigure gforge-db-postgresql
lenny:/etc/apt# aptitude install postgresql-8.3 postgresql-client-8.3
postgresql-client Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading extended state information
Initializing package states... Done
Reading task descriptions... Done
The following partially installed packages will be configured:
gforge-web-apache2
0 packages upgraded, 0 newly installed, 0 to remove and 199 not
upgraded. Need to get 0B of archives. After unpacking 0B will be used.
Writing extended state information... Done
Setting up gforge-web-apache2 (4.7~rc2-7lenny1) ...
Calculating defaults
Reading defaults from /etc/gforge/gforge.conf
Creating /etc/gforge/gforge.conf
SSL Enabled
Creating /etc/gforge/httpd.conf
Creating /etc/gforge/httpd.secrets
Creating /etc/gforge/local.inc
Creating other includes
DBI connect('dbname=gforge','gforge',...) failed: could not connect to
server: No such file or directory Is the server running locally and
accepting connections on Unix domain socket
/var/run/postgresql/.s.PGSQL.5432? at /usr/lib/gforge/lib/include.pl
line 37 Error while connecting to database:
at /usr/lib/gforge/lib/include.pl line 39. dpkg: error processing
gforge-web-apache2 (--configure): subprocess post-installation script
returned error exit status 255 Errors were encountered while
processing: gforge-web-apache2 E: Sub-process /usr/bin/dpkg returned an
error code (1) A package failed to install. Trying to recover:
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading extended state information
Initializing package states... Done
Reading task descriptions... Done
lenny:/etc/apt#
my '/etc/apt/sources.list':
#
# deb cdrom:[Debian GNU/Linux 5.0.2 _Lenny_ - Official i386 NETINST
Binary-1 20090629-11:06]/ lenny main
#deb cdrom:[Debian GNU/Linux 5.0.2 _Lenny_ - Official i386 NETINST
Binary-1 20090629-11:06]/ lenny main
deb http://ftp.de.debian.org/debian/ lenny main
deb-src http://ftp.de.debian.org/debian/ lenny main
deb http://security.debian.org/ lenny/updates main
deb-src http://security.debian.org/ lenny/updates main
deb http://volatile.debian.org/debian-volatile lenny/volatile main
deb-src http://volatile.debian.org/debian-volatile lenny/volatile main
deb http://ftp2.de.debian.org/debian/ lenny main non-free
deb-src http://ftp2.de.debian.org/debian/ lenny main non-free
deb http://security.debian.org/ lenny/updates main non-free
deb-src http://security.debian.org/ lenny/updates main non-free
deb http://www.lamaresh.net/apt lenny main
deb http://dl.google.com/linux/deb/ stable non-free
deb http://download.skype.com/linux/repos/debian/ stable non-free
deb ftp://ftp.it.debian.org/debian/ lenny main contrib non-free
deb-src ftp://ftp.it.debian.org/debian/ lenny main contrib non-free
deb ftp://ftp.it.debian.org/debian/ lenny-proposed-updates main contrib
non-free deb-src ftp://ftp.it.debian.org/debian/ lenny-proposed-updates
main contrib non-free
deb http://deb.opera.com/opera/ stable non-free
deb http://pkg-voip.buildserver.net/debian etch main
deb http://mirror.noreply.org/pub/tor lenny main
deb-src http://mirror.noreply.org/pub/tor lenny main
deb http://javadesktop.org/lg3d/debian stable contrib
deb http://ftp.bononia.it/debian lenny main contrib non-free
deb http://ftp.bononia.it/debian lenny-proposed-updates main contrib
non-free
deb http://ftp.debian.org/debian/ lenny main contrib non-free
===
On Fri, 11 Sep 2009 09:56:33 +0300
Peter Eisentraut pete...@gmx.net wrote:
On Fri, 2009-09-11 at 13:17 +0700, Ricky Tompu Breaky wrote:
It seems that the aptitude can not find the postgresql.
Please post the exact output from the screen.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 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 [EMAIL PROTECTED]:/# 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 [EMAIL PROTECTED]:/# 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 [EMAIL PROTECTED] (Michael Ben-Nes) wrote in message news:[EMAIL PROTECTED]... 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 [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Installing PostgreSQL in Debian
On Wed, Apr 13, 2005 at 03:48:59PM -0700, erico [EMAIL PROTECTED] 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 [EMAIL PROTECTED]
Re: [GENERAL] 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 [EMAIL PROTECTED])
Re: [GENERAL] 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 [EMAIL PROTECTED]
Re: [GENERAL] 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
[GENERAL] 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
Re: [GENERAL] 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, [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] Installing PostgreSQL in Debian
On Fri, 18 Mar 2005 08:39:46 +0800 (CST), S Ram [EMAIL PROTECTED] 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[EMAIL PROTECTED] LlamaLand http://netllama.linux-sxs.org ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] 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/dists/stable/postgresql/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 [EMAIL PROTECTED]
