pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
INITDB-error - end-of-copy marker error
6+ messages / 4 participants
[nested] [flat]

* INITDB-error - end-of-copy marker error
@ 2004-04-22 15:16 JC Jan Christensen <jan.christensen@riva-systems.dk>
  2004-04-22 16:56 ` Re: INITDB-error - end-of-copy marker error Jason Tishler <jason@tishler.net>
  2004-04-29 20:00 ` Re: [ADMIN] INITDB-error - end-of-copy marker error Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 6+ messages in thread

From: JC Jan Christensen @ 2004-04-22 15:16 UTC (permalink / raw)
  To: 'jason@tishler.net' <jason@tishler.net>; 'cygwin@cygwin.com' <cygwin@cygwin.com>; 'pgsql-cygwin@postgresql.org' <pgsql-cygwin@postgresql.org>; pgsql-admin; 'pgsql-bugs@postgresql.org' <pgsql-bugs@postgresql.org>


 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

  
     



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: INITDB-error - end-of-copy marker error
  2004-04-22 15:16 INITDB-error - end-of-copy marker error JC Jan Christensen <jan.christensen@riva-systems.dk>
@ 2004-04-22 16:56 ` Jason Tishler <jason@tishler.net>
  2004-04-22 17:05   ` Re: INITDB-error - end-of-copy marker error Christopher Faylor <cgf-no-personal-reply-please@cygwin.com>
  1 sibling, 1 reply; 6+ messages in thread

From: Jason Tishler @ 2004-04-22 16:56 UTC (permalink / raw)
  To: JC Jan Christensen <jan.christensen@riva-systems.dk>; +Cc: 'cygwin@cygwin.com' <cygwin@cygwin.com>; 'pgsql-cygwin@postgresql.org' <pgsql-cygwin@postgresql.org>

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



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: INITDB-error - end-of-copy marker error
  2004-04-22 15:16 INITDB-error - end-of-copy marker error JC Jan Christensen <jan.christensen@riva-systems.dk>
  2004-04-22 16:56 ` Re: INITDB-error - end-of-copy marker error Jason Tishler <jason@tishler.net>
@ 2004-04-22 17:05   ` Christopher Faylor <cgf-no-personal-reply-please@cygwin.com>
  2004-04-23 13:11     ` Re: INITDB-error - end-of-copy marker error Jason Tishler <jason@tishler.net>
  0 siblings, 1 reply; 6+ messages in thread

From: Christopher Faylor @ 2004-04-22 17:05 UTC (permalink / raw)
  To: cygwin@cygwin.com; +Cc: JC Jan Christensen <jan.christensen@riva-systems.dk>; 'pgsql-cygwin@postgresql.org' <pgsql-cygwin@postgresql.org>

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@sourceware.org
Cygwin Co-Project Leader				aaaspam@duffek.com
TimeSys, Inc.



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: INITDB-error - end-of-copy marker error
  2004-04-22 15:16 INITDB-error - end-of-copy marker error JC Jan Christensen <jan.christensen@riva-systems.dk>
  2004-04-22 16:56 ` Re: INITDB-error - end-of-copy marker error Jason Tishler <jason@tishler.net>
  2004-04-22 17:05   ` Re: INITDB-error - end-of-copy marker error Christopher Faylor <cgf-no-personal-reply-please@cygwin.com>
@ 2004-04-23 13:11     ` Jason Tishler <jason@tishler.net>
  0 siblings, 0 replies; 6+ messages in thread

From: Jason Tishler @ 2004-04-23 13:11 UTC (permalink / raw)
  To: cygwin@cygwin.com, JC Jan Christensen <jan.christensen@riva-systems.dk>; 'pgsql-cygwin@postgresql.org' <pgsql-cygwin@postgresql.org>

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



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [ADMIN] INITDB-error - end-of-copy marker error
  2004-04-22 15:16 INITDB-error - end-of-copy marker error JC Jan Christensen <jan.christensen@riva-systems.dk>
@ 2004-04-29 20:00 ` Tom Lane <tgl@sss.pgh.pa.us>
  2004-06-11 15:24   ` Re: [ADMIN] INITDB-error - end-of-copy marker error Jason Tishler <jason@tishler.net>
  1 sibling, 1 reply; 6+ messages in thread

From: Tom Lane @ 2004-04-29 20:00 UTC (permalink / raw)
  To: JC Jan Christensen <jan.christensen@riva-systems.dk>; +Cc: 'jason@tishler.net' <jason@tishler.net>; 'pgsql-cygwin@postgresql.org' <pgsql-cygwin@postgresql.org>; 'pgsql-bugs@postgresql.org' <pgsql-bugs@postgresql.org>

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

inline patch 1: initdb.sh (+1/-5 lines) download inline-1.patchIndex: 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;
^ permalink raw reply [nested|flat] 6+ messages in thread

* Re: [ADMIN] INITDB-error - end-of-copy marker error
  2004-04-22 15:16 INITDB-error - end-of-copy marker error JC Jan Christensen <jan.christensen@riva-systems.dk>
  2004-04-29 20:00 ` Re: [ADMIN] INITDB-error - end-of-copy marker error Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-06-11 15:24   ` Jason Tishler <jason@tishler.net>
  0 siblings, 0 replies; 6+ messages in thread

From: Jason Tishler @ 2004-06-11 15:24 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: JC Jan Christensen <jan.christensen@riva-systems.dk>; 'pgsql-cygwin@postgresql.org' <pgsql-cygwin@postgresql.org>

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



^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2004-06-11 15:24 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-22 15:16 INITDB-error - end-of-copy marker error JC Jan Christensen <jan.christensen@riva-systems.dk>
2004-04-22 16:56 ` Jason Tishler <jason@tishler.net>
2004-04-22 17:05   ` Christopher Faylor <cgf-no-personal-reply-please@cygwin.com>
2004-04-23 13:11     ` Jason Tishler <jason@tishler.net>
2004-04-29 20:00 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-06-11 15:24   ` Jason Tishler <jason@tishler.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox