Re: postgres on windows with minimal cygwin

I am doing the exact same thing, in fact there is a Windows console
program floating around that Igor Georgiev started and I did some work
on, if you look at the archives, you may find it.

One thing you may want to do is inspect the registry setting for the
cygwin directory. Make sure it is what you think it should be.

Second, when I was creating my install, I had a full blown cygwin
directory and a smaller postgres version. If you run the ipc-daemon
program while the registry settings are set for the main cygwin
directory, it will cause problems when you try to run from the postgres
directory. You will need to kill the ipc-daemon program, update the
registry, then run ipc-daemon and postgres.

In the console program, mentioned earlier, it allows for the ipc-daemon
to be run prior to postmaster, and killed at exit. Besides looking nicer
than a DOS window, it also alows loging the output to a file.

Todd F. Peterson wrote:

>i am trying to create a working windows postgres using the minimum amount
>of cygwin stuff. started with minimum stuff i knew had to be there like
>bash, postgres, etc. then kept trying to do initdb until no errors
>appeared. finally suceeded and can run postmaster and psql as
>Administrator and with template1 database.
>
>problem is, cannot create a different database using createdb or in psql
>with create database. i get the following message and not sure why it is
>failing.
>
>template1=# create database test;
>WARNING: database directory '/cygdrive/c/cygmin/bin/pg_data/base/16983'
>could not be removed
>ERROR: CREATE DATABASE: could not initialize database directory; delete
>failed as well
>template1=#
>
>there is no 16983 directory under base to start with. noticed that each
>attempt uses next sequence number so tried to create directory first
>manually and then create. here's what i get:
>
>template1=# create database test;
>ERROR: CREATE DATABASE: unable to create database directory
>'/cygdrive/c/cygmin
>/bin/pg_data/base/17013': File exists
>template1=#
>
>anybody know what i'm missing?
>
>here's what i have so far for minimum files:
>/cygmin
>
>/cygmin/bin
>basename.exe
>bash.exe
>cat.exe
>chmod.exe
>cp.exe
>createdb
>createuser
>cygiconv-2.dll
>cygintl-1.dll
>cygintl-2.dll
>cygncurses6.dll
>cygpcre.dll
>cygreadline5.dll
>cygwin1.dll
>grep.exe
>gzip.exe
>initdb
>less.exe
>ls.exe
>mkdir.exe
>pg_config
>pg_controldata.exe
>pg_ctl
>pg_data (the database directory)
>pg_dump.exe
>pg_dumpall.exe
>pg_encoding.exe
>pg_id.exe
>pg_resetxlog.exe
>pq.dll
>psql.exe
>rm.exe
>rmdir.exe
>sed.exe
>sleep.exe
>stty.exe
>
>/cygmin/tmp
>
>/cygmin/usr/local/bin
>
>ipc-daemon.exe
>ipck
>ipcrm.exe
>ipcs.exe
>ipctest.exe
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>