Re: TF card for PGDATA

2022-10-08 Thread Christophe Pettus
> On Oct 8, 2022, at 17:14, Theodore M Rolle, Jr. wrote: > > What are the pros and cons of using a TF card to store data? Assuming by TF you mean Transflash, a trade name for SD cards, the bandwidth on them is not particularly spectacular. The absolute fastest is an SDUC card at ~980Mb/s,

TF card for PGDATA

2022-10-08 Thread Theodore M Rolle, Jr.
What are the pros and cons of using a TF card to store data? It seems like a good idea, because there are no moving parts, but are there other points of failure that make this a bad idea?

Re: pg_restore creates public schema?

2022-10-08 Thread Adrian Klaver
On 10/7/22 20:14, Ron wrote: On 10/7/22 15:31, Alban Hertroys wrote: Can you create an SSH tunnel to the new machine from the VM, then pipe that to an SSH connection from a machine that does have enough space to dump? Interesting.  (It's above my ssh expertise, though.) An example using