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] $ ftp>cd [db.out location] $ ftp>lcd /usr/local/pgsql/temp $ ftp>ascii $ ftp>get db.out $ ftp>bye $ /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:coughlandesmond@yahoo.fr] 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 coughlandesmond@yahoo.fr ******************************************************************************************************************* 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@dbm.state.md.us. This email has been scanned by networkMaryland Antivirus Service for the presence of computer viruses.