Pgsql on Windows

[Dennis Gearon]

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.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postg resql.org so that your
message can get through to the mailing list cleanly

[Matthew T. O'Connor]

Re: Pgsql on Windows

On Mon, 2003-10-13 at 17:10, Dennis Gearon wrote:[color=blue]
> How soon will 7.5 come out? (yes, I know, 7.4 is beta right now).[/color]

Who knows... six months maybe?
[color=blue]
> How difficult is it to set up cygwin?[/color]

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.
[color=blue]
> 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.[/color]

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.



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postg resql.org

[Peter Eisentraut]

Re: Pgsql on Windows

Dennis Gearon writes:
[color=blue]
> How soon will 7.5 come out? (yes, I know, 7.4 is beta right now).[/color]

All signs point to September 24, 2004.
[color=blue]
> How difficult is it to set up cygwin?[/color]

I found it quite easy.

--
Peter Eisentraut peter_e@gmx.net


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postg resql.org

[Gene Vital]

Re: Pgsql on Windows



Matthew T. O'Connor wrote:[color=blue]
> 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.[/color]

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


--
Eugene Vital
Any technology indistinguishab le from magic is insufficiently advanced.




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Mike Mascari]

Re: Pgsql on Windows

Peter Eisentraut wrote:
[color=blue]
> Dennis Gearon writes:
>
>[color=green]
>>How soon will 7.5 come out? (yes, I know, 7.4 is beta right now).[/color]
>
>
> All signs point to September 24, 2004.[/color]

Have you verified that with the Master of Ceremonies?

Mike Mascari
mascarm@mascari .com



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Matthew T. O'Connor]

Re: Pgsql on Windows

On Mon, 2003-10-13 at 17:37, Gene Vital wrote:[color=blue]
> Matthew T. O'Connor wrote:[color=green]
> > 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.[/color]
>
> I am new to PostgreSQL
> what other options are available to connect then ?[/color]

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


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Cornelia Boenigk]

Re: Pgsql on Windows

Hi
[color=blue]
> When you have postgresql support compiled into PHP, then PHP[/color]
connects[color=blue]
> directly using native PostgreSQL calls (libpq), no ODBC layer to[/color]
deal[color=blue]
> with.[/color]
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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postg resql.org so that your
message can get through to the mailing list cleanly

[scott.marlowe]

Re: Pgsql on Windows

On Mon, 13 Oct 2003, Matthew T. O'Connor wrote:
[color=blue]
> On Mon, 2003-10-13 at 17:37, Gene Vital wrote:[color=green]
> > Matthew T. O'Connor wrote:[color=darkred]
> > > 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.[/color]
> >
> > I am new to PostgreSQL
> > what other options are available to connect then ?[/color]
>
> When you have postgresql support compiled into PHP, then PHP connects
> directly using native PostgreSQL calls (libpq), no ODBC layer to deal
> with.[/color]

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.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to majordomo@postg resql.org)

[scott.marlowe]

Re: Pgsql on Windows

On Mon, 13 Oct 2003, Matthew T. O'Connor wrote:
[color=blue]
> On Mon, 2003-10-13 at 17:37, Gene Vital wrote:[color=green]
> > Matthew T. O'Connor wrote:[color=darkred]
> > > 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.[/color]
> >
> > I am new to PostgreSQL
> > what other options are available to connect then ?[/color]
>
> When you have postgresql support compiled into PHP, then PHP connects
> directly using native PostgreSQL calls (libpq), no ODBC layer to deal
> with.[/color]

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.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to majordomo@postg resql.org)