/pg_dump -U postgres -h <source host> $srcdb | /usr/local/pgsql/bin/psql -p $port -U postgres -h <destination host > $destinationdb
It will help you, i guess.
Thanks & Regards,
M Naveen Kuamr,
PostgreSQL Database Administrator,
M Naveen Kuamr,
PostgreSQL Database Administrator,
Mobile Number: +91 7755929449.
On Thu, May 28, 2015 at 11:36 PM, Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:
On May 28, 2015, at 11:58 AM, girish R G peetle <giri.anamika0@xxxxxxxxx> wrote:
>
> If pipe is used…
You’re assuming that it writes to files and writes to pipes the same way. That is not a valid assumption.
--
Scott Ribe
scott_ribe@xxxxxxxxxxxxxxxx
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
