Ygthkb

Maybe pigeonhole problem?

What does an unprocessed RAW file look like?

Equivalent of "illegal" for violating civil law

What species should be used for storage of human minds?

Are all power cords made equal?

Why is Shelob considered evil?

Identical projects by students at two different colleges: still plagiarism?

Can you say "leftside right"?

Where does documentation like business and software requirement spec docs fit in an agile project?

How bad is a Computer Science course that doesn't teach Design Patterns?

Given a total recursive function, can you always compute its fixed-point?

Why does this relation fail symmetry and transitivity properties?

Critique vs nitpicking

Sensor logger for Raspberry Pi in a stratospheric probe

Isn't a semicolon (';') needed after a function declaration in C++?

Can I travel from country A to country B to country C without going back to country A?

'DataFrame' object has no attribute 'to_dataframe'

Specific list manipulation

How can I handle players killing my NPC outside of combat?

Did ancient Germans take pride in leaving the land untouched?

How to not let the Identify spell spoil everything?

Trying to detect if any checked values contains a specific string

Stuck to wireframe

Rigorous justification for non-relativistic QM perturbation theory assumptions?

Postgres migration local to remote, issue with terminal command

Export remote Postgres table to CSV file on local machineAuthentification failure for PostgreSQL server (9.3)Restore postgres in command line on ubuntu failedpg_restore: [archiver (db)] could not execute query: ERROR: schema “public” already existsI Need Help Setting Up Roles and Passwords in PostgreSQLCan I grant privileges to a Postgres user on all schemas belonging to a database with one command or script?Working of postgres remote connectionpg_ctl won't start postgrespostgres migration sequence issueTable migration to a different remote

0

I'm trying to use the first answer here to transfer a local postgre db to elephantSQL

https://stackoverflow.com/questions/1237725/copying-postgresql-database-to-another-server

The command given is: pg_dump -C -h localhost -U localuser dbname | psql -h remotehost -U remoteuser dbname

I have no chance to enter a password in the following:

owner@G700:~$ pg_dump -C -h localhost -U rep1 repdb1 | psql -h baasu.db.elephantsql.com -U bgpacbpe bgpacbpe

Password: 

Password for user bgpacbpe: pg_dump: [archiver (db)] connection to database "repdb1" failed: fe_sendauth: no password supplied

How can I resolve this?

If there is a less error prone way to do this I would also like to try that.

owner@G700:~$ psql --version

psql (PostgreSQL) 10.6 (Ubuntu 10.6-0ubuntu0.18.04.1)

postgresql psql

share|improve this question

asked 10 mins ago

Sean DezoysaSean Dezoysa

1062

add a comment | 

0

I'm trying to use the first answer here to transfer a local postgre db to elephantSQL

https://stackoverflow.com/questions/1237725/copying-postgresql-database-to-another-server

The command given is: pg_dump -C -h localhost -U localuser dbname | psql -h remotehost -U remoteuser dbname

I have no chance to enter a password in the following:

owner@G700:~$ pg_dump -C -h localhost -U rep1 repdb1 | psql -h baasu.db.elephantsql.com -U bgpacbpe bgpacbpe

Password: 

Password for user bgpacbpe: pg_dump: [archiver (db)] connection to database "repdb1" failed: fe_sendauth: no password supplied

How can I resolve this?

If there is a less error prone way to do this I would also like to try that.

owner@G700:~$ psql --version

psql (PostgreSQL) 10.6 (Ubuntu 10.6-0ubuntu0.18.04.1)

postgresql psql

share|improve this question

asked 10 mins ago

Sean DezoysaSean Dezoysa

1062

add a comment | 

I'm trying to use the first answer here to transfer a local postgre db to elephantSQL

https://stackoverflow.com/questions/1237725/copying-postgresql-database-to-another-server

The command given is: pg_dump -C -h localhost -U localuser dbname | psql -h remotehost -U remoteuser dbname

I have no chance to enter a password in the following:

owner@G700:~$ pg_dump -C -h localhost -U rep1 repdb1 | psql -h baasu.db.elephantsql.com -U bgpacbpe bgpacbpe

Password: 

Password for user bgpacbpe: pg_dump: [archiver (db)] connection to database "repdb1" failed: fe_sendauth: no password supplied

How can I resolve this?

If there is a less error prone way to do this I would also like to try that.

owner@G700:~$ psql --version

psql (PostgreSQL) 10.6 (Ubuntu 10.6-0ubuntu0.18.04.1)

postgresql psql

share|improve this question

asked 10 mins ago

Sean DezoysaSean Dezoysa

1062

owner@G700:~$ pg_dump -C -h localhost -U rep1 repdb1 | psql -h baasu.db.elephantsql.com -U bgpacbpe bgpacbpe

Password: 

Password for user bgpacbpe: pg_dump: [archiver (db)] connection to database "repdb1" failed: fe_sendauth: no password supplied

owner@G700:~$ psql --version

psql (PostgreSQL) 10.6 (Ubuntu 10.6-0ubuntu0.18.04.1)

share|improve this question

asked 10 mins ago

Sean DezoysaSean Dezoysa

1062

share|improve this question

asked 10 mins ago

Sean DezoysaSean Dezoysa

1062

asked 10 mins ago

Sean DezoysaSean Dezoysa

1062

asked 10 mins ago

Sean DezoysaSean Dezoysa

1062