Data Only from One Server to Another in Postgres SQL

Question

I see that there are solutions for copying tables from one Postgres SQL server to another. But I need to transfer ONLY DATA from one server to another. I noticed the following command:

pg_dump -C -h localhost -U localuser dbname | psql -h remotehost -U remoteuser dbname

But I do not want to copy anything else other than data. How can I do that?

Another question. I have multiple tables on Server A. If I want to copy Data from all tables on Server A to Server B, how can I do that? Thank you.

richyen · Accepted Answer · 2022-07-15 20:54:16Z

2

To copy only the data with pg_dump, you can use the -a flag (or the long form would be --data-only):

pg_dump -C --data-only -h localhost -U localuser dbname | psql -h remotehost -U remoteuser dbname

answered Jul 15, 2022 at 20:54

richyen

10.3k4 gold badges18 silver badges36 bronze badges

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

2 Comments

DS89 Over a year ago

Thank you! Will that copy data from all tables? If I want to deselect a table, do we have that option? For example, if there are 3 tables: tab1, tab2, tab3, can I deselect tab2? I really appreciate your help.

richyen Over a year ago

yes, you can use --exclude-table or the -T option. You can find more information about pg_dump here: postgresql.org/docs/current/app-pgdump.html

Collectives™ on Stack Overflow

Data Only from One Server to Another in Postgres SQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related