Thread: 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
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
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-----Hi,
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
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
On Sep 22, 2006, at 3:04 AM, Matthias.Pitzl@izb.de wrote:
If you're database contains foreign keys or similar, make sure to include OIDs into the database dump.
on what basis did you make up this advice?
i have no OID's anywhere and FK's work just fine.
when you set up the new server, be sure to re-create any users you had on the old, and do the dump as the postgres superuser to ensure everything gets copied. do the restore as the superuser too to ensure all ownerships and permissions were as before as well.