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

El Dom 26 Jun 2005 22:48, Thomas Bonham escribió: Thanks for the help. The code now looks like this. CODE: htmlheadtitleLogin/title /head body ?php $conn = pg_connect(user=auth dbname=auth password=redhat) or die (Could not connect) ; echo

[PHP-DB] problem getting started...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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() );