RE: Postgresql 7.02 and Debian
Thanks for the quick responses!
>
>If you built postgresql on your own, you may find it easier in the long
>run to build the 7.0.2 debian packages from source, especially if you're
>planning on running it on more than one machine.
Sounds like the right thing to do.
>Briefly:
>1) add deb-src http://http.us.debian.org/debian unstable main contrib
>non-free
> to your /etc/apt/sources.list
Here's the modified file:
#Debian
#deb http://http.us.debian.org/debian potato main contrib non-free
deb ftp://ftp.debian.org/debian potato main contrib non-free
### added line
deb-src http://http.us.debian.org/debian unstable main contrib non-free
###
#KDE
deb http://kde.tdyc.com/debian potato kde kde2 contrib rkrusty
deb http://spidermonkey.helixcode.com/distributions/debian unstable main
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>2) apt-get update
Here's the log:
kgb10:/tmp# apt-get update
0% [Working]
0% [Connecting to ftp.debian.org] [Connecting to http.us.debian.org]
[Connectin
0% [Connecting to ftp.debian.org (216.66.54.50)] [Waiting for file] [Waiting
fo
0% [Logging in] [Waiting for file] [Waiting for file] [Connecting to
spidermonk
0% [Logging in] [Waiting for file] [Waiting for file] [Waiting for file]
Hit http://kde.tdyc.com potato/kde Packages
Hit http://kde.tdyc.com potato/kde Release
Hit http://kde.tdyc.com potato/kde2 Packages
Hit http://kde.tdyc.com potato/kde2 Release
Hit http://kde.tdyc.com potato/contrib Packages
Hit http://kde.tdyc.com potato/contrib Release
26% [Logging in] [Waiting for file] [Waiting for file] [Waiting for file]
Hit http://kde.tdyc.com potato/rkrusty Packages
Hit http://kde.tdyc.com potato/rkrusty Release
34% [Logging in] [Waiting for file] [Waiting for file]
Get:1 http://http.us.debian.org unstable/main Sources [380kB]
0% [Logging in] [1 unstable/main 1081/380kB 0%] [Waiting for file]
0% [Logging in] [1 unstable/main 2529/380kB 0%] [Waiting for file]
Hit http://spidermonkey.helixcode.com unstable/main Packages
Ign http://spidermonkey.helixcode.com unstable/main Release
2% [Logging in] [1 unstable/main 8321/380kB 2%] 645B/s
9m36s
2% [Query] [1 unstable/main 8321/380kB 2%] 645B/s
9m36s
Get:2 ftp://ftp.debian.org potato/main Packages [821kB]
1% [2 potato/main 5792/821kB 0%] [1 unstable/main 8321/380kB 2%] 645B/s
30m40s
2% [2 potato/main 4344/821kB 0%] [1 unstable/main 27145/380kB 7%]
Err ftp://ftp.debian.org potato/main Packages
Data socket timed out
2% [1 unstable/main 27145/380kB 7%]
2% [Logging in] [1 unstable/main 27145/380kB 7%]
Hit ftp://ftp.debian.org potato/main Release
2% [1 unstable/main 27145/380kB 7%]
Hit ftp://ftp.debian.org potato/contrib Packages
2% [1 unstable/main 27145/380kB 7%]
Hit ftp://ftp.debian.org potato/contrib Release
2% [1 unstable/main 27145/380kB 7%]
Hit ftp://ftp.debian.org potato/non-free Packages
2% [1 unstable/main 27145/380kB 7%]
Hit ftp://ftp.debian.org potato/non-free Release
2% [1 unstable/main 27145/380kB 7%]
2% [1 unstable/main 27145/380kB 7%]
Err http://http.us.debian.org unstable/main Sources
Connection timed out
0% [Connecting to http.us.debian.org (63.209.15.252)]
0% [Waiting for file]
Ign http://http.us.debian.org unstable/main Release
0% [Waiting for file]
Get:3 http://http.us.debian.org unstable/contrib Sources [14.6kB]
0% [3 unstable/contrib 1083/14.6kB 7%]
1% [3 unstable/contrib 12667/14.6kB 86%]
Ign http://http.us.debian.org unstable/contrib Release
Get:4 http://http.us.debian.org unstable/non-free Sources [30.6kB]
1% [4 unstable/non-free 77/30.6kB 0%]
1% [3 unstable/contrib gzip 0] [4 unstable/non-free 77/30.6kB 0%]
1% [4 unstable/non-free 77/30.6kB 0%]
1% [4 unstable/non-free 2973/30.6kB 9%]
Err http://http.us.debian.org unstable/non-free Sources
Connection timed out
1% [Connecting to http.us.debian.org (63.209.15.252)]
1% [Waiting for file]
Ign http://http.us.debian.org unstable/non-free Release
1% [Working]
Fetched 14.6kB in 9m8s (27B/s)
Failed to fetch
ftp://ftp.debian.org/debian/dists/potato/main/binary-i386/Packages
Data socket timed out
Failed to fetch
http://http.us.debian.org/debian/dists/unstable/main/source/Sources
Connection timed out
Failed to fetch
http://http.us.debian.org/debian/dists/unstable/non-free/source/Sources
Connection timed out
Reading Package Lists... 0%
Reading Package Lists... 85%
Reading Package Lists... Done
Building Dependency Tree... 0%
Building Dependency Tree... 65%
Building Dependency Tree... Done
E: Some index files failed to download, they have been ignored, or old ones
used instead.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>3) cd to a working directory, apt-get source postgresql
Didn't expect this to go very far but, here's the log:
Script started on Tue Jun 27 21:14:44 2000
kgb10:/tmp# apt-get source postgresql
Reading Package Lists... Done
Building Dependency Tree... Done
E: Could not open file /var/state/apt/lists/
http.us.debian.org_debian_dists_unstable_main_source_Sources - open
(2 No such file or directory)
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Looks like I'm blocked at this point.
Also get a lot of connection time outs and other problems when I try to do a
helixcode update.
>4) cd postgresql-7.0.2; edit debian/rules to do any mods you want for
>configure.
>5) sudo ./debian/rules binary
>
>It'll make all the postgres debs for you in the working directory you
>cded to in 3.
>
>6) dpkg -i postg*7.0.2*deb
>
>This worked painlessly on my stormix upgraded to potato box.
>
>jpb
>--
>Joe Block <jpb@creol.ucf.edu>
>CREOL System Administrator
>
Reply to: