| From: | "Claudio Lapidus" <clapidus(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Schema backup |
| Date: | 2003-09-26 19:37:16 |
| Message-ID: | BAY7-F891pN0sLKDAOt0001f599@hotmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello all
I need to transfer a database installation from one host to another. I need
to dump all users, databases, schemas, stored procedures, triggers, etc. but
no actual data at all. What I try to achieve is a fresh clone ready to run.
I tried pg_dump -s and pg_dumpall, but somewhere I'm missing something, so:
what is the procedure to dump all database structure alone, and what is the
proper reload procedure?
TIA
cl.
_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-09-26 19:39:15 | Re: initdb failure (was Re: [GENERAL] sequence's plpgsql) |
| Previous Message | Bruce Momjian | 2003-09-26 19:35:33 | Re: Conditional row grained replication with DBMirror |