Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL Dump based backup using pipe - Mailing list pgsql-admin

From naveen kumar
Subject Re: PostgreSQL Dump based backup using pipe
Date
Msg-id CADye41JvtsHDrV0=b4uuYhmjqnQ4BRxJ1ubm_2iYNQKbo5g0VQ@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Dump based backup using pipe  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view

/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@elevated-dev.com> wrote:
On May 28, 2015, at 11:58 AM, girish R G peetle <giri.anamika0@gmail.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@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice







--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Re: Trying to change the owner of some tables
Next
From: Alvaro Herrera
Date:
Subject: Re: Trying to change the owner of some tables