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"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
