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@hotmail.com> wrote in message
news:BAY7-F891pN0sLKDAOt0001f599@hotmail.com...
> 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
>