From: | Matthias(dot)Pitzl(at)izb(dot)de |
---|---|
To: | raf(dot)news(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Backup / export DB |
Date: | 2006-09-22 07:04:50 |
Message-ID: | 11EC9A592C31034C88965C87AF18C2A70CFC61@m0000s61 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Alain Roger
Sent: Friday, September 22, 2006 7:59 AM
To: pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alain Roger | 2006-09-22 07:20:23 | Backup roles / users |
Previous Message | surabhi.ahuja | 2006-09-22 06:48:19 | ERROR: index "patient_pkey" is not a btree |