Re: PostgreSQL 7.2 - 8.0 replication issue
| From: | D . C . | Date: | Mon, 27 Jun 2005 18:42:51 +0000 |
| Subject: | Re: PostgreSQL 7.2 - 8.0 replication issue | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39797@lists.php.net to get a copy of this message | ||
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 coughlandesmond@yahoo.fr ___________________________________________________________________________ Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com