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 <[EMAIL PROTECTED]> >CREOL System Administrator >
