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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-cygwin by date

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