Re: I want to import a database from a customer

From: Arnau <arnaulist(at)andromeiberica(dot)com>
To: Josef Springer <Josef(dot)Springer(at)joops(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: I want to import a database from a customer
Date: 2007-01-05 10:33:42
Message-ID: 459E2986.8080002@andromeiberica.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Markus Schiltknecht 2007-01-05 10:42:28 Re: Replication
Previous Message Ming 2007-01-05 01:15:13 Re: Autovacuum not running in 8.2.0