[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 PostgreSQL 7.2 server, I did a pg_dumpall db.out and ftp'd db.out to the PostgreSQL 8.0.3 (DEV) server. When I attempt to pg_restore db.out, the PostgreSQL archiver aborts with the error: input file does not appear to be a valid archive I'd sure appreciate a clue on this issue! tia, ~mark *** This email and any file transmitted with it may be confidential and is intended solely for the use of the individual or entity to whom it is addressed. If you received this email in error please notify the DBM Service Desk by forwarding this message to [EMAIL PROTECTED] This email has been scanned by networkMaryland Antivirus Service for the presence of computer viruses. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 since PHP5 and PostgreSQL 8.0 have been released, there are many developers who have had to deal with this or a similar problem. ~mark -Original Message- From: D.C. [mailto:[EMAIL PROTECTED] Sent: Monday, June 27, 2005 2:43 PM 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 PostgreSQL 8.0.3 on the DEV box as well. On the PostgreSQL 7.2 server, I did a pg_dumpall db.out and ftp'd db.out to the PostgreSQL 8.0.3 (DEV) server. When I attempt to pg_restore db.out, the PostgreSQL archiver aborts with the error: input file does not appear to be a valid archive I'd sure appreciate a clue on this issue! Try -format .. and output it as ASCII ... I _seem_ to recall having a similar issue a month or so ago .. this is really a PostgreSQL issue, though. This email and any file transmitted with it may be confidential and is intended solely for the use of the individual or entity to whom it is addressed. If you received this email in error please notify the DBM Service Desk by forwarding this message to [EMAIL PROTECTED] This email has been scanned by networkMaryland Antivirus Service for the presence of computer viruses. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 --format=ASCII db.out On 8.0.3 server: $ ftp [IP address] $ ftpcd [db.out location] $ ftplcd /usr/local/pgsql/temp $ ftpascii $ ftpget db.out $ ftpbye $ /usr/local/pgsql/bin/psql test # \i /usr/local/pgsql/temp/db.out [database]-# \q $ - That's it. This was by no means obvious from the documentation, by the way. But now the real fun begins...will the migration work? Stay tuned ~mark -Original Message- From: D.C. [mailto:[EMAIL PROTECTED] Sent: Monday, June 27, 2005 4:23 PM 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 than any other databases, and (2) I assumed that since PHP5 and PostgreSQL 8.0 have been released, there are many developers who have had to deal with this or a similar problem. Hey, no worries. I wasn't actually 'flaming' you for posting your question here, as I've been subscribed all of two hours myself .. .but I did have exactly the same problem with pg_dump as you. Google for my name and pg_dump, and it might turn up. Regards ... D. -- Des Coughlan [EMAIL PROTECTED] *** This email and any file transmitted with it may be confidential and is intended solely for the use of the individual or entity to whom it is addressed. If you received this email in error please notify the DBM Service Desk by forwarding this message to [EMAIL PROTECTED] This email has been scanned by networkMaryland Antivirus Service for the presence of computer viruses. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] list test - ignore
is this list alive? *** This email and any file transmitted with it may be confidential and is intended solely for the use of the individual or entity to whom it is addressed. If you received this email in error please notify the DBM Service Desk by forwarding this message to [EMAIL PROTECTED] This email has been scanned by networkMaryland Antivirus Service for the presence of computer viruses.
[PHP-DB] PHP 4 to 5 Upgrade Issue
I need to compare PHP 4 code with PHP 5 interpreter on same machine. I am following the examples in Adam Trachtenberg's Upgrading to PHP 5 (O'Reilly 2004) listed in Appendix C: Installing PHP 5 Alongside PHP 4 with regard to using virtual hosting and relative ports on Apache httpd. I have also read the Apache docs online regarding virtual hosting. And I cannot get it to work. I have the following relevant entries in Apache httpd.conf: Listen 8181 Listen 80 VirtualHost *:80 LoadModule php4_module modules/libphp4.so DocumentRoot /srv/www/htdocs /VirtualHost VirtualHost *:8181 DocumentRoot /srv/www/htdocs ScriptAlias /* /srv/www/htdocs Directory /usr/local/php-5.0.4/bin /Directory /VirtualHost When I browse http://localhost:8181/ I always get the root (/index.html) instead of the alias (/php5/index.php). Any clues? tia, ~mark This email and any file transmitted with it may be confidential and is intended solely for the use of the individual or entity to whom it is addressed. If you received this email in error please notify the DBM Service Desk by forwarding this message to [EMAIL PROTECTED] This email has been scanned by networkMaryland Antivirus Service for the presence of computer viruses. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP 4 to 5 Upgrade Issue
Excellent, Gary! Typically, sitting there staring me in the face! Thanks a lot! ~mark -Original Message- From: Gary Every [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 4:12 PM To: Mark Galbreath; php-db@lists.php.net Subject: RE: [PHP-DB] PHP 4 to 5 Upgrade Issue I need to compare PHP 4 code with PHP 5 interpreter on same machine. I am following the examples in Adam Trachtenberg's Upgrading to PHP 5 (O'Reilly 2004) listed in Appendix C: Installing PHP 5 Alongside PHP 4 with regard to using virtual hosting and relative ports on Apache httpd. I have also read the Apache docs online regarding virtual hosting. And I cannot get it to work. I have the following relevant entries in Apache httpd.conf: Listen 8181 Listen 80 VirtualHost *:80 LoadModule php4_module modules/libphp4.so DocumentRoot /srv/www/htdocs /VirtualHost VirtualHost *:8181 DocumentRoot /srv/www/htdocs ScriptAlias /* /srv/www/htdocs Directory /usr/local/php-5.0.4/bin /Directory /VirtualHost When I browse http://localhost:8181/ I always get the root (/index.html) instead of the alias (/php5/index.php). Any clues? tia, ~mark Mark, Change your DocumentRoot on *:8181 to: DocumentRoot /srv/www/htdocs/php5 Your ScriptAlias isn't really affecting that portion of the site. Your PHP5 index.php resides in /srv/www/htdocs/php5 directory, right? G.~ This email and any file transmitted with it may be confidential and is intended solely for the use of the individual or entity to whom it is addressed. If you received this email in error please notify the DBM Service Desk by forwarding this message to [EMAIL PROTECTED] This email has been scanned by networkMaryland Antivirus Service for the presence of computer viruses. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php *** This email and any file transmitted with it may be confidential and is intended solely for the use of the individual or entity to whom it is addressed. If you received this email in error please notify the DBM Service Desk by forwarding this message to [EMAIL PROTECTED] This email has been scanned by networkMaryland Antivirus Service for the presence of computer viruses. This email and any file transmitted with it may be confidential and is intended solely for the use of the individual or entity to whom it is addressed. If you received this email in error please notify the DBM Service Desk by forwarding this message to [EMAIL PROTECTED] This email has been scanned by networkMaryland Antivirus Service for the presence of computer viruses. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php