Re: Issue Launching PostgreSQL on MacBook M4 – Error -10669‏

Go to https://postgresapp.com/downloads.html, download the app, install and connect to the running instance with your Postgres GUI client of choice. If it's an important part of your studies you should be able to figure out to get it running too. The error message you originally shared isn't a

Re: Issue Launching PostgreSQL on MacBook M4 – Error -10669‏

Hey, please use "Reply All" when you reply (As someone else already told you before I saw), as otherwise the response only goes to me directly and nobody else can follow along or help you. After a quick online search it seems that this error means you don't have Rosetta installed, this is the e

Re: Issue Launching PostgreSQL on MacBook M4 – Error -10669‏

Hey, you'll need to give a bit more information here. How did you install Postgres and what are you doing to see this error message? There's multiple ways recommended on https://www.postgresql.org/download/macosx/, personally I'd give Postgres.app a. try or the installation via Homebrew (A bit

Looking for pgbench Benchmark Results Across PostgreSQL Versions

Hi everyone, I’ve been searching for a website that provides pgbench results for different PostgreSQL versions, from 11 to 18, including the latest beta or alpha releases. Does anyone know of such a site? Thanks!

Re: Issue Launching PostgreSQL on MacBook M4 – Error -10669

On 5/8/25 12:41, איתי זרחוביץ wrote: You need to remember to hit Reply All so the list is included in the conversation. Ccing list I tried before a hour to download Try now and see what happens. Also try the postgres.app link I posted previously. -- Adrian Klaver adrian.kla...@aklaver

Re: Issue Launching PostgreSQL on MacBook M4 – Error -10669

On 5/8/25 12:02, איתי זרחוביץ wrote: Reply to list also: Ccing list. I tried to download from this link: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads and than i got the error  _LSOpenURLsWithCompleti

Re: Issue Launching PostgreSQL on MacBook M4 – Error -10669

On 5/8/25 05:17, איתי זרחוביץ wrote: ,Hello I have a MacBook with an M4 chip. I tried installing PostgreSQL version 17.5, but after the installation, I received the following error | _LSOpenURLsWithCompletionHandler() failed with error -10669 (1) .and the application fails to launch A screensh

Re: EDB Download for PostgreSQL 17.5 is broken

Hi Ertan Correct Version 17.5.0 is being downloaded and it may be a cache issue. Regards Kashif Zeeshan EDB On Thu, May 8, 2025 at 9:29 PM Ertan Küçükoglu wrote: > Hello, > > I am just writing here with the hope that there are some EDB contacts here. > > The 17.5 version Windows x86-64 downloa

Re: EDB Download for PostgreSQL 17.5 is broken

On 5/8/25 09:29, Ertan Küçükoglu wrote: Hello, I am just writing here with the hope that there are some EDB contacts here. The 17.5 version Windows x86-64 download link on EDB is https://sbp.enterprisedb.com/getfile.jsp?fileid=1259563

EDB Download for PostgreSQL 17.5 is broken

Hello, I am just writing here with the hope that there are some EDB contacts here. The 17.5 version Windows x86-64 download link on EDB is https://sbp.enterprisedb.com/getfile.jsp?fileid=1259563 and this is actually getting you a 17.4-2 download. Thanks & Regards, Ertan

Re: pg_rewind problem: cannot find WAL

On 5/8/25 04:26, Luca Ferrari wrote: On Thu, May 8, 2025 at 8:54 AM Luca Ferrari wrote: I've pgbackrest making backups, so I have an archive_command. I'm going to see if putting a restore_command can fix the problem. But I'm facing a quite trivial problem: in ubuntu installation the configu

Re: pg_rewind problem: cannot find WAL

> > Any idea? > Clearly, postgresql.auto.conf is within PGDATA, and since my > recovery_command is there, one trick could be to touch and empty > PGDATA/postgresql.conf, pg_rewind, remove the fake configurtion file. > But I'm sure there is a smarter solution. > > Thanks, > Luca > > A symlink

Re: pg_rewind problem: cannot find WAL

On Thu, May 8, 2025 at 4:04 PM Rob Sargent wrote: > > > A symlink from $PGDATA to where actual file? > Could be, I need to experiment with pg_basebackup to ensure it is not conflicting with the /etc/ configuration file when creating a clone. Luca

Re: Feature-Request: Performance-Optimization when using limit in combination with order by on querys using union

Karsten P writes: > i'm sorry i didn't check that first. it just won't work in my real-life > example. > though each part of the query is using an index-scan it is than using a > 'normal' append > instead of a merge-append, but i don't know why. The "Subquery Scan" nodes shown in your real-life

Re: Feature-Request: Performance-Optimization when using limit in combination with order by on querys using union

On Thu, 8 May 2025 at 22:57, Karsten P wrote: > i'm sorry i didn't check that first. it just won't work in my real-life > example. > though each part of the query is using an index-scan it is than using a > 'normal' append > instead of a merge-append, but i don't know why. You could try: SET ena

Re: Is anyone up for hosting the online PG game "Schemaverse"?

On 2025-05-06 09:15, Merlin Moncure wrote: On Thu, May 1, 2025 at 5:23 PM Justin Clift wrote: Hi all, The PostgreSQL game "Schemaverse" was removed from the PostgreSQL website's links a few months ago because it no longer had hosting. Does anyone around have spare server/vm/something that c

Re: pg_rewind problem: cannot find WAL

On Thu, May 8, 2025 at 8:54 AM Luca Ferrari wrote: > > I've pgbackrest making backups, so I have an archive_command. I'm > going to see if putting a restore_command can fix the problem. > But I'm facing a quite trivial problem: in ubuntu installation the configuration files are separated from the

Re: Pgbackrest failure for INCR and DIFF but not FULL backup

On Wed, May 7, 2025 at 6:46 PM Greg Sabino Mullane wrote: > On Wed, May 7, 2025 at 7:15 AM KK CHN wrote: > >> *archive_command = 'pgbackrest --stanza=My_Repo archive-push %p && cp %p >> /data/archive/%f' * >> > > Don't do this. You are archiving twice, and worse, the first part is using > async

Re: Feature-Request: Performance-Optimization when using limit in combination with order by on querys using union

Okay, forget what i've just written, sorry for that. I've digged deeper and checked my generic example - it works perfectly using a merge-append in combination with limit. i'm sorry i didn't check that first. it just won't work in my real-life example. though each part of the query is using an

Feature-Request: Performance-Optimization when using limit in combination with order by on querys using union

Hi, i've already googled so far but didn't find anything regarding my problem.. I hope i'm here at the right place. Following situation (this is just an simplyfied example): suppose we have two tables, lets say orders   - column 'order_number' -> varchar   - column 'order_date' -> timestamp w