Re: How to validate restore of backup?

Hi, Adrian. The largest one is 8 GB after compression. I have a window of 8 hours to handle 30 GB total of backup at various sizes. On Thu, Aug 22, 2024, 11:36 AM Adrian Klaver wrote: > On 8/22/24 04:06, Vince McMahon wrote: > > Hi, > > > > I have some questions Whe

How to validate restore of backup?

Hi, I have some questions When doing pg_restore of backup of a database to a NEW server. Is there a way to ensure the data integrity is in tact, and user ID and access works liked how it was in the old server? How to properly handle the materialized views when backing up and restoring? Thanks.

Re: Impact from removal of pgadmin4

Thanks for the deep insight. You are better than OpenChat gpt 4. Happy Friday. On Fri, Aug 2, 2024, 8:53 AM Ron Johnson wrote: > On Fri, Aug 2, 2024 at 3:57 AM Vince McMahon < > sippingonesandze...@gmail.com> wrote: > >> In windows, when the pgadmin4 is removed, will it

Impact from removal of pgadmin4

In windows, when the pgadmin4 is removed, will it remove the libraries from that windows? Basically, I have other database applications installed to get and to set data into postgres db. Will removing of pgadmin4 remove the odbc, jdbc drivers these application use? Thanks.

Is there psql cluster or replication

Is there cluster on postgres? Or, there is replication, not cluster. If there is active/passive cluster or active/active , may I have the steps to configure them?

Re: Explain returns different number of rows

Thanks for the clarification, Peter. On Sat, Oct 22, 2022, 05:32 Peter J. Holzer wrote: > On 2022-10-20 09:56:23 -0700, Christophe Pettus wrote: > > On Oct 20, 2022, at 09:52, Vince McMahon > wrote: > > > The number of rows are different. > > > > This is

Re: Does standalone postfrsql have autogrowth/ manual growth on table space?

Thanks. I guess it is time for vacuum. 😂 On Thu, Oct 20, 2022, 13:34 Christophe Pettus wrote: > > > > On Oct 20, 2022, at 10:29, Ron wrote: > > There's no pre-allocation in Postgresql. > > This is correct in that you can't say "please allocate 3GB for this table > for me now." The number of p

Does standalone postfrsql have autogrowth/ manual growth on table space?

In other databases, there is a way to preallocate the table space to allow bulk loading of data in a well packed and continuous space. Does psql have that auto/manual growth?

Explain returns different number of rows

I did get reply so I am trying again. I executed the following statements 3 times > explain(analyze, buffet) select * from table1 > > The number of rows are different. Is the table corrupted? How to confirm > and how to fix it? >