On Tuesday 30 September 2003 09:15 pm, Greg wrote: > 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 >
You forgot to tell pg_dump the name of the database. Try: pg_dump shipping > /tmp/greg.dmp Or, for a gzipped backup: pg_dump shipping | gzip -c > /tmp/greg.dmp.gz Best of luck, Andrew Gould ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])