Re: INITDB error

hi,

i finally got initdb with postgresql 7.4.1 on cygwin/winXP working for me:

i applied dos2unix (see: http://www.bastet.com/software/software.html, or:
http://www.bastet.com/software/UDDU.ZIP) on the file:

/usr/local/pgsql/share/postgres.description

without this there was always an error:
...
loading pg_description... ERROR: end-of-copy marker does not match
previous newline style
CONTEXT: COPY tmp_pg_description, line 1542: ""
...

jean-pierre

At 13:00 15.12.2003 -0500, Mike Leahy wrote:
>All,
>
>I think I figured out at least what I was doing wrong. I wiped my Cygwin
>folder and started from scratch (again), then reinstalled with the
>setup.exe. The only thing I did different this time was select the "UNIX"
>text style option in the installer, and the initdb script works. I've
>always been using DOS style before, and it never caused a problem.
>
>In my case, it wasn't a big deal to reinstall everything, but perhaps I
>could have just changed one of the environment variables - I'm guessing
>MAKE_MODE might be it, but I really have no clue and I don't see anything in
>the installed docs about switching from dos to unix.
>
>Mike
>
>-----Original Message-----
>From: pgsql-cygwin-owner(at)postgresql(dot)org
>[mailto:pgsql-cygwin-owner(at)postgresql(dot)org] On Behalf Of Mike Leahy
>Sent: December 13, 2003 3:24 PM
>To: pgsql-cygwin(at)postgresql(dot)org
>Cc: jpraz(at)dplanet(dot)ch
>Subject: Re: [CYGWIN] INITDB error
>
>All,
>
>I'm back to the same problem as well. Just to be sure I reinstalled
>everything to do with Cygwin (again), and now I get the same error. I can't
>
>even guess why it worked the first try, since I haven't done anything
>different this second time. Is there something we should be looking out
>for?
>
>Mike
>
>(sorry if I sent this twice)
>
>
>-----Original Message-----
>From: pgsql-cygwin-owner(at)postgresql(dot)org [mailto:pgsql-cygwin-
>owner(at)postgresql(dot)org] On Behalf Of Jean-Pierre Praz
>Sent: December 10, 2003 7:53 PM
>To: pgsql-cygwin(at)postgresql(dot)org
>Subject: Re: [CYGWIN] INITDB error
>
>hi
>
>in my installation on cygwin/winXP there is exactly the same error. i
>updated cygwin before installing postgres 7.4.1, so i don't know what more
>i could update there. before i ran postgres 7.3.x without any troubles.
>
>does anyone have an idea how to solve this?
>any help or ideas are welcome.
>
>thanks,
>jean-pierre
>
>
>
>
>Running in noclean mode. Mistakes will not be cleaned up.
>The files belonging to this database system will be owned by user "...".
>This user must also own the server process.
>
>The database cluster will be initialized with locale C.
>
>creating directory
>/usr/src/postgresql-7.4-1/src/test/regress/./tmp_check/data... ok
>creating directory
>/usr/src/postgresql-7.4-1/src/test/regress/./tmp_check/data/base... ok
>creating directory
>/usr/src/postgresql-7.4-1/src/test/regress/./tmp_check/data/global... ok
>creating directory
>/usr/src/postgresql-7.4-1/src/test/regress/./tmp_check/data/pg_xlog... ok
>creating directory
>/usr/src/postgresql-7.4-1/src/test/regress/./tmp_check/data/pg_clog... ok
>selecting default max_connections... 100
>selecting default shared_buffers... 1000
>creating configuration files... ok
>creating template1 database in
>/usr/src/postgresql-7.4-1/src/test/regress/./tmp_check/data/base/1... ok
>initializing pg_shadow... ok
>enabling unlimited row size for system tables... ok
>initializing pg_depend... ok
>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
>initdb: data directory
>"/usr/src/postgresql-7.4-1/src/test/regress/./tmp_check/data" not removed
>at user's request
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>----------------------------------------
>This mail sent through www.mywaterloo.ca
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)