Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 657E59FA48F for ; Fri, 5 Jan 2007 06:34:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 87436-08 for ; Fri, 5 Jan 2007 06:33:56 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from fafnir.androme.com (fafnir.androme.com [62.58.96.158]) by postgresql.org (Postfix) with ESMTP id 030E19FA372 for ; Fri, 5 Jan 2007 06:33:59 -0400 (AST) Received: by fafnir.androme.com (Postfix, from userid 1003) id DFC6DB952F6; Fri, 5 Jan 2007 11:33:56 +0100 (CET) Message-ID: <459E2986.8080002@andromeiberica.com> Date: Fri, 05 Jan 2007 11:33:42 +0100 From: Arnau Reply-To: arnaulist@andromeiberica.com User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Josef Springer CC: pgsql-admin@postgresql.org Subject: Re: I want to import a database from a customer References: <450FAE7A.9070408@joops.com> <459CE399.2060806@joops.com> In-Reply-To: <459CE399.2060806@joops.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/29 X-Sequence-Number: 24185 Hi Josef, > i must analyze a customer's database offline. Can i import the databse > of the customer into our PostgreSQL environment ? > What must the customer send us ? > Whats the doings for us to open it in our envioronment ? use pg_dump -o -b -Fc [database to export] > [backup file] in your customer's side (man pg_dump for details) create the database where you'll import the backup and use pg_restore -v -O -d [database] [backup file] (man pg_restore for details) -- Arnau