pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedINITDB-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>
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 16:56 Jason Tishler <jason@tishler.net>
parent: JC Jan Christensen <jan.christensen@riva-systems.dk>
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 17:05 Christopher Faylor <cgf-no-personal-reply-please@cygwin.com>
parent: 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-23 13:11 Jason Tishler <jason@tishler.net>
parent: Christopher Faylor <cgf-no-personal-reply-please@cygwin.com>
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-29 20:00 Tom Lane <tgl@sss.pgh.pa.us>
parent: JC Jan Christensen <jan.christensen@riva-systems.dk>
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.patch
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;
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [ADMIN] INITDB-error - end-of-copy marker error
@ 2004-06-11 15:24 Jason Tishler <jason@tishler.net>
parent: Tom Lane <tgl@sss.pgh.pa.us>
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