Pgsql on Windows

Started by Dennis Gearonover 22 years ago8 messagesgeneral
Jump to latest
#1Dennis Gearon
gearond@fireserve.net

How soon will 7.5 come out? (yes, I know, 7.4 is beta right now).

How difficult is it to set up cygwin?

I'd like to make a drop in Apache/Postgres/PHP application on a windows
computer for someone in my organization.

I'd PREFER to avoid ODBC if at all possible.

#2Matthew T. O'Connor
matthew@zeut.net
In reply to: Dennis Gearon (#1)
Re: Pgsql on Windows

On Mon, 2003-10-13 at 17:10, Dennis Gearon wrote:

How soon will 7.5 come out? (yes, I know, 7.4 is beta right now).

Who knows... six months maybe?

How difficult is it to set up cygwin?

Not very, I used postgres via cygwin for development for a long time.
Works fine, but it's slower and not quite as stable as you would want
for production purposes.

I'd like to make a drop in Apache/Postgres/PHP application on a windows
computer for someone in my organization.

I'd PREFER to avoid ODBC if at all possible.

I don't see how ODBC fits in to this at all. There is no need for ODBC
if postgresql is running via cygwin, running on a remote linux box, or
even native on windows.

#3Peter Eisentraut
peter_e@gmx.net
In reply to: Dennis Gearon (#1)
Re: Pgsql on Windows

Dennis Gearon writes:

How soon will 7.5 come out? (yes, I know, 7.4 is beta right now).

All signs point to September 24, 2004.

How difficult is it to set up cygwin?

I found it quite easy.

--
Peter Eisentraut peter_e@gmx.net

#4Gene Vital
genevital@karibe.com
In reply to: Matthew T. O'Connor (#2)
Re: Pgsql on Windows

Matthew T. O'Connor wrote:

I don't see how ODBC fits in to this at all. There is no need for ODBC
if postgresql is running via cygwin, running on a remote linux box, or
even native on windows.

I am new to PostgreSQL
what other options are available to connect then ?

--
Eugene Vital
Any technology indistinguishable from magic is insufficiently advanced.

#5Mike Mascari
mascarm@mascari.com
In reply to: Peter Eisentraut (#3)
Re: Pgsql on Windows

Peter Eisentraut wrote:

Dennis Gearon writes:

How soon will 7.5 come out? (yes, I know, 7.4 is beta right now).

All signs point to September 24, 2004.

Have you verified that with the Master of Ceremonies?

Mike Mascari
mascarm@mascari.com

#6Matthew T. O'Connor
matthew@zeut.net
In reply to: Gene Vital (#4)
Re: Pgsql on Windows

On Mon, 2003-10-13 at 17:37, Gene Vital wrote:

Matthew T. O'Connor wrote:

I don't see how ODBC fits in to this at all. There is no need for ODBC
if postgresql is running via cygwin, running on a remote linux box, or
even native on windows.

I am new to PostgreSQL
what other options are available to connect then ?

When you have postgresql support compiled into PHP, then PHP connects
directly using native PostgreSQL calls (libpq), no ODBC layer to deal
with.

#7Cornelia Boenigk
poppcorn@cornelia-boenigk.de
In reply to: Dennis Gearon (#1)
Re: Pgsql on Windows

Hi

When you have postgresql support compiled into PHP, then PHP

connects

directly using native PostgreSQL calls (libpq), no ODBC layer to

deal

with.

Working with Windows you normally don't compile PHP but use the Win
binaries. To connect to a PostgreSQL database you must uncomment the
php_pgsql.dll in php.ini.

Regards
Conni

#8scott.marlowe
scott.marlowe@ihs.com
In reply to: Matthew T. O'Connor (#6)
Re: Pgsql on Windows

On Mon, 13 Oct 2003, Matthew T. O'Connor wrote:

On Mon, 2003-10-13 at 17:37, Gene Vital wrote:

Matthew T. O'Connor wrote:

I don't see how ODBC fits in to this at all. There is no need for ODBC
if postgresql is running via cygwin, running on a remote linux box, or
even native on windows.

I am new to PostgreSQL
what other options are available to connect then ?

When you have postgresql support compiled into PHP, then PHP connects
directly using native PostgreSQL calls (libpq), no ODBC layer to deal
with.

Note that ODBC may still be preferred if you're trying to write a very
generic app like a bulletin board or something. But the native layer
generally reveals a little more of the database API to the code, which is
sometimes quite nice too.

It's all a trade off, I mostly use the native pgsql API and am very happy
with it.