Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    1

    Question Unanswered: postgres on windows with minimal cygwin

    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

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    cygwin

    I'm not an expert with cygwin

    try the usenet
    there is an cygwin group from postgres
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •