Re: postgres on windows with minimal cygwin

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@postgresql.org)
>