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(at)adelie(dot)net> wrote:
> Tom Lane wrote:
>
> >Paul Stavrides <pstav123(at)adelie(dot)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(at)postgresql(dot)org)

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