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

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

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

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

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

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