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
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
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
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
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
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
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