how to replicate database

[Caroline Yong]

Is there a way to replicate one-off(a copy of
duplicate) of an existing Postgres database.

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

[Oliver Elphick]

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 Ol************@ 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Caroline Yong]

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 <ol**@lfix.co.u k> 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
Ol************@ 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

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

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

[Nigel J. Andrews]

On Thu, 11 Sep 2003, Caroline Yong wrote:

Is there a way to replicate one-off(a copy of
duplicate) of an existing Postgres database.

regards,
caroline

There's obviously the pg_dump utility (or pg_dumpall which also gets all the
global info like db users). You could also try:

createdb -T old-db new-db

as an interesting exercise, if you just want another copy in the same
cluster. I've not done that myself but I don't see why it wouldn't work,
someone else might know differently.

--
Nigel Andrews

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Nigel J. Andrews]

On Thu, 11 Sep 2003, Caroline Yong wrote:

Is there a way to replicate one-off(a copy of
duplicate) of an existing Postgres database.

regards,
caroline

There's obviously the pg_dump utility (or pg_dumpall which also gets all the
global info like db users). You could also try:

createdb -T old-db new-db

as an interesting exercise, if you just want another copy in the same
cluster. I've not done that myself but I don't see why it wouldn't work,
someone else might know differently.

--
Nigel Andrews

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match