On Mon, 25 Sep 2006 08:13:38 +1000, WJ Bundy wrote > I have PG8.0 on a new machine with 2.6.17 and everything seems to > work fine after creating a new db called new_db. > > How do I populate new_db with data from my current database "old_db" > SL version 2.6.1, PG version 7.3.4. ? psql new_db < old_db does not > work. I realise that the schema in old_db probably needs to be > updated, without dropping tables or data. > > I am afraid I do not understand the notes in the FAQ. Any previous > posting on this? > >
change the tables as per FAQ in the backup file and restore the backup to an empty database. Dieter Simader http://www.sql-ledger.com (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 ============ On a clear disk you can seek forever ========== ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ sql-ledger-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
