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.

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

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 <peter_e@gmx.net> wrote:

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@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