Re: is there an immutable function to switch from date to character?

Sorry I pasted in the wrong code, I had wanted a column with the character version of the date (ie., -Mon-DD). Steve Baldwin's hack pointed me in the right direction. Here is the example: create temporary table junk as select now()::date as evtdate; SELECT 1 alter table junk add column charda

Re: is there an immutable function to switch from date to character?

Celia McInnis writes: > create temporary table junk as select now()::date as evtdate; > alter table junk add column chardate text GENERATED ALWAYS AS > (to_char(evtdate,'-Mon-DD')) STORED; > ERROR: generation expression is not immutable Probably not; I think all the available conversion fun

Sql scripts execution

Hi All, What is the generally used open source solution for deploying dml and ddl scripts for monthly release on postgres rds? Can we use github actions to perform the same Thanks, Arun

Re: is there an immutable function to switch from date to character?

On Thu, Apr 25, 2024 at 7:31 AM Celia McInnis wrote: > create temporary table junk as select now()::date as evtdate; > > alter table junk add column chardate text GENERATED ALWAYS AS > (to_char(evtdate,'-Mon-DD')) STORED; > > ERROR: generation expression is not immutable > > Maybe this is a

is there an immutable function to switch from date to character?

create temporary table junk as select now()::date as evtdate; alter table junk add column chardate text GENERATED ALWAYS AS (to_char(evtdate,'-Mon-DD')) STORED; ERROR: generation expression is not immutable

Re: Backup_Long Running

On 4/24/24 00:03, jaya kumar wrote: Hi Team, Production database Backup is running very long hours. Any option to reduce backup time? Kindly advise me. Hardware specifications? Network specifications? The actual pg_basebackup command used? Server(s) user load? DB size: 793 GB We are ta

Re: Backup_Long Running

PgBackRest is in the PGDG repositories (RHEL & Debian). The documentation is thorough, and discoverable via Google, On Wed, Apr 24, 2024 at 8:30 AM jaya kumar wrote: > Thanks for your update. Can you have any link or document to configure L0 > & L1 backup using pgbackrest tool. Also share the p

Re: Backup_Long Running

Thanks for your update. Can you have any link or document to configure L0 & L1 backup using pgbackrest tool. Also share the pgbackrest installation method. On Wed, Apr 24, 2024 at 2:50 PM Vijaykumar Jain < vijaykumarjain.git...@gmail.com> wrote: > > On Wed, Apr 24, 2024, 12:33 PM jaya kumar wrot

Re: Backup_Long Running

On Wed, Apr 24, 2024, 12:33 PM jaya kumar wrote: > Hi Team, > > > > Production database Backup is running very long hours. Any option to > reduce backup time? Kindly advise me. > > > > DB size: 793 GB > > > > We are taking pg_basebackup backup. > > do you see network saturation, io saturation ? g

Backup_Long Running

Hi Team, Production database Backup is running very long hours. Any option to reduce backup time? Kindly advise me. DB size: 793 GB We are taking pg_basebackup backup. Backup File size=613G Backup Running Duration: 8 Hours -- Thanks & Regards, Jayakumar.S +91-9840864439.