i am having problem of running pg_dump. i am using
winXP home here. postgreSQL requested me to re-install
the application again as can't found cygz.dll file.

do u have any idea?

--- Oliver Elphick <[EMAIL PROTECTED]> wrote:
> On Thu, 2003-09-11 at 09:15, Caroline Yong wrote:
> > Is there a way to replicate one-off(a copy of
> > duplicate) of an existing Postgres database.
> 
> pg_dump mydatabase > some_file
> 
> move some_file to another machine (or to duplicate
> the database on the
> same server, use a new database name below)
> 
> createdb mydatabase
> psql -d mydatabase < some_file
> 
> -- 
> Oliver Elphick                               
> [EMAIL PROTECTED]
> Isle of Wight, UK                            
> http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A
> 614D 4C34 3E1D 0C1C
>                 
> ========================================
>      "I am crucified with Christ; nevertheless I
> live; yet 
>       not I, but Christ liveth in me; and the life
> which I 
>       now live in the flesh I live by the faith of
> the Son 
>       of God, who loved me, and gave himself for
> me."       
>                                          Galatians
> 2:20 
> 


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to