PostgreSQL in Windows2000 PRO - Mailing list pgsql-cygwin
| From | |
|---|---|
| Subject | PostgreSQL in Windows2000 PRO |
| Date | |
| Msg-id | 2F97A681A69A8B48B7B0C14014B6154D5153D7@rj0000nt512.correio.caixa Whole thread Raw |
| List | 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
acessingall 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@ds-d.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@postgresql.org
[mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of
victor.filho@caixa.gov.br
Sent: Thursday, August 05, 2004 2:19 AM
To: pgsql-cygwin@postgresql.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@CR7260ET292 ~
$ /usr/sbin/cygserver &
[1] 1676
c053102@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@CR7260ET292 ~
$
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
pgsql-cygwin by date: