Postgres Pro
Downloads
Home   >   mailing lists

Re: Backup / export DB - Mailing list pgsql-general

From Matthias.Pitzl@izb.de
Subject Re: Backup / export DB
Date
Msg-id 11EC9A592C31034C88965C87AF18C2A70CFC61@m0000s61
Whole thread Raw
In response to Backup / export DB  ("Alain Roger" <raf.news@gmail.com>)
Responses Re: Backup / export DB  (Vivek Khera <vivek@khera.org>)
List pgsql-general
Tree view
Simply dump the database with pg_dump, copy the dump to the other machine and restore the dump there.
See the man pages of pg_dump how to use the tool. If you're database contains foreign keys or similar, make sure to include OIDs into the database dump.
 
-- Matthias
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Alain Roger
Sent: Friday, September 22, 2006 7:59 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Backup / export DB

Hi,

I have a database (table, stored procedures, accounts,..) on 1 computer.
for some reason i need to move this database to another computer but not in the same folder name or on the same HDD.

how can i export (and after import) all relative structure and data ?
or maybe a backup of DB is enough ?

thanks a lot,

Alain

pgsql-general by date:

Previous
From: Bo Lorentsen
Date:
Subject: Re: Replication and PITR
Next
From: "Alain Roger"
Date:
Subject: Backup roles / users