View Full Version : PostgreSQL for Windows
| is it possible to run PostgreSQL under Windows ?
If so, where can I download it ? |
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
| You must run cygwin. install it and there is a MS-FAQ of the installation of postgresql
You will also need the ipc-daemon |
is the ipc-daemon always needed in the last cygwin?
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
thks for your reply. I'm actually experiencing installing Postgres on my Win2k to replce an MsSQL server. Have any suggestions?
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?
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 ?
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.
vBulletin v3.5.3, Copyright ©2000-2008, Jelsoft Enterprises Ltd.