| From: | Martin Marques <martin(dot)marques(at)2ndquadrant(dot)com> |
|---|---|
| To: | Edson Carlos Ericksson Richter <richter(at)simkorp(dot)com(dot)br>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Does PostgreSQL check database integrity at startup? |
| Date: | 2017-12-26 22:42:58 |
| Message-ID: | e3d09b89-17ba-8638-084a-25eab2abc7ba@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
El 26/12/17 a las 14:46, Edson Carlos Ericksson Richter escribió:
>
> Usually, or by "pg_basebackup" or by "rsync" as described in PostgreSQL
> Wiki.
> Right now, I'm doing via pg_basebackup.
> Nothing extraordinary.
>
> When using rsync:
>
> rsync -e "ssh -2 -C -p slave_ssh_port" --progress --partial -az
> /pgsql/9.6/master_data_folder/*
> superuser_name(at)$slave_host:/home/pgsql/9.6/slave_data_folder/ --exclude
> postmaster.pid --exclude postgresql.conf --exclude pg_log
You don't say so anywhere, but I suspect you run the rsync between a
pg_start_backup() and pg_stop_backup(), right?
That is the way it's described in the wiki.
Regards,
--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2017-12-26 23:27:05 | Re: Deadlock between concurrent index builds on different tables |
| Previous Message | rob stone | 2017-12-26 22:11:56 | Re: Does PostgreSQL check database integrity at startup? |