Is it possible to restore postgres DB to local liquibase

Question

I am new to liquibase. The 'backend' app runs locally with some basic changelog files.

I would like to get some test data from a server using pg_dump and pg_restore, and restore it to my local postgres DB.

How do I get that to work with liduibase? If that is not a good option, what would be a better option?

Community · Accepted Answer · 2017-05-23 11:53:49Z

2

I found out a good way to export an entire database data into csv, is to use the below pg function, configure changelog to load the csv files, and map column headers if records have a lot of null data.

Create one csv file per table: Export Database into CSV file
Add changelog LoadData (the file path is relative to src/main/resources):

for example:

<changeSet author="programmer" id="mock_user_data">
    <loadData tableName="user_data" file="db/csv/public.user_data.csv" separator=";">  
        <column name="default_user" type="BOOLEAN"/>
        <column name="username" type="STRING"/>
        <column name="store_id" type="NUMERIC"/>                  
    </loadData>   </changeSet>

If you get error messages caused by null values, look at your csv file, insert NULL in between delimiters, and make sure the problematic column name is mapped in the loadData section.

edited May 23, 2017 at 11:53

CommunityBot

11 silver badge

answered Mar 19, 2017 at 5:53

Annie C

8142 gold badges14 silver badges32 bronze badges

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

Comments

austin · Accepted Answer · 2017-03-16 23:55:53Z

1

you could add a changelog to load data
Load data

you could possibly export from your DB as a csv and load with liquibase

answered Mar 16, 2017 at 23:55

austin

1,1711 gold badge15 silver badges33 bronze badges

Collectives™ on Stack Overflow

Is it possible to restore postgres DB to local liquibase

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related