interix port running...
От | Merlin Moncure |
---|---|
Тема | interix port running... |
Дата | |
Msg-id | 303E00EBDD07B943924382E153890E5434AA78@cuthbert.rcsinc.local обсуждение исходный текст |
Список | pgsql-hackers-win32 |
Merlin.Moncure=# select version(); version --------------------------------------------------------------------- PostgreSQL 7.4.1 on i386-pc-interix3, compiled by GCC gcc (GCC) 3.3 (1 row) Merlin.Moncure=# I never could get initdb to work, so I had to borrow initdb from the cygwin compiled version. Also, there were a few quirky problems with the compile/build I had to work around. Since I'm new to Unix, this was a fun learning exercise. I've been administrating postgresql servers for several years now, but have never bothered to learn unix much beyond running initdb :). First problem: no config.guess I downloaded postgresql 7.2.2 port to interix and copied all the interix specific stuff...this fixed it. Second problem: configure fails to write pg_config.h. Actually, configure fails to write any *config.h on my machine for some reason. This appears to be somewhat uncommon, but it was a huge PITA (compiling anything is a battle). I manually copied all defines form config.log to pg_config.h. I wasted a lot of time initially until I realized I could do this. Third problem: no sync() Hacked around it with #define sync() in interix3.h...ignoring this one for now. Fourth problem: Make install fails on...can't find ascii_and_mic.so. Couldn't figure this one out so just did gmake -C src/bin install this went through ok. Fifth problem: Command line tools won't work...just used cygwins...mingw compiled tools probably will work ok to. Final thoughts...some (very) rough comparisons with the cygwin version via pgbench show that the interix version is about 10% slower. This is really interesting and a little disappointing. However, everything appears to function ok (haven't run regression yet). I think the current efforts on the win32 port are still quite justified because of lower installation overhead. Also, the freedom to execute native API calls leaves a lot of room for optimization as the win32 API is quite sophisticated, if somewhat esoteric, in this regard. Can anybody suggest a good command line debugger/profiler?
В списке pgsql-hackers-win32 по дате отправления: