How do I move a database from one server to another in PgSQL?

Question

I am trying to move a database from my old server to a new server. Any help would be appreciated.

The right answer to this question depends a lot of the size of your database. but dumprestore is most like the correct answer. — xenoterracide
– xenoterracide, Commented Aug 17, 2010 at 3:21
What is the size of your database? How big downtime window you can have? — vyegorov
– vyegorov, Commented May 5, 2012 at 8:24

Frank Heikens · Accepted Answer · 2010-08-17 06:12:53Z

14

Just pipe a dump from the old server into the new one:

pg_dump -h 172.26.76.100 -p 5432 -U username your_db | psql -h localhost -p 5432 -U username your_db

Replace the ip addresses and there you go. If you're using different versions of PostgreSQL, make sure you use pg_dump and psql from the latest version.

answered Aug 17, 2010 at 6:12

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mikelikespie Over a year ago

pg_dumpall will get everything. He should make sure he uses roles that are superusers to get everything.

Kees de Kooter · Accepted Answer · 2010-08-17 02:24:50Z

2

Dump it on the first server and restore it on the second, using either the command line tools or something loke pgAdmin.

answered Aug 17, 2010 at 2:24

Kees de Kooter

7,2135 gold badges42 silver badges47 bronze badges

Collectives™ on Stack Overflow

How do I move a database from one server to another in PgSQL?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related