Re: PostgreSQL Dump based backup using pipe

Поиск
Список
Период
Сортировка
От naveen kumar
Тема Re: PostgreSQL Dump based backup using pipe
Дата
Msg-id CADye41JvtsHDrV0=b4uuYhmjqnQ4BRxJ1ubm_2iYNQKbo5g0VQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL Dump based backup using pipe  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список pgsql-admin
Дерево обсуждения

/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 по дате отправления:

Предыдущее
От: John Scalia
Дата:
Сообщение: Re: Trying to change the owner of some tables
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Trying to change the owner of some tables