Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id MAA31009 for postgres-redist; Tue, 7 Nov 1995 12:45:10 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199511072045.MAA31009@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from nic (dataphone.se [194.23.92.66]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id MAA28233 for ; Tue, 7 Nov 1995 12:45:05 -0800 Received: from nina.dataphone.se ([194.23.92.69]) by nic.dataphone.se with ESMTP id <36594-3>; Tue, 7 Nov 1995 21:41:50 +0100 Received: (from ohb@localhost) by nina.dataphone.se (8.6.12/8.6.10) id VAA09882; Tue, 7 Nov 1995 21:45:36 +0100 Date: Tue, 7 Nov 1995 21:45:36 +0100 (MET) From: Peter Osterberg To: postgres@postgres.Berkeley.EDU Subject: Moving a database Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=iso8859-1 Content-Transfer-Encoding: QUOTED-PRINTABLE Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Tue, 07 Nov 95 12:45:10 -0800 Resent-XMts: smtp I had previoulsy my postgres-deamon running on a Linux-box. I did set up=20 the postgres deamon on a SS20 today and everything seems to work as it=20 should. I can create new DB's and so on. The problem comes when I try to=20 move my existing database to the SS20. I get PQExec errors when try to visi= t=20 the _moved_ database with 'monitor'. I moved the database by simply=20 copying all the old database files with ftp and cp. I understand that I=20 can't do like that. I also tryied to create an empty database with=20 createdb and the same name, and then ftp and cp the database-files. And=20 that didn't work either. I have the same version on both my machines, version 4.2. Is there anyway in which I can move the database between my computers. Regards Peter __-~~-__-~~-__-~~-__-~~-__-~~-__-~~-__-~~-__-~~-__-~~-__-~~-__-~~-__-~~-__ || At home: || DataPhone Sweden AB || || Peter =D6sterberg || Peter =D6sterberg = || || Ekstigen 6 || Po.Box 209 || || 161 36 Bromma || 161 65 Bromma || || || Tel.....: +46(0)8 - 704 17 00 || || || Fax.....: +46(0)8 - 704 91 00 || || || Cellular: +46(0)70 - 735 65 15 || || || Email...: ohb@dataphone.se || || || URL.....: http://www.dataphone.se/~ohb || ~~-__-~~-__-~~-__-~~-__-~~-__-~~-__-~~-__-~~-__-~~-__-~~-__-~~-__-~~-__-~~ ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU". If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ============================================================================== URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/