On 26/03/2008, Tri Quach <tquach@xxxxxxxxx> wrote: > Hi Andrej, Hi Tri! > I am running on Linux, Red Hat 3. > I have hard time to use pg_dump command. Can you give me the syntax of > pgdump? Not a syntax-problem; to use pg_dumpall you need to be the postgres (superuser). su - postgres pg_dumpall > dbfile If you'd rather run it individually for each DB become the user who owns the respective DB. > Thank you for your help. > > Tri. Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general