Re: postgres on windows with minimal cygwin

It is a windows program that captures the stdout and stderr output from
postmaster and displays them on the screen.

Todd F. Peterson wrote:

>Thanks, that's what my troubles were. When you say Windows console, do you
>mean a postgres gui or something else?
>
>todd
>
>On Wed, 1 Jan 2003, mlw wrote:
>
>
>
>>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
>>>
>>>
>>>
>>>
>>>
>>
>>---------------------------(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)
>>
>>
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
>