Copying a postgresql database through ssh

Question

First off, this is based on Copy a PostgreSQL database into another database. I would gladly expose my problem there, however I have not enough Karma yet to do so.

Here's my code :

sourceDB=$1
targetDB=$2

ssh mgf "createdb $targetDB"
pg_dump -C "$sourceDB" | ssh -C mySSHalias "psql $targetDB"

Here's the output :

SET
SET
SET
SET
SET
SET
ERREUR:  la base de données « mySourceDB » existe déjà
ALTER DATABASE
\connect : option de connexion « -reuse-previous » invalide

So basically my first command is creating a database with $targetDB's name, while my second command try to create a database with $sourceDB's name ?

How to restore at the other end of the pipe with a different name ?

Laurenz Albe · Accepted Answer · 2016-10-04 14:35:53Z

2

Omit the -C flag in pg_dump.
This flag causes a CREATE DATABASE statement to be added to the dump file, which is obviously not what you want.

answered Oct 4, 2016 at 14:35

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

1 Comment

Yann Over a year ago

I am so dumb... Thank you so much !

Collectives™ on Stack Overflow

Copying a postgresql database through ssh

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related