Results 1 to 10 of 10
  1. #1
    Join Date
    Jun 2002
    Posts
    8

    Unanswered: PostgreSQL for Windows

    is it possible to run PostgreSQL under Windows ?
    If so, where can I download it ?

  2. #2
    Join Date
    Mar 2002
    Location
    Pilipinas
    Posts
    36

    Wink CYGWIN...

    i think thers one, but you hav to install cygwin first...

    cygwin - its a kind of linux in your windoze box...
    better find some explanation in GOOGLE...

    HTP
    --- Hey! its me!!! the MaleMan ---

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

    you must run cygwin

    You must run cygwin. install it and there is a MS-FAQ of the installation of postgresql

    You will also need the ipc-daemon
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  4. #4
    Join Date
    Nov 2002
    Location
    France
    Posts
    4
    is the ipc-daemon always needed in the last cygwin?

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

    ipc-daemon

    yes as far as i know.
    download the latest cygwin and look into the FAQ as described above

    I'm not working often under cygwin

    but there will be a native windows port without cygwin for the 7.4 version.

    7.3 is coming out soon. maybe in 6 monthes there is also a windows version of postgres
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  6. #6
    Join Date
    Nov 2002
    Location
    France
    Posts
    4
    thks for your reply. I'm actually experiencing installing Postgres on my Win2k to replce an MsSQL server. Have any suggestions?

  7. #7
    Join Date
    Nov 2002
    Location
    France
    Posts
    4

    Re: ipc-daemon

    Originally posted by eperich
    yes as far as i know.
    download the latest cygwin and look into the FAQ as described above

    I'm not working often under cygwin

    but there will be a native windows port without cygwin for the 7.4 version.

    7.3 is coming out soon. maybe in 6 monthes there is also a windows version of postgres
    I've downloaded and intalled cygwin and ipc 1.11 (and executed it). then I try to initailize my db and here's what I otbtain:
    $ /usr/bin/initdb -D /var/pgdata/base
    The files belonging to this database system will be owned by user "PHRU".
    This user must also own the server process.

    Fixing permissions on existing directory /var/pgdata/base... ok
    creating directory /var/pgdata/base/base... ok
    creating directory /var/pgdata/base/global... ok
    creating directory /var/pgdata/base/pg_xlog... ok
    creating directory /var/pgdata/base/pg_clog... ok
    creating template1 database in /var/pgdata/base/base/1... ok
    creating configuration files... ok
    initializing pg_shadow... FindExec: invalid binary "/usr/bin/postgres"
    FATAL 1: /usr/bin/postgres: could not locate executable, bailing out...

    initdb failed.
    Messed Something in the install?

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

    error

    did you execute the ipc-daemon with & at the end?

    maybe your download is corrupt?

    As i said before I'm no expert in cygwin.

    do you try to compile postgresql ?
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  9. #9
    Join Date
    Nov 2002
    Location
    France
    Posts
    4
    I found the solution on an other forum. Here are the different steps:
    $chown 544 /usr/bin
    $chmod 755 /usr/bin
    $chmod +x+r+w /usr/bin/postgres.exe
    $/usr/local/bin/ipc-daemon --install-as-service
    $cd /usr/bin/
    $initdb -d -D /var/pgdata/base >logposgresinitdb.log &2>1 &
    $/usr/bin/pg_ctl -D /var/pgdata/base -l logfile start

    And Everything works fine. Thks, cya

  10. #10
    Join Date
    Jul 2003
    Location
    São Paulo, Brazil
    Posts
    4

    Post

    Consider www.dbexperts.net.

    They have a PostgreSQL for Windows version, but it's not free of charge.

Posting Permissions

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