Обсуждение: 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
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:
> 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.
>
>
>
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