Thread: PostgreSQL7.0 bug? "make install" doesN'T run at all

PostgreSQL7.0 bug? "make install" doesN'T run at all

From
"planx plnetx"
Date:
OK, I think that the problem of postgres running session instability
it's due to a conflict with precedent postgres6.5.x rpms...
well, now I've purged those rpms from my mandrake with GnoRPM and
finally redo a make install (after making sources, of course!)
but they dont copy initdb in my /usr/bin (mandrake use usr instead of
usr/local) then i link into /usr/bin/ all /usr/pgsql/bin which the
make install create...
but if I run initdb it tell me:
***************
This user will own all the data files and must also own the server process.

Creating database system directory /home/SQL/sdp
Creating database system directory /home/SQL/sdp/base
Creating database XLOG directory /home/SQL/sdp/pg_xlog
Creating template database in /home/SQL/sdp/base/template1
/usr/pgsql/bin/initdb: line 442:   992 Broken pipe             cat
"$TEMPLATE"
       993                       | sed -e "s/PGUID/$POSTGRES_SUPERUSERID/g"
       994 Segmentation fault      | "$PGPATH"/postgres $FIRSTRUN template1

initdb failed.
Removing /home/SQL/sdp.
Removing temp file /tmp/initdb.973.
*********************

and if I utilize a working database directory previously created: the
postmaster start but if I do createdb or createuser it give me the FATAL 1:
cannot create mydatabase//base/template1/pg_internal.init

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com


Re: PostgreSQL7.0 bug? "make install" doesN'T run at all

From
Peter Eisentraut
Date:
{bug reports please to pgsql-bugs}

planx plnetx writes:

> but if I run initdb it tell me:
> ***************
> This user will own all the data files and must also own the server process.
>
> Creating database system directory /home/SQL/sdp
> Creating database system directory /home/SQL/sdp/base
> Creating database XLOG directory /home/SQL/sdp/pg_xlog
> Creating template database in /home/SQL/sdp/base/template1
> /usr/pgsql/bin/initdb: line 442:   992 Broken pipe             cat
> "$TEMPLATE"
>        993                       | sed -e "s/PGUID/$POSTGRES_SUPERUSERID/g"
>        994 Segmentation fault      | "$PGPATH"/postgres $FIRSTRUN template1

It would be good to know which program segfaulted. If you have a core file
then run `file core' to see. If it happens to be `postgres', then a
backtrace would also be nice. (configure with --enable-debug, recompile,
re-run initdb, then `gdb /path/to/postgres /path/to/core'. Thanks.

>
> initdb failed.
> Removing /home/SQL/sdp.
> Removing temp file /tmp/initdb.973.
> *********************


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden