RE: PostgreSQL 7.2 - 8.0 replication issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:coughlandesmond@xxxxxxxx]
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 servdesk@xxxxxxxxxxxxxxxx


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



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux