On 26/03/2008, Tri Quach <[EMAIL PROTECTED]> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to