Hi Amit,
El lun, 22 ene 2024 18:44, Amit Sharma escribió:
> Hi,
>
> We are building new VMs for PostgreSQL v15 on RHEL 8.x For a large
> database of 15TB-20TB.
>
> I would like to know from the experts that is it a good idea to create
> LVMs to manage storage for the database?
>
> Or are there
On 1/22/24 19:11, Siraj G wrote:
Hello!
I would like to know how we can backup certain months old data from
PgSQL and then delete it. The intent is to backup everything that is
older than 2 quarters to a blob storage and delete it, to improve
performance and reduce billing.
1) Postgres
On Mon, Jan 22, 2024 at 10:12 PM Siraj G wrote:
> Hello!
>
> I would like to know how we can backup certain months old data from PgSQL
>
Use the COPY command.
> and then delete it.
>
That would depend on how many records, how big the records are, and if
there's index support on the "date"
Hello!
I would like to know how we can backup certain months old data from PgSQL
and then delete it. The intent is to backup everything that is older than 2
quarters to a blob storage and delete it, to improve performance and reduce
billing.
Regards
Siraj
On Mon, Jan 22, 2024 at 6:40 PM Rob Sargent wrote:
> On 1/17/24 16:25, Jim Nasby wrote:
>
> On 1/16/24 6:41 PM, Rob Sargent wrote:
>
> On 1/16/24 17:39, Jim Nasby wrote:
>
> On 1/16/24 4:57 PM, Rob Sargent wrote:
>
> Or perhaps you have to beef the sed up to use word boundaries just
> in
On 1/17/24 16:25, Jim Nasby wrote:
On 1/16/24 6:41 PM, Rob Sargent wrote:
On 1/16/24 17:39, Jim Nasby wrote:
On 1/16/24 4:57 PM, Rob Sargent wrote:
Or perhaps you have to beef the sed up to use word boundaries
just
in case.
I'm not a Java web developer...
You need to adjust you
On Wed, Jan 17, 2024 at 1:46 PM Atul Kumar wrote:
> Hi,
>
> I am not able to find any solution to list all schemas in all databases at
> once, to check the structure of the whole cluster.
>
> As I need to give a few privileges to a user to all databases, their
> schemas and schemas' objects
On 1/16/24 6:41 PM, Rob Sargent wrote:
On 1/16/24 17:39, Jim Nasby wrote:
On 1/16/24 4:57 PM, Rob Sargent wrote:
Or perhaps you have to beef the sed up to use word boundaries just
in case.
I'm not a Java web developer...
You need to adjust you glasses if that's what you see me
On 1/17/24 12:46 PM, Atul Kumar wrote:
Hi,
I am not able to find any solution to list all schemas in all databases
at once, to check the structure of the whole cluster.
Easiest way to do this is `pg_dumpall --schema-only`.
--
Jim Nasby, Data Architect, Austin TX
Hi,
We are building new VMs for PostgreSQL v15 on RHEL 8.x For a large database
of 15TB-20TB.
I would like to know from the experts that is it a good idea to create LVMs
to manage storage for the database?
Or are there any other better options/tools for disk groups in PostgreSQL,
similar to ASM
10 matches
Mail list logo
