Re: INITDB-error - end-of-copy marker error

Dear Sirs

I have a problem with INITDB !!!!

After having compiled postgresql 7.4.2 against
cygserver ( ./configure, make, make install )
I get the following error-message from INITDB :

creating system views....ok
loading pg_description...ERROR: end-of-copy marker does
not match previous newline style
CONTEXT: COPY tmp_pg_description, line 1542: ""
initdb: failed

I use Cygwin version 1.5.9-1

What is the problem, and how does I solve this problem ?????

My E-mail-address is: jan(dot)christensen(at)riva-systems(dot)dk

I hope to hear from you.

Best regards

Jan Christensen

On Thu, Apr 22, 2004 at 05:16:42PM +0200, JC Jan Christensen wrote:
> I have a problem with INITDB !!!!

Works for me -- see below...

> I get the following error-message from INITDB :
>
> creating system views....ok
> loading pg_description...ERROR: end-of-copy marker does
> not match previous newline style
> CONTEXT: COPY tmp_pg_description, line 1542: ""
> initdb: failed
>
> I use Cygwin version 1.5.9-1
>
> What is the problem, and how does I solve this problem ?????

Try a recent snapshot -- it will work much better than 1.5.9-1.

Note I will release Cygwin PostgreSQL 7.4.2, built against cygserver,
after Cygwin 1.5.10 is released.

BTW, IMO, there was no reason to cross post to four different mailing
lists regarding this problem.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

On Thu, Apr 22, 2004 at 12:56:39PM -0400, Jason Tishler wrote:
>On Thu, Apr 22, 2004 at 05:16:42PM +0200, JC Jan Christensen wrote:
>> I have a problem with INITDB !!!!
>
>Works for me -- see below...
>
>> I get the following error-message from INITDB :
>>
>> creating system views....ok
>> loading pg_description...ERROR: end-of-copy marker does
>> not match previous newline style
>> CONTEXT: COPY tmp_pg_description, line 1542: ""
>> initdb: failed
>>
>> I use Cygwin version 1.5.9-1
>>
>> What is the problem, and how does I solve this problem ?????
>
>Try a recent snapshot -- it will work much better than 1.5.9-1.

What has changed in snapshots that would make this work better?
--
Christopher Faylor spammer? -> aaaspam(at)sourceware(dot)org
Cygwin Co-Project Leader aaaspam(at)duffek(dot)com
TimeSys, Inc.

Chris,

On Thu, Apr 22, 2004 at 01:05:13PM -0400, Christopher Faylor wrote:
> On Thu, Apr 22, 2004 at 12:56:39PM -0400, Jason Tishler wrote:
> >Try a recent snapshot -- it will work much better than 1.5.9-1.
>
> What has changed in snapshots that would make this work better?

See the following:

http://archives.postgresql.org/pgsql-cygwin/2004-04/msg00033.php

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

JC Jan Christensen <jan(dot)christensen(at)riva-systems(dot)dk> writes:
> creating system views....ok
> loading pg_description...ERROR: end-of-copy marker does
> not match previous newline style
> CONTEXT: COPY tmp_pg_description, line 1542: ""
> initdb: failed

I was about to say I thought we'd fixed that in 7.4.2 ... but on
inspection it seems only one of the two uses of COPY got fixed :-(.
Try the attached patch.

regards, tom lane

Index: initdb.sh
===================================================================
RCS file: /cvsroot/pgsql-server/src/bin/initdb/initdb.sh,v
retrieving revision 1.204.2.1
retrieving revision 1.204.2.2
diff -c -r1.204.2.1 -r1.204.2.2
*** initdb.sh 14 Jan 2004 03:47:12 -0000 1.204.2.1
--- initdb.sh 29 Apr 2004 19:56:35 -0000 1.204.2.2
***************
*** 1043,1053 ****
classname name, \
objsubid int4, \
description text) WITHOUT OIDS;
! COPY tmp_pg_description FROM STDIN;
! EOF
! cat "$POSTGRES_DESCR"
! cat <<EOF
! \.
INSERT INTO pg_description SELECT \
t.objoid, c.oid, t.objsubid, t.description \
FROM tmp_pg_description t, pg_class c WHERE c.relname = t.classname;
--- 1043,1049 ----
classname name, \
objsubid int4, \
description text) WITHOUT OIDS;
! COPY tmp_pg_description FROM '$POSTGRES_DESCR';
INSERT INTO pg_description SELECT \
t.objoid, c.oid, t.objsubid, t.description \
FROM tmp_pg_description t, pg_class c WHERE c.relname = t.classname;

Tom,

On Thu, Apr 29, 2004 at 04:00:27PM -0400, Tom Lane wrote:
> JC Jan Christensen <jan(dot)christensen(at)riva-systems(dot)dk> writes:
> > creating system views....ok
> > loading pg_description...ERROR: end-of-copy marker does
> > not match previous newline style
> > CONTEXT: COPY tmp_pg_description, line 1542: ""
> > initdb: failed
>
> I was about to say I thought we'd fixed that in 7.4.2 ... but on
> inspection it seems only one of the two uses of COPY got fixed :-(.
> Try the attached patch.

I did not experience the above problem even without your patch. My WAG
is that the user has configured their Cygwin setup to use text instead
of binary mode mounts.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6