Re: 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 <peter_e(at)gmx(dot)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