Re: how to replicate database

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 <olly@lfix.co.uk> 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
> Oliver.Elphick@lfix.co.uk
> 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