Re: [HACKERS] urgent: pgsql 6.3 FreeBSD port update trouble, --with-tcl doesn't work

I just updated the ftp site such that there is a postgresql-6.3.1.tar.gz
file, which corrects alot of post-release bugs that cropped up, including
those you listed below...

Let me know if this help...it hasn't been officially released yet, but,
unless anyone comes up with an critical problems with it, that tar file
will be what is announced tomorrow morning...



On Sun, 22 Mar 1998, Andreas Klemm wrote:

> Hi !
>
> Please help, the FreeBSD port update to version 6.3 drives me to
> despair ;-)
>
> --with-tcl configure switch doesn't work to build libpgtcl
>
> I only get it to work if I set in the make environment
>
>     USE_TCL=true
>
> configure --with-tcl doesn't seem to set USE_TCL=true in
> src/Makefile.global, so
>     src/interfaces/Makefile,
> which includes
>     src/Makefile.global
> fails, since USE_TCL isn't set to true. Workaround was to explicitely
> set USE_TCL=true when starting the make.
>
> Another problem: on FreeBSD-current (and I think this is true on
> FreeBSD-2.2.x as well)
>
> The make install fails when running the initdb script.
>
> Adding template1 database to pg_database...
> Running: postgres -boot -C -F -D/usr/local/pgsql/data -Q template1 < /tmp/create
> .13645
>
> vacuuming template1
> creating public pg_user view
> loading pg_description
> *** Error code 1
>
> The Postgresql 6.2 version needed a patch so that this works
> --- bin/initdb/initdb.sh.orig   Wed Apr  2 07:09:13 1997
> +++ bin/initdb/initdb.sh        Wed Apr  2 07:09:33 1997
> @@ -344,6 +344,5 @@
>
>  if [ $debug -eq 0 ]; then
>      echo "vacuuming template1"
> -    echo "vacuum" | postgres -F -Q -D$PGDATA template1 2>&1 > /dev/null |\
> -        grep -v "^DEBUG:"
> +    echo "vacuum" | postgres -o /dev/null -F -Q -D$PGDATA template1 > /dev/null
>
>  fi
>
> I enhanced this patch and now use
>     "-o /dev/null"
> and avoid
>     "2>&1"
>
> several lines below where similar commands can be found, but this
> doesn't solve the problem.
>
> --- bin/initdb/initdb.sh.orig   Sun Mar 22 12:47:51 1998
> +++ bin/initdb/initdb.sh        Sun Mar 22 13:06:36 1998
> @@ -348,8 +348,7 @@
>
>  # If the COPY is first, the VACUUM generates an error, so we vacuum first
>  echo "vacuuming template1"
> -echo "vacuum" | postgres -F -Q -D$PGDATA template1 2>&1 > /dev/null |\
> -       grep -v "^DEBUG:"
> +echo "vacuum" | postgres -o /dev/null -F -Q -D$PGDATA template1 > /dev/null
>
>  echo "COPY pg_shadow TO '$PGDATA/pg_pwd' USING DELIMITERS '\\t'" |\
>         postgres -F -Q -D$PGDATA template1 2>&1 > /dev/null |\
> @@ -383,6 +382,6 @@
>  echo "loading pg_description"
>  echo "copy pg_description from '$TEMPLATE_DESCR'" | postgres -F -Q -D$PGDATA te
> mplate1 > /dev/null
>  echo "copy pg_description from '$GLOBAL_DESCR'" | postgres -F -Q -D$PGDATA temp
> late1 > /dev/null
> -echo "vacuum analyze" | postgres -F -Q -D$PGDATA template1 2>&1 > /dev/null |\
> +echo "vacuum analyze" | postgres -o /dev/null -F -Q -D$PGDATA template1 > /dev/
> null |\
>         grep -v "^DEBUG:"
>
> Any help appreciated !
>
> Reply-To set, since I haven't subscribed to your list.
>
> --
> Andreas Klemm   http://www.FreeBSD.ORG/~andreas
> powered by ,,symmetric multiprocessor FreeBSD''
>

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org