Search Postgresql Archives

Re: Need help to migrate pqSQL db 8.0.3 to 8.2.6

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux