Re: PostgreSQL Dump based backup using pipe

/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,

Thanks & Regards,
M Naveen Kuamr,
PostgreSQL Database Administrator,
Mobile Number: +91 7755929449.

On Thu, May 28, 2015 at 11:36 PM, Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
wrote:

> On May 28, 2015, at 11:58 AM, girish R G peetle <giri(dot)anamika0(at)gmail(dot)com>
> 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(at)elevated-dev(dot)com
> http://www.elevated-dev.com/
> https://www.linkedin.com/in/scottribe/
> (303) 722-0567 voice
>
>
>
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>