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
