Skip site navigation (1) Skip section navigation (2)

Re: Schema backup

From: Jeremiah Elliott <jelliott(at)artcobell(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Schema backup
Date: 2003-09-26 19:48:55
Message-ID: 200309261448.55081.jelliott@artcobell.com (view raw or flat)
Thread:
Lists: pgsql-general
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(at)postgresql(dot)org so that your
>       message can get through to the mailing list cleanly


In response to

pgsql-general by date

Next:From: Bruce MomjianDate: 2003-09-26 19:57:17
Subject: Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)
Previous:From: Bruce MomjianDate: 2003-09-26 19:44:08
Subject: Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group