X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 2B1CE9FA621 for ; Mon, 24 Jul 2006 21:27:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 02915-08 for ; Tue, 25 Jul 2006 00:26:57 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.184]) by postgresql.org (Postfix) with ESMTP id 379B39FA441 for ; Mon, 24 Jul 2006 21:26:55 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id p77so73035nfc for ; Mon, 24 Jul 2006 17:26:51 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=udHWdBYDDOcSQoyf+n8H8PPLZISL7Ef3xBybZB7wRXQ5VkozJi2umGIJeDKqyeySMfjpUjsPoJR5TVPe6HIf7bqMkxkRH5zeLkkKSQ0MwncOKPaOWnCYHeBvOGNa65rXp78187cpKJrUIFJp1M13McrSXBRtQwbxkLrXZBmXeBw= Received: by 10.49.5.12 with SMTP id h12mr81011nfi; Mon, 24 Jul 2006 17:26:51 -0700 (PDT) Received: by 10.49.37.13 with HTTP; Mon, 24 Jul 2006 17:26:51 -0700 (PDT) Message-ID: <75c69f690607241726r1a640b2excab3439485cdff63@mail.gmail.com> Date: Mon, 24 Jul 2006 17:26:51 -0700 From: "JieJun Xu" To: pgsql-admin@postgresql.org Subject: problem backup/restore PSQL DB MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_192061_25569032.1153787211841" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.551 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_10_20, HTML_MESSAGE, SPF_PASS X-Spam-Level: * X-Archive-Number: 200607/194 X-Sequence-Number: 22440 ------=_Part_192061_25569032.1153787211841 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all, I am trying to backup a psql database in one system(Debian), and restore it to another system(ubuntu) which has a fresh installed psql db. However, I got the following errors. Can anyone give me some help on solving it. Many thanks. ------------- OME Restore ------------- \_ Extracting postgres database ome and checking archive version /bin/tar --preserve-permissions --same-owner --directory /tmp -xf 'ome_backup_2006-07-24.tar' OMEmaint omeDB_backup \_ Checking archive for OMEIS files /bin/tar -tf 'ome_backup_2006-07-24.tar' Files/lastFileID \_ Restoring postgress database ome Checking database Database ome (version 2.23) was found and it will be overwritten. Continue ? [y/n]: y su postgres -c '/usr/bin/createuser --adduser --createdb ome' createuser: creation of new user failed: ERROR: user "ome" already exists su postgres -c '/usr/bin/createdb -T template0 ome' CREATE DATABASE su postgres -c '/usr/bin/pg_restore -O -d ome --use-set-session-authorization /tmp/omeDB_backup' pg_restore: [archiver (db)] could not execute query: ERROR: user "rajesh" does not exist ------=_Part_192061_25569032.1153787211841 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all,
    I am trying to backup a psql database in one system(Debian), and restore it to another system(ubuntu) which has a fresh installed psql db.  However, I got the following errors. Can anyone give me some help on solving it. Many thanks.

-------------
 OME Restore
-------------

    \_ Extracting postgres database ome and checking archive version
/bin/tar  --preserve-permissions --same-owner --directory /tmp -xf 'ome_backup_2006-07-24.tar ' OMEmaint omeDB_backup    \_ Checking archive for OMEIS files
/bin/tar  -tf 'ome_backup_2006-07-24.tar' Files/lastFileID
    \_ Restoring postgress database ome
Checking database
Database ome (version 2.23) was found and it will be overwritten. Continue
? [y/n]: y
su postgres -c '/usr/bin/createuser --adduser --createdb  ome'
createuser: creation of new user failed: ERROR:  user "ome" already exists
su postgres -c '/usr/bin/createdb  -T template0 ome'
CREATE DATABASE
su postgres -c '/usr/bin/pg_restore  -O -d ome --use-set-session-authorization /tmp/omeDB_backup'
pg_restore: [archiver (db)] could not execute query: ERROR:  user "rajesh" does not exist

------=_Part_192061_25569032.1153787211841--