Copying postgresql local to remote database (both with password) - ERROR: option "locale" not recognized
Working with Postgres 12 / Windows 10. Trying to copy a remote database to localhost with the following command: pg_dump -C -h remotehost -p 5432 -U postgres remotedb | psql -h localhost -p 5432 -U postgres localdb CMD requests for password 2x. Password for user postgres: Password: I input localhost first, hit ENTER, then input remotehost and hit ENTER again