libpq not working

Hi.

I tried to play a little bit with libpq on windows (the postgresql
server is running on a Debian/GNU Linux box, version 7.1.3).

So i eventually compiled libpq with mingw (i got the Makefiles from
Gerhard Häring and modified them a little bit (in 7.1.3 there is no
md5.c or i didn't find it)). Then i tried to comile and run the
following program:

------------------------
#include <stdio.h>
#include <libpq-fe.h>

int main() {
  PGconn *con = NULL;

  con = PQconnectdb("host=mauzi.home hostaddr=10.0.1.2 port=5432 dbname=testdb user=xxxx password=xxxx");
  if (con == NULL) {
    puts("ERROR: con is NULL!");
    return 0;
  }
  if (PQstatus(con) == CONNECTION_BAD)
    printf ("Connection failed!\n %s\n", PQerrorMessage(con));
  else
    puts("Everything is OK! Connected.");

  PQfinish(con);
  return 0;
}

Sort odrder in PostgreSql on Cygwin

Install PostgreSQL

Hi,

I am trying to install PostgreSQL 7.2 on a Win2K machine but I am getting
problems in the configuration.
I have installed and started cygwin. When I type
	
	./configure

I get 

	bash: ./configure: No such file or directory

What must I have to do?

Thank you,
Joao

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

Re: Install PostgreSQL

João,

On Mon, Apr 08, 2002 at 02:29:04PM +0100, João Carlos Fernandes Costa wrote:
> I am trying to install PostgreSQL 7.2 on a Win2K machine but I am getting
> problems in the configuration.
> I have installed and started cygwin. When I type
> 	
> 	./configure
> 
> I get 
> 
> 	bash: ./configure: No such file or directory
> 
> What must I have to do?

Use the pre-built PostgreSQL 7.2 that is part of the standard Cygwin
distribution.  Or, install ash 20020131-1 to solve the above problem.

Jason

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

Re: Install PostgreSQL

Jason,

Where is pre-built PostgreSQL 7.2 located?

João

-----Original Message-----
From: Jason Tishler [mailto:jason <at> tishler.net]
Sent: segunda-feira, 8 de Abril de 2002 14:54
To: João Carlos Fernandes Costa
Cc: 'pgsql-cygwin <at> postgresql.org'
Subject: Re: [CYGWIN] Install PostgreSQL

João,

On Mon, Apr 08, 2002 at 02:29:04PM +0100, João Carlos Fernandes Costa wrote:
> I am trying to install PostgreSQL 7.2 on a Win2K machine but I am getting
> problems in the configuration.
> I have installed and started cygwin. When I type
> 	
> 	./configure
> 
> I get 
> 
> 	bash: ./configure: No such file or directory
> 
> What must I have to do?

Use the pre-built PostgreSQL 7.2 that is part of the standard Cygwin
distribution.  Or, install ash 20020131-1 to solve the above problem.

Jason

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: Install PostgreSQL

João,

On Mon, Apr 08, 2002 at 02:53:44PM +0100, João Carlos Fernandes Costa wrote:
> Where is pre-built PostgreSQL 7.2 located?

It is available on the Cygwin mirrors.  Just click on "Database" in
setup.exe's chooser to see the PostgreSQL entry, then click on the
"spin" icon until 7.2-2 is displayed.  Please read the README:

    /usr/doc/Cygwin/postgresql-7.2.README

Jason

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo <at> postgresql.org

CYGWIN+Apache+PHP+PostgreSQL

Anyone had any success building this combination? 

--
Michael Morgan

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo <at> postgresql.org

Re: CYGWIN+Apache+PHP+PostgreSQL

"Michael Morgan" <mjmorgan <at> ufl.edu> wrote:

>Anyone had any success building this combination? 
>
[...]
Yes.

SLao

__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying
online with Shop <at> Netscape! http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/

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

Re: Sort odrder in PostgreSql on Cygwin

"Andrzej Zeja" <kinaz <at> eden.tu.kielce.pl> wrote:

>Hi
>
>Does anybody know how to change sort tables using other charachter sets (like ISO8859-2 for exemple) ?
[...]

I'm not very sure, but having the postgresql compiled using "--with-multibyte" and setting "ENCODING =
LATIN2" (in your case), should solve the problem.

SLao

__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying
online with Shop <at> Netscape! http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/

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

http://www.postgresql.org/users-lounge/docs/faq.html

Re: PostgreSQL and Cygwin as production database

Thanks for that Tim.  Could I please ask everyone else though if the silence
means "of course it's fine in a production environment" or "I wouldn't dream
of even considering it".  If you think it doesn't make for an interesting discusion 
mail me directly.  Many thanks.

----- Original Message ----- 
From: "Tim Finch, FosterFinch Ltd" <tim <at> fosterfinch.co.uk>
To: "Steve Slatcher" <steve_slatcher <at> scientia.com>
Cc: <pgsql-cygwin <at> postgresql.org>
Sent: Friday, April 05, 2002 1:10 PM
Subject: Re: [CYGWIN] PostgreSQL and Cygwin as production database

> I have no experience of production systems on Windows but I noted somewhere 
> in this column recently someone ran into a 62  concurrent session maximum 
> down to some bug or limit in Cygwin, which you might want to look into, if 
> you expect high simultaneous hit rate onto the postmaster...
> 
> At 11:28 05/04/2002 +0100, Steve Slatcher wrote:
> >Hi all
> >
> >Would anyone share experiences and/or thoughts about the use of PostgreSQL
> >on Cygwin in a production environment ?  Leaving aside, for now at least, 
> >why I
> >would want to do it!
> >
> >I am aware that it does not install as Windows sysadmins might expect, but
> >was wondering about issues like performace and reliability cf other platforms.
> >
> >Steve Slatcher
> >
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 3: if posting/reading through Usenet, please send an appropriate
> >subscribe-nomail command to majordomo <at> postgresql.org so that your
> >message can get through to the mailing list cleanly
> 
> Tim Finch,
> FosterFinch Ltd
> http://www.fosterfinch.co.uk
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo <at> postgresql.org
> 

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