Re: Help in vetting measuring egress/ingress w.r.to " pg_dumpall " - old vm to new vm

On 1/28/25 12:13, Bharani SV-forum wrote: TQ Adrian another Question on the measuring egress (out bound traffic) /ingress (inbound traffic) w.r.to " pg_dumpall " during usage of Since you are using AWS EC2(?) instances wouldn't the AWS dashboard show you this? pg_dumpall -h    -p 5432 | p

Re: Help in vetting measuring egress/ingress w.r.to " pg_dumpall " - old vm to new vm

On Tue, Jan 28, 2025 at 3:13 PM Bharani SV-forum wrote: > TQ Adrian > another Question on the measuring egress (out bound traffic) /ingress > (inbound traffic) w.r.to " pg_dumpall " during usage of > > pg_dumpall -h-p 5432 | psql -p 5462 > > taking data from old_vm and copying to new_vm, as i

Help in vetting measuring egress/ingress w.r.to " pg_dumpall " - old vm to new vm

TQ Adriananother Question on the measuring egress (out bound traffic) /ingress (inbound traffic) w.r.to " pg_dumpall " during usage of  pg_dumpall-h    -p 5432 | psql -p 5462 taking data from old_vm and copying to new_vm, as i need to use across the network for taking data and i cannot use "pg_

Re: Help in vetting error using "pg_upgrade" - steps for Postgres DB upgrade from Ver 13.X to ver 14.X/15.X and issue with python binaries

On 1/28/25 08:23, Bharani SV-forum wrote: Team Need your help. We are trying to use existing VM with underlying OS = Amazon Linux 2 (AL2)  along with Pgsql ver 13.X community edn. Trying to upgrade from 13.X to 15.X and had hit the bottleneck for the mandate to have python ver 3.X binaries. We

Re: Content of pg_publication using a local connection versus network connection?

On 1/28/25 10:08 AM, Shaheed Haque wrote: Thanks for the confirmation. Your login/connection security is going to be handled by: https://www.postgresql.org/docs/current/auth-pg-hba-conf.html and the auth methods it supports. On Tue, 28 Jan 2025 at 18:06, Adrian Klaver

Re: Content of pg_publication using a local connection versus network connection?

Thanks for the confirmation. On Tue, 28 Jan 2025 at 18:06, Adrian Klaver wrote: > > > On 1/28/25 10:02 AM, Shaheed Haque wrote: > > Hi, > > > > Based on the nudge from Adrian, I think I am now trying to connect to > > the correct/same database through both the original > > login-to-EC2-host-then

Re: Content of pg_publication using a local connection versus network connection?

On 1/28/25 10:02 AM, Shaheed Haque wrote: Hi, Based on the nudge from Adrian, I think I am now trying to connect to the correct/same database through both the original login-to-EC2-host-then-use-psql-to-RDS and then setup-SSHTunnel-then-connect-via-psycopg-over-tunnel. The connect-via-ps

Re: Content of pg_publication using a local connection versus network connection?

Hi, Based on the nudge from Adrian, I think I am now trying to connect to the correct/same database through both the original login-to-EC2-host-then-use-psql-to-RDS and then setup-SSHTunnel-then-connect-via-psycopg-over-tunnel. The connect-via-psycopg-over-tunnel bit currently fails. Obviously, t

Help in vetting error using "pg_upgrade" - steps for Postgres DB upgrade from Ver 13.X to ver 14.X/15.X and issue with python binaries

TeamNeed your help.We are trying to use existing VM with underlying OS = Amazon Linux 2 (AL2)  along with Pgsql ver 13.X community edn.Trying to upgrade from 13.X to 15.X and had hit the bottleneck for the mandate to have python ver 3.X binaries.We have limitation with the existing VM with AWS

Re: Issues with EPOCH-s, TIMESTAMP(TZ)-s and leap seconds.

On 28/01/2025 00:05, Thomas Munro wrote: Thanks to you and all the others who took the trouble to reply, I showed the bones of how you could do this in SQL here: https://www.postgresql.org/message-id/CA%2BhUKGLU9Don4YHnfdzn0eeWQsUu8GJDaLiUAefLLT6%3DmmeGoQ%40mail.gmail.com The technical

Re[2]: FATAL: could not send data to WAL stream: lost synchronization with server: got message type "0", length 892351284

Colleagues confirmed that the problem is with the network between data centers. Thank you! воскресенье, 26 января 2025г., 20:33 +03:00 от Adrian Klaver adrian.kla...@aklaver.com : >On 1/26/25 03:29, Дмитрий wrote: > "How was it shut down, on purpose or a hardware/software issue?" > - I reboot

Re: Parallel workers via functions?

Thanks for the reply Laurenz. Inline replies follow... On Tue, 28 Jan 2025 at 04:47, Laurenz Albe wrote: > > On Mon, 2025-01-27 at 18:08 +, Jim Vanns wrote: > > If I have a function that is marked 'stable parallel safe' and returns > > a table, can a calling function or procedure (marked vola