PDA

View Full Version : PostgreSQL for Windows


cutecode
06-28-02, 22:45
is it possible to run PostgreSQL under Windows ?
If so, where can I download it ?

MaleMan
06-29-02, 09:28
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
:D

eperich
06-29-02, 10:08
You must run cygwin. install it and there is a MS-FAQ of the installation of postgresql

You will also need the ipc-daemon

ikc
11-05-02, 10:35
is the ipc-daemon always needed in the last cygwin?

eperich
11-05-02, 10:45
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

ikc
11-05-02, 10:53
thks for your reply. I'm actually experiencing installing Postgres on my Win2k to replce an MsSQL server. Have any suggestions?

ikc
11-05-02, 11:13
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?

eperich
11-05-02, 19:02
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 ?

ikc
11-06-02, 05:35
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

rogeriopereira
07-02-03, 15:15
Consider www.dbexperts.net.

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