From: | "Greg" <gh(at)san(dot)rr(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Schema backup |
Date: | 2003-10-01 02:15:05 |
Message-ID: | JMqeb.16928$T46.8515@twister.socal.rr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I also have troubles with pg_dump. I have a database called 'shipping' and
it has many tables(I populated them via a script). To dump the database I
did these steps:
su greg and then pg_dump > /tmp/greg.dmp. A file greg.dmp gets created but
it has nothing in it(0 bytes). Could you advise what was wrong, please?
Thanks in advance, Greg
""Claudio Lapidus"" <clapidus(at)hotmail(dot)com> wrote in message
news:BAY7-F891pN0sLKDAOt0001f599(at)hotmail(dot)com(dot)(dot)(dot)
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Leahy | 2003-10-01 03:48:10 | Did not find any relation named... |
Previous Message | Bruno BAGUETTE | 2003-09-30 22:04:36 | Stored procedures with variable number of args ? |