Re: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-27 Thread Martín Marqués
El Dom 26 Jun 2005 22:48, Thomas Bonham escribió: > Thanks for the help. > The code now looks like this. > CODE: > > Login > > > > > $conn = pg_connect("user=auth dbname=auth password=redhat") > or die ("Could not connect") ; > echo "Connectd Successful

[PHP-DB] problem getting started...

2005-06-27 Thread D . C .
Hi, I'm having problems getting started with PhP.. I have a postgreSQL installation on my iBook (Mac-OSX 10.3.9), which runs perfectly as I've been using it for months. I checked phpinfo() and it showed version 4.3.11, so I got the source for 5.0.4 and installed it. However, phpinfo() still

[PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

2005-06-27 Thread Mark Galbreath
I have to upgrade a web app from PHP 4.3.11 with PostgreSQL 7.2 to PHP 5.0.4 with PostgreSQL 8.0.3. Currently I have PHP4 (as Apache 2.54 mod on port 80) and PHP5 (default CGI mode on port 8181) running concurrently on my DEV box. I installed PostgreSQL 8.0.3 on the DEV box as well. On the Po

Re: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

2005-06-27 Thread D . C .
Le 27 juin 05, à 20:31, Mark Galbreath a écrit : I have to upgrade a web app from PHP 4.3.11 with PostgreSQL 7.2 to PHP 5.0.4 with PostgreSQL 8.0.3. Currently I have PHP4 (as Apache 2.54 mod on port 80) and PHP5 (default CGI mode on port 8181) running concurrently on my DEV box. I installed

RE: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

2005-06-27 Thread Mark Galbreath
Thanks for your reply, Des; unfortunately, your suggestion had no affect. I realize this is technically a PostgreSQL issue, but rationalized my request help here because (1) this is the PHP-DB list and PHP is used with MySQL and PostgreSQL more than any other databases, and (2) I assumed that s

Re: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

2005-06-27 Thread D . C .
Le 27 juin 05, à 21:23, Mark Galbreath a écrit : Thanks for your reply, Des; unfortunately, your suggestion had no affect. I realize this is technically a PostgreSQL issue, but rationalized my request help here because (1) this is the PHP-DB list and PHP is used with MySQL and PostgreSQL more

RE: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

2005-06-27 Thread Mark Galbreath
The solution was to make sure that ftp mode is in ASCII (type I) and then execute the following, assuming a dummy database, "test," has been created as part of the installation, and the database dump resides at /usr/local/pgsql/temp: On 7.2 server: $ /usr/local/pgsql/bin/pg_dumpall --format=ASC

Re: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

2005-06-27 Thread Martín Marqués
El Lun 27 Jun 2005 17:48, Mark Galbreath escribió: > The solution was to make sure that ftp mode is in ASCII (type I) and then execute the following, assuming a dummy database, "test," has been created as part of the installation, and the database dump resides at /usr/local/pgsql/temp: The best

Re: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

2005-06-27 Thread Martín Marqués
El Lun 27 Jun 2005 15:31, Mark Galbreath escribió: > I have to upgrade a web app from PHP 4.3.11 with PostgreSQL 7.2 to PHP 5.0.4 with PostgreSQL 8.0.3. > > Currently I have PHP4 (as Apache 2.54 mod on port 80) and PHP5 (default CGI mode on port 8181) running concurrently on my DEV box. I insta

Re: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

2005-06-27 Thread Luis Morales
Hi, I write an litle procedure about migration from postgres 7x to 8x. this is the link: http://fastonion.blogspot.com/2005/04/gentoo-migrando-postgres-7x-8.html In Resume you must be do: On current DB Server: su - postgres pg_dumpall > /tmp/db.out On remote DB Server: copy db.out to new loc

Re: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-27 Thread Thomas Bonham
Thanks for the help. It works. I'm also posting my two .conf file that I had to configure. postgresql.conf: [EMAIL PROTECTED] data]# cat postgresql.conf # - # PostgreSQL configuration file # - # # This file consists of lines of the form: # #

[PHP-DB] Batch queries in the same mysql_query()

2005-06-27 Thread Denio Mariz
Hi, I'm trying to execute multiple queries using mysql_query() function and I'm getting an error to check SQL syntax. My PHP code looks like: //- $sql="select x from y ; insert into y values ( 1, 2 )"; mysql_query( $sql ) or die( mysql_error() ); //-