Greetings,
* Haroldo Kerry (hke...@callix.com.br) wrote:
> The bottleneck at dump is CPU (a single one, on a 44 thread server), as we
> are using the -Fc option, that does not allow multiple jobs.
> We tried some time ago to use the --jobs option of pg_dump but it was
> slower, even with more thre
Jeff,
We are using the following command to dump the database:
docker exec pg-1 bash -c 'pg_dump -v -U postgres -Fc
--file=/var/lib/postgresql/backup/sc2-ssd.bkp smartcenter2_prod' 2>>
/var/log/sc2-bkp-ssd.log &
The bottleneck at dump is CPU (a single one, on a 44 thread server), as we
are using
On 5/30/19 5:08 PM, Haroldo Kerry wrote:
> Hello,
>
> We are migrating our PostgreSQL 9.6.10 database (with streaming
> replication active) to a faster disk array.
> We are using this opportunity to enable checksums,
I would stay away from performing 2 big changes in one go.
regards,
fabio p
> 2019年5月31日(金) 6:53 Haroldo Kerry :
>>> On Thu, May 30, 2019 at 12:54 PM Steven Winfield
>>> wrote:
>>
>> >Has anyone been through this type of problem?
>> >
>>
>> You could set up a new, empty db (with checksums enabled, etc.) on the
>> new hardware and then use logical replication
On Thu, May 30, 2019 at 11:08 AM Haroldo Kerry wrote:
> Hello,
>
> We are migrating our PostgreSQL 9.6.10 database (with streaming
> replication active) to a faster disk array.
> We are using this opportunity to enable checksums, so we will have to do a
> full backup-restore.
> The database size
Hello Steven,
Unfortunately logical replication is a pg10+ feature. One more reason for
upgrading from 9.6.10 :-)
Regards,
Haroldo Kerry
On Thu, May 30, 2019 at 1:23 PM Haroldo Kerry wrote:
> Hello Steven,
> Thanks a lot for the idea, it had not thought about it.
> @Joshua @Tomas, thanks for cl
Hello Steven,
Thanks a lot for the idea, it had not thought about it.
@Joshua @Tomas, thanks for clarifying why it doesn't work!
Best regards,
Haroldo Kerry
On Thu, May 30, 2019 at 12:54 PM Steven Winfield <
steven.winfi...@cantabcapital.com> wrote:
> >Has anyone been through this type of proble
>Has anyone been through this type of problem?
>
You could set up a new, empty db (with checksums enabled, etc.) on the new
hardware and then use logical replication to sync across all the data from the
existing cluster.
(This logical replica could be doing binary replication to hot standbys too
On Thu, May 30, 2019 at 12:08:04PM -0300, Haroldo Kerry wrote:
Hello,
We are migrating our PostgreSQL 9.6.10 database (with streaming replication
active) to a faster disk array.
We are using this opportunity to enable checksums, so we will have to do a
full backup-restore.
The database size is a
Hello,
We are migrating our PostgreSQL 9.6.10 database (with streaming replication
active) to a faster disk array.
We are using this opportunity to enable checksums, so we will have to do a
full backup-restore.
The database size is about 500GB, it takes about 2h:30min for a full
backup, and then a
10 matches
Mail list logo
