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 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. D.` -- Des Coughlan [EMAIL PROTECTED] ___ Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com -- 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
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] ___ Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com -- 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
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 thing, giving the case that he's using Linux, is to use scp. -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués | Programador, DBA Centro de Telemática| Administrador Universidad Nacional del Litoral - -- 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
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 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 Never used pg_restore. I just do this: $ psql -f db.out Always worked for me. -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués | Programador, DBA Centro de Telemática| Administrador Universidad Nacional del Litoral - -- 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
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 location on new server su - postgres psql -f db.out template1 Good Luck! Regards, Luis Morales On Mon, 2005-06-27 at 15:46 -0300, Martín Marqués wrote: 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 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 Never used pg_restore. I just do this: $ psql -f db.out Always worked for me. -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués | Programador, DBA Centro de Telemática | Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php