By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,176 Members | 984 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,176 IT Pros & Developers. It's quick & easy.

how to replicate database

P: n/a
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*******@postgresql.org

Nov 11 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Nov 11 '05 #2

P: n/a
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.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
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

Nov 11 '05 #3

P: n/a

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

Nov 11 '05 #4

P: n/a

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

Nov 11 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.