Re: Initdb failure with PG 7.1.3 on RH 7.1...

If I remember a previous discussion correctly, the
problem is not having a "bad" sed, but a
"too-up-to-date" one.  Someone got carried away with
escaping, which resulted in some "\n" combination(s)
appearing in regular expressions used by sed.  Not a
problem with most seds, which interpret that as just
"n", but GNU sed interprets "\n" as a newline
character.  A small change to the code should see you
clear.
--- Paul Stavrides <pstav123@adelie.net> wrote:
> Tom Lane wrote:
>
> >Paul Stavrides <pstav123@adelie.net> writes:
> >
> >>No,  looks like this is the cause.  My
> $prefix/share/global.bki is only
> >>17 bytes long and has only the header line:
> >>
> >
> >>    # PostgreSQL 7.1
> >>
> >
> >Ah-hah.  We've seen some prior reports of
> portability problems in the
> >sed commands used by src/backend/catalog/genbki.sh,
> which is the script
> >that builds those files.  But the last fix in that
> area was pre-7.1
> >release.  Maybe you have a broken sed or awk
> installed?
> >
> >            regards, tom lane
> >
> Tom,
>
>
> Hmmm, checked the sed and awk and they are up to
> date....  I'm not an
> expert, but it looks like the Makefile in
> ../src/backend/catalog/ isn't
> reporting sed's exit status up the chain.  So I lied
> about there being
> no build errors.... to whit:
>
>
> /usr/bin/ld -r -o SUBSYS.o catalog.o heap.o index.o
> indexing.o aclchk.o
> pg_aggregate.o pg_largeobject.o pg_operator.o
> pg_proc.o pg_type.o
> CPP='gcc -E' AWK='gawk' /bin/sh genbki.sh  -o global
>
> -I../../../src/include
> ../../../src/include/catalog/pg_database.h
> ../../../src/include/catalog/pg_variable.
> h ../../../src/include/catalog/pg_shadow.h
> ../../../src/include/catalog/pg_group.h
> ../../../src/include/catalog/pg_log.h
> --set-version=7.1.3
> sed: -e expression #9, char 25: Unterminated `s'
> command
> CPP='gcc -E' AWK='gawk' ....{snip}...
> set-version=7.1.3
> sed: -e expression #9, char 25: Unterminated `s'
> command
>
>
> The build still proceeds, even with these errors.
> They go by in a flash
> and the executable is still created.  I have to see
> what I did to make
> sed go nuts.
>
>
> Thanks for your time.  I will report what I find out
> to finish the thread...
>
> Cheers,
>
> -paul
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)


__________________________________________________
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com