Re: PostgreSQL 7.2 - 8.0 replication issue

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

 



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



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

  Powered by Linux