Skip site navigation (1) Skip section navigation (2)

PostgreSQL in Windows2000 PRO

From: <victor(dot)filho(at)caixa(dot)gov(dot)br>
To: <pgsql-cygwin-owner(at)postgresql(dot)org>
Subject: PostgreSQL in Windows2000 PRO
Date: 2004-08-09 15:14:46
Message-ID: 2F97A681A69A8B48B7B0C14014B6154D5153D7@rj0000nt512.correio.caixa (view raw or flat)
Thread:
Lists: pgsql-cygwin
Hi, Now it works fine !
But now I have one more problem . I have instaled "php-cgi" to able able to execute "PHP pages".
When I try to execute teste.php on the IE, I receive the message :

Fatal error: Call to undefined function pg_connect() in c:\Inetpub\wwwroot\PHP\teste1.php on line 4
I seems as if my browse(Internet Explorer 6.0) is not seeing the PostGres . Under the "cigwin", I am starting and acessing all database tables ok . 
What may I do now ?

Here is my source code teste1.php :

<HTML>
        <BODY>
        <?
		$database = pg_connect("dbname=APOIO") ;

		$result = pg_exec($database, "select matricula, nome, ramal 
		                  from empregado order by nome") ;

		for ( $i=0; $i < pg_NumRows($result); $i++ )
		{
		 	echo pg_result($result, $i, 0);
			echo "-----" ;
			echo pg_result($result, $i, 1);
			echo "-----" ;
			echo pg_result($result, $i, 2);
			echo "<BR>" ;
		}

        ?>
        </BODY>
        </HTML>


Thanks again .

Victor
Brasil / Rio de Janeiro / RJ 


 


-----Mensagem original-----
De: Daniel Secomb [mailto:dan(at)ds-d(dot)com]
Enviada em: sexta-feira, 6 de agosto de 2004 01:32
Para: Victor Ossaille Filho
Assunto: RE: [CYGWIN] PostgreSQL in Windows2000 PRO


Hey Victor,

Before you type in "$ /usr/sbin/cygserver &", type in this:

export CYGWIN=server

That'll do it.

Dan

-----Original Message-----
From: pgsql-cygwin-owner(at)postgresql(dot)org
[mailto:pgsql-cygwin-owner(at)postgresql(dot)org]On Behalf Of
victor(dot)filho(at)caixa(dot)gov(dot)br
Sent: Thursday, August 05, 2004 2:19 AM
To: pgsql-cygwin(at)postgresql(dot)org
Subject: [CYGWIN] PostgreSQL in Windows2000 PRO


Hi,
I am trying to install PostGres in my machine with OS windows 2000 PRO as
instructions in the site http://www.postgresql.org/docs/faqs/text/FAQ_MSWIN
, but I am not having  success.

I follow the instructions but when I am not able to init the db ( please see
below ) .
What´s wrong ?  What may I do ?

Thank you very much for the help,

Victor
Brazil/Rio de Janeiro/RJ


c053102(at)CR7260ET292 ~
$ /usr/sbin/cygserver &
[1] 1676

c053102(at)CR7260ET292 ~
$ cygserver: Initialization complete.  Waiting for requests.
initdb -D /usr/local/pgsql/data -W -E LATIN1
The files belonging to this database system will be owned by user "c053102".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/local/pgsql/data... ok
creating directory /usr/local/pgsql/data/base... ok
creating directory /usr/local/pgsql/data/global... ok
creating directory /usr/local/pgsql/data/pg_xlog... ok
creating directory /usr/local/pgsql/data/pg_clog... ok
selecting default max_connections... Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
10
selecting default shared_buffers... Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
50
creating configuration files... ok
creating template1 database in /usr/local/pgsql/data/base/1... Signal 12

initdb: failed
initdb: removing data directory "/usr/local/pgsql/data"

c053102(at)CR7260ET292 ~
$

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


pgsql-cygwin by date

Next:From: Jason TishlerDate: 2004-08-10 00:46:25
Subject: Re: Postmaster service on Windows 2000
Previous:From: Václav VozárDate: 2004-08-09 08:51:43
Subject: Re: PostgreSQL compile error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group