ECCN for PostgreSQL

2022-09-22 Thread 杨瑜萍
Hello, this is Panasonic software development department. Is there any ECCN restriction for PostgreSQL. Thank you. ** 楊 瑜萍(Yang YuPing)  蘇州松下生産科技有限公司(PFSS) R&Dセンター ソフト開発部 中国江蘇省蘇州工業園区唯亭鎮臨埠街1号 Panasonic Factory

Re: PCI-DSS Requirements

2022-09-22 Thread Laurenz Albe
On Thu, 2022-09-22 at 06:16 +, Inzamam Shafiq wrote: > From: Ron > > > Anyone on PCI-DSS requirements for PostgreSQL DB, need help for some of > > > the points. > > > > Can you be more specific?  (Typically. the auditors or the "audit > > pre-check" team > > will ask for a bunch of details o

Re: ECCN for PostgreSQL

2022-09-22 Thread Laurenz Albe
On Thu, 2022-09-22 at 06:43 +, YangYuping(杨瑜萍) wrote: > Hello, this is Panasonic software development department. > Is there any ECCN restriction for PostgreSQL. You should consult and pay a qualified lawyer on that. That said, PostgreSQL is freely available to everybody, so that it is never

Re: ECCN for PostgreSQL

2022-09-22 Thread Junwang Zhao
There is no ECCN restriction, there was a thread talking about this, see [0] [0]: https://www.postgresql.org/message-id/17562.1329923596%40sss.pgh.pa.us On Thu, Sep 22, 2022 at 3:45 PM YangYuping(杨瑜萍) wrote: > > Hello, this is Panasonic software development department. > > Is there any ECCN rest

Re: [EXT] pg_stat_activity.backend_xmin

2022-09-22 Thread Laurenz Albe
On Wed, 2022-09-21 at 16:22 +, Dirschel, Steve wrote: > > > > > We are troubleshooting an issue where autovacuum is not cleaning up a > > > > > table. > > > > > The application using this database runs with autocommit turned off. > > > > > We can see in pg_stat_activity lots of sessions “idle

Patroni question

2022-09-22 Thread Zwettler Markus (OIZ)
We had a failover. I would read the Patroni logs below as following. 2022-09-21 11:13:56,384 secondary did a HTTP GET request to primary. This failed with a read timeout. 2022-09-21 11:13:56,792 secondary promoted itself to primary 2022-09-21 11:13:57,279 primary did a HTTP GET request to seconda

Re: PCI-DSS Requirements

2022-09-22 Thread Ron
We use PgBackRest to create encrypted backups, but the nature of pg_dump means that the only way for them to be encrypted is to add that feature to pg_dump. On 9/22/22 01:16, Inzamam Shafiq wrote: Hi Ron, Thank you for the response. Actually we are in a starting phase and I have done instanc

Database Horizon

2022-09-22 Thread Goti
Hi, I was reading through snapshot chapter in Egor Rogov's postgres internals and there I came across the below.. I am not sure how this is possible and how can I reproduce? Can someone explain the below 2 points if possible? A real transaction at the Read Committed isolation level holds the data

pg_dump failed with error code 255, but I don't see why

2022-09-22 Thread Ron
v9.6.2.23 I always run pg_dump with the --verbose option, and the bash script echos $?, so there's a 25,664 line log file for me to examine which explicitly shows the return code. But however much I search the log file for strings like ERROR, FATAL, WARN, INFO, and "archiver", I don't see

Re: pg_dump failed with error code 255, but I don't see why

2022-09-22 Thread Tom Lane
Ron writes: > v9.6.2.23 > I always run pg_dump with the --verbose option, and the bash script echos > $?, so there's a 25,664 line log file for me to examine which explicitly > shows the return code. A quick search of the 9.6 pg_dump source code shows that it only ever calls exit() with values

Re: pg_dump failed with error code 255, but I don't see why

2022-09-22 Thread Ron
On 9/22/22 09:34, Tom Lane wrote: Ron writes: v9.6.2.23 I always run pg_dump with the --verbose option, and the bash script echos $?, so there's a 25,664 line log file for me to examine which explicitly shows the return code. A quick search of the 9.6 pg_dump source code shows that it only eve

Validate the internal consistency of pg_dump output?

2022-09-22 Thread Ron
In my case, it's directory format backups. (I'm not asking whether the pg_dump output is exactly the same as the data in the database; that can only be done inside of  pg_dump, and I don't see any option for that anyway.) Is there a tool for validating that: - there are "\N" lines at the end

Re: Database Horizon

2022-09-22 Thread Laurenz Albe
On Thu, 2022-09-22 at 19:30 +0530, Goti wrote: > I was reading through snapshot chapter in Egor Rogov's postgres internals and > there I > came across the below.. I am not sure how this is possible and how can I > reproduce? > Can someone explain the below 2 points if possible? > > A real transa

Re: pg_dump failed with error code 255, but I don't see why

2022-09-22 Thread Jerry Sievers
Ron writes: > On 9/22/22 09:34, Tom Lane wrote: > >> Ron writes: >>> v9.6.2.23 >>> I always run pg_dump with the --verbose option, and the bash script echos >>> $?, so there's a 25,664 line log file for me to examine which explicitly >>> shows the return code. >> A quick search of the 9.6 pg_dum