Re: Query performance issue

On Thu, Oct 17, 2024 at 3:06 AM Peter J. Holzer wrote: > > The execution plan looks like a postgresql execution plan, not a mysql > execution plan. Did you run this query on postgresql? That may be > interesting for comparison purposese, but ultimately it is useless: You > won't get mysql to work

Re: Basebackup fails without useful error message

On Sunday, October 20, 2024, Koen De Groote wrote: > > > I'm going to be testing this. If someone could confirm that this is how > writing WAL files works, that being: that it is only considered "done" when > the archive_command is done, that would be great. > The archiving of WAL files by the pr

Re: Basebackup fails without useful error message

On 10/21/24 13:49, Koen De Groote wrote: See, I'm reading that, and my conclusion is "Ah great, it will try again, everything will be fine." Unless it never completes and you hit the timeout. There's a link between the archive_command, pg_basebackup and wal_sender_timeout, but that link isn

Re: Basebackup fails without useful error message

See, I'm reading that, and my conclusion is "Ah great, it will try again, everything will be fine." There's a link between the archive_command, pg_basebackup and wal_sender_timeout, but that link isn't clear from just reading all these documentation pages when learning about their concepts separat

Re: Postgres installation is failing in mac

On 10/19/24 00:23, Venkata Nori wrote: The issue is fixed. Version: Postgres 17 Now i am facing a new issue in creating a new database server 1) The error is in connecting to an existing database, not creating a new server. 2) Looks to me like the PATH for the Postgres binaries is not set

Re: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed

On 10/21/24 1:40 AM, user wrote: ** forwarding to mailing list, forgot to add header Thanks for answering. I think one misunderstanding happened. The parent table has the foreign key constraint. So attach partition will add this constraint for table being attached. (How this compares to for

Re: Timezone: resolve $TZDIR in runtime

Ah, I see -- so tzselect uses tzdb distribution too? it is just, tzselect can alter the timezone database and it looks for TZDIR in some distributions, however, it is not the source of truth in that sense. I think I see now why it's not really feasible to make such an adjustment.. Thanks for your

Re: Timezone: resolve $TZDIR in runtime

Anatolii Smolianinov writes: > Right, it is not an official standard, but TZDIR appears in tzselect, which > comes from GNU libc. https://www.unix.com/man-page/redhat/8/TZSELECT/ No, it comes from the tzdb distribution, which otherwise hard-wires a compile-time choice for that directory. Which

Re: Timezone: resolve $TZDIR in runtime

On 2024-10-21 Anatolii Smolianinov wrote: > date(1) does not set timezone dir: but it uses TZ, and, in man, it > refers to tzselect: > > use tzselect to find TZ" That's an imperative "use", not an indicative. In other words: the user, to find an appropriate value for `TZ`, should run the command

Re: Timezone: resolve $TZDIR in runtime

Right, it is not an official standard, but TZDIR appears in tzselect, which comes from GNU libc. https://www.unix.com/man-page/redhat/8/TZSELECT/ date(1) does not set timezone dir: but it uses TZ, and, in man, it refers to tzselect: > use tzselect to find TZ" On Mon, Oct 21, 2024 at 6:16 P

Re: Timezone: resolve $TZDIR in runtime

Anatolii Smolianinov writes: > As I've mentioned, it's not about embedded really, it is more about support > of standard $TZDIR mechanics in general. One problem with your argument is that there's no standard mentioning TZDIR, nor does it appear to affect actually-standard utilities like date(1).

Re: PostgreSQL Database Community Edition -- Please provide list of the supported hypervisors

On 10/21/24 04:06, Sunil Kumar wrote: Classification: *Confidential* If the rest of the list won't tell neither will I:) Hi Team, Can you please provide list of the supported hypervisors to run the PostgreSQL Database. Wouldn't the OS be the important factor? From the database's standpoi

Re: Timezone: resolve $TZDIR in runtime

Hi Adrian! Totally agree. I think embedded postgresql appeared mainly because of compatibility reasons. If you are using postgres on server, with some of the custom features which you can't find in other databases, and want to enable "local mod" for your users, (and also for tests maybe), but you

Re: Timezone: resolve $TZDIR in runtime

On 10/21/24 08:03, Anatolii Smolianinov wrote: Hi Tom, thanks for your reply! I understand your point, and also, the idea of embedding postgresql -- it might be just not what postgresql is built for. I was just thinking that respecting the standard TZDIR approach would add more flexibility.

Re: Timezone: resolve $TZDIR in runtime

Hi Tom, thanks for your reply! I understand your point, and also, the idea of embedding postgresql -- it might be just not what postgresql is built for. I was just thinking that respecting the standard TZDIR approach would add more flexibility. If you have 5 linux distros and everyone has a diffe

Re: Timezone: resolve $TZDIR in runtime

Anatolii Smolianinov writes: > I was recently working with a project which embeds postgres into > application. It uses binaries built for Debian, and configured to look for > timezones in Debian's timezone folder /usr/share/zoneinfo/, which wasn't > present on my system. Why are you trying to use

Re: PostgreSQL Database Community Edition -- Please provide list of the supported hypervisors

On Monday, October 21, 2024, Sunil Kumar wrote: > > Can you please provide list of the supported hypervisors to run the > PostgreSQL Database. > > If you can run one of the build farm operating systems on your hypervisor you should be fine. But to the extent I do not believe any build farm member

Re: PostgreSQL Database Community Edition -- Please provide list of the supported hypervisors

I think the correct answer will be "all of them" :D maybe besides DOSBOX, etc. because there are no DOS packages. Also, I do not think you should send "Confidential" emails to public mailing lists :) Cheers, Mateusz pon., 21 paź 2024 o 13:33 Sunil Kumar napisał(a): > Classification: *Confident

PostgreSQL Database Community Edition -- Please provide list of the supported hypervisors

Classification: Confidential Hi Team, Can you please provide list of the supported hypervisors to run the PostgreSQL Database. Sunil Kumar Mob: +91-9829753739 OCI Architect HCLTech Supercharging Progress(tm) hcltech.com [Background patternDescription automatically ge

Timezone: resolve $TZDIR in runtime

Hello, I was recently working with a project which embeds postgres into application. It uses binaries built for Debian, and configured to look for timezones in Debian's timezone folder /usr/share/zoneinfo/, which wasn't present on my system. I was thinking if it's possible to redefine it in runti

Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed

** forwarding to mailing list, forgot to add header Thanks for answering. I think one misunderstanding happened. The parent table has the foreign key constraint. So attach partition will add this constraint for table being attached. (How this compares to foreign keys not being considered, not sur