Re: postgres large database backup

> On 01 Dec 2022, at 01:19, Hannes Erven wrote: > > You could also use a filesystem that can do atomic snapshots - like ZFS. > > However, I'm wondering why none of the previous respondents mentioned it? the reason: 'cause most people are "stuck" on public clouds that does not provide that as

Re: Slot issues

> On 14 Oct 2018, at 23:10 , Andres Freund wrote: > > If you created the new basebackup using rsync, and didn't exclude > pg_replication_slot, it'll have copied the slots from the primary. And > thus needs a high enough max_replication_slots to work with them. Thanks for pointing this out, af

pg_top error reporting?

Good day, I’m running into a problem with pg_top inside a LXC container (unprivileged on ProxMox). 1) Seems the pgtop “foundry” directory isn’t working? http://ptop.projects.pgfoundry.org/ Forbidden You don't have permission to access / on this server. 2) The error is a segmentation fault, l

Re: building a server

> On 03 Des. 2017, at 23:39 , Rob Sargent wrote: > On 12/03/2017 02:15 PM, John R Pierce wrote: >> On 12/3/2017 12:47 PM, Gmail wrote: >>> So I revisited https://momjian.us/main/writings/pgsql/hw_selection.pdf >>> >>> Near the end (page 2