Re: Display Bytea field

Maybe tools like DBeaver can help? It has a free trial period. Andy Hartman escribió: could it be done using Powershell? 

Re: Display Bytea field

On 1/9/25 12:17, Andy Hartman wrote: How thru a simple query can I make sure data matches and I can display it What you are facing: 1) Bytea stores binary strings in the formats specified here: https://www.postgresql.org/docs/current/datatype-binary.html 2) The database has no 'knowledge' of

Re: Unexpected results from a query with UNION ALL

Thanks for the update. Actually I was able to rewrite the query to get rid of the union. But anyway it would be good to have this issue handled somehow, it's tricky and it was hard to spot and reproduce. ср, 8 січ. 2025 р. о 19:01 Tom Lane пише: > I wrote: > > Andrey writes: > >> ... but I woul

Parameter - shared_memory_size

Hello team, I am trying to understand the parameter shared_memory_size. It is a static parameter that reports the size of the shared memory area. Does that imply that the value may change depending on the memory used by the server? Regards, Jayadevan

Alter table fast

Hello, It's postgres version 16.1, we want to convert an existing column data type from integer to numeric and it's taking a long time. The size of the table is ~50GB and the table has ~150million rows in it and it's not partitioned. We tried running the direct alter and it's going beyond hours, so

Re: Alter table fast

On Thu, Jan 9, 2025 at 11:25 AM veem v wrote: > Hello, > It's postgres version 16.1, we want to convert an existing column data > type from integer to numeric and it's taking a long time. The size of the > table is ~50GB and the table has ~150million rows in it and it's not > partitioned. We trie

Re: recovery error while running any statement

On Thu, Jan 9, 2025 at 11:42 AM yudhi s wrote: > Hello Experts, > It's postgres aurora version 16. While running the ALTER command on any > object we see an error "*Only RowExclusiveLock or less can be acquired on > database objects during recovery*". If I run any DML it gives an error > stating

Re: recovery error while running any statement

On 1/9/25 08:42, yudhi s wrote: Hello Experts, It's postgres aurora version 16. While  running the ALTER command on any object we see an error "/Only RowExclusiveLock or less can be acquired on database objects during recovery/". If I run any DML it gives an error stating '/cannot execute UPDA

Re: recovery error while running any statement

Yes , it's a cluster aurora global database. I am a bit new to this. Can you please explain a bit more, what must be the reason and what should we do to make it back online to serve the queries? It's a non-prod though. On Thu, Jan 9, 2025 at 10:19 PM Ron Johnson wrote: > On Thu, Jan 9, 2025 at 1

Re: recovery error while running any statement

On Thu, Jan 9, 2025 at 10:21 PM Adrian Klaver wrote: > On 1/9/25 08:42, yudhi s wrote: > > Hello Experts, > > It's postgres aurora version 16. While running the ALTER command on any > > object we see an error "/Only RowExclusiveLock or less can be acquired > > on database objects during recovery

recovery error while running any statement

Hello Experts, It's postgres aurora version 16. While running the ALTER command on any object we see an error "*Only RowExclusiveLock or less can be acquired on database objects during recovery*". If I run any DML it gives an error stating '*cannot execute UPDATE in a read-only transaction*' , the

Re: recovery error while running any statement

On 1/9/25 09:01, yudhi s wrote: On Thu, Jan 9, 2025 at 10:21 PM Adrian Klaver > wrote: On 1/9/25 08:42, yudhi s wrote: > Hello Experts, > It's postgres aurora version 16. While  running the ALTER command on any > object we see an error "

Re: Issue with Password Authentication for Pgpool

assuming you are implementing kubernetes kubectl exec -it $(kubectl get pods -l app.kubernetes.io/component=pgpool,app.kubernetes.io/name=postgresql-ha -o jsonpath='{.items[0].metadata.name}') -- pg_md5 -m --config-file="/opt/bitnami/pgpool/conf/pgpool.conf" -u "foo" "bar" //cat out pgpool af

Re: recovery error while running any statement

On Thu, Jan 9, 2025 at 12:01 PM yudhi s wrote: > > On Thu, Jan 9, 2025 at 10:21 PM Adrian Klaver > wrote: > >> On 1/9/25 08:42, yudhi s wrote: >> > Hello Experts, >> > It's postgres aurora version 16. While running the ALTER command on >> any >> > object we see an error "/Only RowExclusiveLock

Re: Alter table fast

Am 09.01.25 um 20:17 schrieb veem v: Out of curiosity, why NUMERIC(15,0) instead of BIGINT? It's for aligning the database column types to the data model and it's happening across all the upstream downstream systems. I was thinking if this can be made faster with the single line alter statemen

Re: Display Bytea field

How thru a simple query can I make sure data matches and I can display it On Thu, Jan 9, 2025 at 3:16 PM Andy Hartman wrote: > I have migrated over a Table from Mssql that had an Image column I now > have it in Postgres >

Display Bytea field

I have migrated over a Table from Mssql that had an Image column I now have it in Postgres

Re: Display Bytea field

On Thu, Jan 9, 2025 at 3:17 PM Andy Hartman wrote: > How thru a simple query can I make sure data matches and I can display it > > On Thu, Jan 9, 2025 at 3:16 PM Andy Hartman > wrote: > >> I have migrated over a Table from Mssql that had an Image column I now >> have it in Postgres >> > Did SSMS

Re: Display Bytea field

could it be done using Powershell? On Thu, Jan 9, 2025 at 3:25 PM Ron Johnson wrote: > On Thu, Jan 9, 2025 at 3:17 PM Andy Hartman > wrote: > >> How thru a simple query can I make sure data matches and I can display it >> >> On Thu, Jan 9, 2025 at 3:16 PM Andy Hartman >> wrote: >> >>> I have m

Re: Alter table fast

On Thu, 9 Jan 2025 at 21:57, Ron Johnson wrote: > On Thu, Jan 9, 2025 at 11:25 AM veem v wrote: > >> Hello, >> It's postgres version 16.1, we want to convert an existing column data >> type from integer to numeric and it's taking a long time. The size of the >> table is ~50GB and the table has ~

Re: Display Bytea field

Sure. There's at least one Postgresql driver for PS, and Google says there are 3rd party libraries to display images. It's just a Simple Matter Of Programming! On Thu, Jan 9, 2025 at 3:31 PM Andy Hartman wrote: > could it be done using Powershell? > > On Thu, Jan 9, 2025 at 3:25 PM Ron Johnson