Postgresql 7.02 and Debian
Hello the list: Anybody in this subject category? Last used 6.5.3 in SuSE, so new to both 7.02 and debian. Debian not in the list of supported platforms at Postgresql web site. Installation seemed to be okay, but maybe directories are different??? Specifically: su postgres /etc/rc.d/init.d/postgresql start -i responds: /etc/rc.d/init.d/functions: No such file or directory Appreciate your guidance Bill Barnes
Re: Postgresql 7.02 and Debian
On Tue, Jun 27, 2000 at 12:02:17PM -0400, Bill Barnes wrote: > Hello the list: > > Anybody in this subject category? > > Last used 6.5.3 in SuSE, so new to both 7.02 and debian. Debian not in the > list of supported platforms at Postgresql web site. > Installation seemed to be okay, but maybe directories are different??? > Specifically: > su postgres > /etc/rc.d/init.d/postgresql start -i > responds: > /etc/rc.d/init.d/functions: No such file or directory Try "/etc/init.d/postgresql start" -- Nathan Norman "Eschew Obfuscation" Network Engineer GPG Key ID 1024D/51F98BB7http://home.midco.net/~nnorman/ Key fingerprint = C5F4 A147 416C E0BF AB73 8BEF F0C8 255C 51F9 8BB7 pgplUC7b0DwyC.pgp Description: PGP signature
Re: Postgresql 7.02 and Debian
On Tue, Jun 27, 2000 at 12:02:17PM -0400, Bill Barnes wrote: > Last used 6.5.3 in SuSE, so new to both 7.02 and debian. Debian not in the > list of supported platforms at Postgresql web site. Debian GNU/Linux works fine, and there's a .deb of PostgreSQL available in Debian. 6.x is in potato, but the 7.0 version in woody works for me. Others have had problems. Make sure you back up all your data _before_ doing any upgrades; the automatic upgrades have failed miserably for me more than once. That said, Oliver Elphick, the package maintainer, does a laudable job (in my view). > Installation seemed to be okay, but maybe directories are different??? Yes. Check the README.Debian file that comes with your package (should be under /usr/share/doc or /usr/doc, depending on which version of Debian you're using). It works transparently, though. One word of warning: if you go with the version from woody, and you want to use PHP, you may have to do some compiling from source. -- Andrew Sullivan Computer Services <[EMAIL PROTECTED]>Burlington Public Library +1 905 639 3611 x158 2331 New Street Burlington, Ontario, Canada L7R 1J4
Re: Postgresql 7.02 and Debian
Bill Barnes wrote: > Last used 6.5.3 in SuSE, so new to both 7.02 and debian. Debian not in the > list of supported platforms at Postgresql web site. > Installation seemed to be okay, but maybe directories are different??? > Specifically: > su postgres > /etc/rc.d/init.d/postgresql start -i > responds: > /etc/rc.d/init.d/functions: No such file or directory 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. Briefly: 1) add deb-src http://http.us.debian.org/debian unstable main contrib non-free to your /etc/apt/sources.list 2) apt-get update 3) cd to a working directory, apt-get source postgresql 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 Social graces are the packet headers of everyday life.
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 s
Re: Postgresql 7.02 and Debian
Bill Barnes <[EMAIL PROTECTED]> writes:
> 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
apt could not get the new list from the server so you can't do
anything with apt for this server. First get a *complete* list
("apt-get update" with no errors) and then everything else works fine.
--
Until the next mail...,
Stefan.
Re: Postgresql 7.02 and Debian
Bill Barnes wrote: > > 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: [ snip ok sources.list] > >2) apt-get update > Here's the log: > kgb10:/tmp# apt-get update [ snip ] > http://http.us.debian.org/debian/dists/unstable/non-free/source/Sources > Connection timed out Try apt-get update again. It looks like you had network congestion when you tried before. Or you can just use ftp and go to ftp.us.debian.org and manually grab the postgresql source files (the .diff.gz, .dsc & .orig.tar.gz) and use dbuild to extract them. jpb -- Joe Block <[EMAIL PROTECTED]> CREOL System Administrator Social graces are the packet headers of everyday life.
RE: Postgresql 7.02 and Debian
>= Original Message From jpb <[EMAIL PROTECTED]> =
>
>Try apt-get update again. It looks like you had network congestion when
>you tried before. Or you can just use ftp and go to ftp.us.debian.org
>and manually grab the postgresql source files (the .diff.gz, .dsc &
>.orig.tar.gz) and use dbuild to extract them.
>
>jpb
Finally got a clean run. Had to do it in the wee hours.
Fetched postgresql okay.
Missing files in the compile.
The log follows. Snipped out all the good makes. This was a second run.
>>>
Script started on Fri Jun 30 04:54:05 2000
kgb10:/home/billb/postgresql-7.0.2# ./debian/rules binary
cd src/interfaces/perl5 && \
POSTGRES_HOME=/home/billb/postgresql-7.0.2/debian/tmp/usr/lib/postgresql \
INSTALLDIRS=perl
INSTALLMAN1DIR=/home/billb/postgresql-7.0.2/debian/libpgperl/usr/share/man/man
1
INSTALLMAN3DIR=/home/billb/postgresql-7.0.2/debian/libpgperl/usr/share/man/man
3
INSTALLPRIVLIB=/home/billb/postgresql-7.0.2/debian/libpgperl/usr/lib/perl5
INSTALLARCHLIB=/home/billb/postgresql-7.0.2/debian/libpgperl`/usr/bin/perl
-MConfig -e 'print $Config{installarchlib}'` \
/usr/bin/perl Makefile.PL && \
touch perl-config
Unrecognized argument in LIBS ignored: '-fpic'
Writing Makefile for Pg
dh_testdir
dh_installdirs
echo doctmp is
/home/billb/postgresql-7.0.2/debian/postgresql-doc/usr/share/doc/postgresql-do
c
doctmp is
/home/billb/postgresql-7.0.2/debian/postgresql-doc/usr/share/doc/postgresql-do
c
cd src && make all 2>&1 |\
tee -a /tmp/postgresql.JMYmQP
make -C libpgtcl all
make[3]: Entering directory
`/home/billb/postgresql-7.0.2/src/interfaces/libpgtcl'
gcc -I../../include -I../../backend -O2 -g -g3 -Wall -Wmissing-prototypes
-Wmissing-declarations -I../../backend -I../../include
-I../../interfaces/libpq -fpic -c -o pgtcl.o pgtcl.c
In file included from pgtcl.c:19:
libpgtcl.h:19: tcl.h: No such file or directory
In file included from pgtcl.c:20:
pgtclCmds.h:17: tcl.h: No such file or directory
make[3]: *** [pgtcl.o] Error 1
make[3]: Leaving directory
`/home/billb/postgresql-7.0.2/src/interfaces/libpgtcl'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/home/billb/postgresql-7.0.2/src/interfaces'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/home/billb/postgresql-7.0.2/src'
make: *** [build-stamp] Error 1
kgb10:/home/billb/postgresql-7.0.2# exit
Script done on Fri Jun 30 04:54:32 2000
Hope that I didn't cut out something significant.
Very much appreciate the feedback. Looking forward to the day I will be in a
position to offer support instead of questions.
Regards,
Bill Barnes
>--
>Joe Block <[EMAIL PROTECTED]>
>CREOL System Administrator
>
>Social graces are the packet headers of everyday life.
Re: Postgresql 7.02 and Debian
On Fri, Jun 30, 2000 at 07:06:58AM -0400, Bill Barnes wrote > >= Original Message From jpb <[EMAIL PROTECTED]> = > > > >Try apt-get update again. It looks like you had network congestion when > >you tried before. Or you can just use ftp and go to ftp.us.debian.org > >and manually grab the postgresql source files (the .diff.gz, .dsc & > >.orig.tar.gz) and use dbuild to extract them. > > > >jpb > > Finally got a clean run. Had to do it in the wee hours. > Fetched postgresql okay. > > Missing files in the compile. > The log follows. Snipped out all the good makes. This was a second run. > > >>> > Script started on Fri Jun 30 04:54:05 2000 > kgb10:/home/billb/postgresql-7.0.2# ./debian/rules binary >>< > make -C libpgtcl all > make[3]: Entering directory > `/home/billb/postgresql-7.0.2/src/interfaces/libpgtcl' > gcc -I../../include -I../../backend -O2 -g -g3 -Wall -Wmissing-prototypes > -Wmissing-declarations -I../../backend -I../../include > -I../../interfaces/libpq -fpic -c -o pgtcl.o pgtcl.c > In file included from pgtcl.c:19: > libpgtcl.h:19: tcl.h: No such file or directory > In file included from pgtcl.c:20: > pgtclCmds.h:17: tcl.h: No such file or directory > make[3]: *** [pgtcl.o] Error 1 > make[3]: Leaving directory > `/home/billb/postgresql-7.0.2/src/interfaces/libpgtcl' > make[2]: *** [all] Error 2 > make[2]: Leaving directory `/home/billb/postgresql-7.0.2/src/interfaces' > make[1]: *** [all] Error 2 > make[1]: Leaving directory `/home/billb/postgresql-7.0.2/src' > make: *** [build-stamp] Error 1 > kgb10:/home/billb/postgresql-7.0.2# exit $ zgrep '/tcl\.h' /cognac/linux/debian/dists/potato/Contents-i386.gz usr/include/tcl.h devel/tcl8.0-dev,devel/tcl8.2-dev,devel/tcl8.0-ja-dev usr/include/tcl8.0-ja-int/generic/tcl.h devel/tcl8.0-ja-dev usr/include/tcl8.0/generic/tcl.hdevel/tcl8.0-dev usr/include/tcl8.2/generic/tcl.hdevel/tcl8.2-dev usr/share/doc/selfhtml/html/tcl.htm doc/selfhtml Looks like you need to install tcl8.2-dev (or tcl8.0-dev). John P. -- [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.mdt.net.au/~john Debian Linux admin & support:technical services
Re: Postgresql 7.02 and Debian
Bill Barnes <[EMAIL PROTECTED]> writes: > Missing files in the compile. > The log follows. Snipped out all the good makes. This was a second run. If you got postgresql with apt-get source... then there are 3 files: *.orig.tar.gz *.diff.gz *.dsc The last one, postgresql_7.0.2-2.dsc, contains some description in ASCII-text. Try a "cat postgresql_7.0.2-2.dsc" and you will see some text which contains a line like Build-Depends: libncurses5-dev... This line shows you what you'll need to compile this package. Just make a apt-get install with all packages listet in the above line and then everything will compile fine. BTW: In the Build-Depends tcl8.0-dev and tk8.0-dev are listed -- the newer versions 8.2 will also do. -- Until the next mail..., Stefan.
Re: Postgresql 7.02 and Debian
Stefan Nobis wrote: >BTW: In the Build-Depends tcl8.0-dev and tk8.0-dev are listed -- the >newer versions 8.2 will also do. Actually, postgresql specifically requires 8.0, because there are problems with multibyte encoding and later versions of tcl (problem in postgresql not tcl) -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "Seeing then that we have a great high priest who has gone into the heavens, Jesus the Son of God, let us hold firmly to the faith we profess. For we do not have a high priest who is unable to sympathize with our weaknesses, but we have one who was tempted in every way, just as we are-yet was without sin." Hebrews 4:14,15
Re: Postgresql 7.02 and Debian
Stefan Nobis <[EMAIL PROTECTED]> writes: > Bill Barnes <[EMAIL PROTECTED]> writes: > > > Missing files in the compile. > > The log follows. Snipped out all the good makes. This was a second run. > > If you got postgresql with apt-get source... then there are 3 files: > > *.orig.tar.gz > *.diff.gz > *.dsc > > The last one, postgresql_7.0.2-2.dsc, contains some description in > ASCII-text. Try a "cat postgresql_7.0.2-2.dsc" and you will see some > text which contains a line like > > Build-Depends: libncurses5-dev... > > This line shows you what you'll need to compile this package. Just > make a apt-get install with all packages listet in the above line and > then everything will compile fine. > > BTW: In the Build-Depends tcl8.0-dev and tk8.0-dev are listed -- the > newer versions 8.2 will also do. > > -- > Until the next mail..., > Stefan. > I tried to build postgresql_7.0.2-2 on my PPC, but this fails. There should be some kind of patch, shouldn't it? Andre
Re: Postgresql 7.02 and Debian
Andre Berger wrote: >I tried to build postgresql_7.0.2-2 on my PPC, but this fails. There >should be some kind of patch, shouldn't it? There is no special patch for PPC builds. Mail me the failing section of your build log and I'll take a look. -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "Seeing then that we have a great high priest who has gone into the heavens, Jesus the Son of God, let us hold firmly to the faith we profess. For we do not have a high priest who is unable to sympathize with our weaknesses, but we have one who was tempted in every way, just as we are-yet was without sin." Hebrews 4:14,15
RE: Postgresql 7.02 and Debian
Back for more, but this should be easy. At last postgresql 7.02 starts and runs after a boot, and I have access using psql. There are 2 problems remaining: pgaccess connects thru TCP/IP and expects to connect at port 5432. I will probably find that true also with gASQL and bonobo. Since this is my first serious effort in Debian I will certainly appreciate someone walking me thru these changes. Thanks very much, Bill Barnes
Re: Postgresql 7.02 and Debian
On Mon, Jul 03, 2000 at 03:20:58AM -0400, Bill Barnes wrote: > There are 2 problems remaining: > pgaccess connects thru TCP/IP and expects to connect at port 5432. > I will probably find that true also with gASQL and bonobo. Someone (it might have been Oliver Elphick) replied to a similar problem about pgaccess not so long ago on this list that it will work if you leave blank the "host" (take away "localhost") and "port" fields in pgaccess. I have tested it and it works on postgresql 6.5. I do not know about gASQL and bonobo. Johann -- J.H. Spies, Hugenotestraat 29, Posbus 80, Franschhoek, 7690, South Africa Tel/Faks 021-876-2337 Sel/Cell 082 898 1528(Johann) 082 255 2388(Hester) "I will say of the LORD, He is my refuge and my fortress; my God, in him will I trust." Psalms 91:2
