Обсуждение: 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.christensen@riva-systems.dk

 I hope to hear from you.

 Best regards

 Jan Christensen

JC Jan Christensen <jan.christensen@riva-systems.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.christensen@riva-systems.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