PostgreSQL schema migration?

Question

I've local PostgreSQL database with tables, constraints, relations etc.

How can I migrate it to a production server?

@VaoTsun I get following error while using pg_dump: pg_dump: server version: 9.6.5; pg_dump version: 9.5.10 pg_dump: aborting because of server version mismatch — Daulet Nurgali
– Daulet Nurgali, Commented Feb 8, 2018 at 16:03
@a_horse_with_no_name liquibase or flyway is good approach, but I'am at the end of developing my app. These tools must be used from the start of developing an app (put each sql script into file and store them ) — Daulet Nurgali
– Daulet Nurgali, Commented Feb 8, 2018 at 16:05
@DauletNurgali you try to use old pg_dump with new server - while you should do the opposite. try locate bin/pg_dump to find pg_dump for 9.6 version — Vao Tsun
– Vao Tsun, Commented Feb 8, 2018 at 16:13

A l w a y s S u n n y · Accepted Answer · 2018-02-08 15:08:33Z

1

From pg_dump manual page you can try with pg_dump and psql, you can also check other flags for data, schema or table specific tasks. I personally sometime do this kind of job using Navicat or pgAdmin client.

To dump a database called mydb into a SQL-script file:

$ pg_dump mydb > db.sql

To reload such a script into a (freshly created) database named newdb:

$ psql -d newdb -f db.sql

edited Feb 8, 2018 at 15:08

answered Feb 8, 2018 at 15:03

A l w a y s S u n n y

38.8k9 gold badges68 silver badges120 bronze badges

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

Comments

sindhu_sp · Accepted Answer · 2018-02-08 14:59:43Z

1

Try using flyway. It does exactly this. Dump your schema into an sql file and migrate using flyway.

answered Feb 8, 2018 at 14:59

sindhu_sp

7595 silver badges12 bronze badges

Collectives™ on Stack Overflow

PostgreSQL schema migration?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related