pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
I want to import a database from a customer
3+ messages / 3 participants
[nested] [flat]

* I want to import a database from a customer
@ 2007-01-04 11:23 Josef Springer <Josef.Springer@joops.com>
  2007-01-04 12:52 ` Re: I want to import a database from a customer Shoaib Mir <shoaibmir@gmail.com>
  2007-01-05 10:33 ` Re: I want to import a database from a customer Arnau <arnaulist@andromeiberica.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Josef Springer @ 2007-01-04 11:23 UTC (permalink / raw)
  To: pgsql-admin

Hi folks,

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 ?

Josef






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: I want to import a database from a customer
  2007-01-04 11:23 I want to import a database from a customer Josef Springer <Josef.Springer@joops.com>
@ 2007-01-04 12:52 ` Shoaib Mir <shoaibmir@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Shoaib Mir @ 2007-01-04 12:52 UTC (permalink / raw)
  To: Josef Springer <Josef.Springer@joops.com>; +Cc: pgsql-admin

Use pg_dump/pg_dump utility to take the db dump and then you can restore it
using psql or pg_restore at your end.

------------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 1/4/07, Josef Springer <Josef.Springer@joops.com> wrote:
>
> Hi folks,
>
> 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 ?
>
> Josef
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: I want to import a database from a customer
  2007-01-04 11:23 I want to import a database from a customer Josef Springer <Josef.Springer@joops.com>
@ 2007-01-05 10:33 ` Arnau <arnaulist@andromeiberica.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Arnau @ 2007-01-05 10:33 UTC (permalink / raw)
  To: Josef Springer <Josef.Springer@joops.com>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-01-05 10:33 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-04 11:23 I want to import a database from a customer Josef Springer <Josef.Springer@joops.com>
2007-01-04 12:52 ` Shoaib Mir <shoaibmir@gmail.com>
2007-01-05 10:33 ` Arnau <arnaulist@andromeiberica.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox