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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org