ravikumar321
New Member
- Impact
- 0
I want to copy data from one PG database to another, without moving the data to my local and back to the db -
pg_dump -U postgres source_db_name | psql -U postgres target_db_name
pretty certain this pipe is moving the data across the network, to my machine and back - I am wondering if there is something I can do more akin to this with a shell session:
postgres=> cp -U postgres -S source_db_name -T target_db_name
obviously the above command is ficticious
is there any such way?
pg_dump -U postgres source_db_name | psql -U postgres target_db_name
pretty certain this pipe is moving the data across the network, to my machine and back - I am wondering if there is something I can do more akin to this with a shell session:
postgres=> cp -U postgres -S source_db_name -T target_db_name
obviously the above command is ficticious
is there any such way?
