Re: Schema backup

On Friday 26 September 2003 14:37, Claudio Lapidus wrote:
 pg_dump -s -Fp -c -f <file> <databse>
is what i use

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly