Re: issue/bug management, project management, people management, product management all in one, preferably open source software ?

2025-05-22 Thread Justin Clift
olders the actual picture of our system. I'd be grateful for any hints ! Maybe Corteza? https://cortezaproject.org We do stuff with it at my work, and it's pretty decent. Takes some time and effort to set up though, but is very capable once that's done. Regards and best wishes, Justin Clift

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

2025-05-22 Thread Justin Clift
gcp; I'll set something up. Out of town until late next week but I'll circle back then. Have you had a chance to investigate? :) Regards and best wishes, Justin Clift

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

2025-05-08 Thread Justin Clift
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

Re: Upgrading PG11 to PG17 without dump/restore

2025-05-01 Thread Justin Clift
seful for larger databases, and for situations where you don't have much space. BUT, you *do* have backups don't you? Because stuff *can* go wrong, even though it's not common. ;) Regards and best wishes, Justin Clift

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

2025-05-01 Thread Justin Clift
:) Regards and best wishes, Justin Clift Original Message Subject: Schemaverse Date: 2025-04-21 13:01 From: Joshua McDougall To: jus...@postgresql.org Hi Justin, To answer your question, Schemaverse doesn’t take massive power to host. It needs a database and a small server fo

Re: Upgrade Ubuntu 22 -> 24 may break PostgreSQL

2024-08-31 Thread Justin Clift
sions and stuff like that. Thoughts? Regards and best wishes, Justin Clift

Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.

2024-08-27 Thread Justin Clift
On 2024-08-27 20:14, David Rowley wrote: On Tue, 27 Aug 2024 at 18:00, Justin Clift wrote: As a general thought, seeing that this might be an actual problem should some kind of automated testing be added that checks for performance regressions like this? We normally try to catch these sorts

Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.

2024-08-26 Thread Justin Clift
ng commit as at first I thought it might be related to Memoize. It does not seem to be. As a general thought, seeing that this might be an actual problem should some kind of automated testing be added that checks for performance regressions like this? Regards and best wishes, Justin Clift

Re: Planet Postgres and the curse of AI

2024-08-20 Thread Justin Clift
On 2024-08-20 22:44, Greg Sabino Mullane wrote: On Fri, Jul 19, 2024 at 3:22 AM Laurenz Albe wrote: Why not say that authors who repeatedly post grossly counterfactual or misleading content can be banned? I like this, and feel we are getting closer. How about: "Posts should be technically a

Re: Table data migration from single server to Flexi server

2024-05-02 Thread Justin Clift
On 2024-05-02 13:24, Bagesh kamar singh wrote: Recently we migrated our postgreSQL single server to flexi server. Hmmm, what's "Flexi server"? Doing a quick online search just now isn't showing things that seem to be PostgreSQL related. Regards and best wishes, Justin Clift

Re: SSPI Feature Request

2024-04-19 Thread Justin Clift
ght person. ? Regards and best wishes, Justin Clift

Re: constant crashing hardware issue and thank you TAKE AWAY

2024-04-17 Thread Justin Clift
n" test of all the things (memory, hard disks/ssds, cpu, gpu, etc) just to make sure everything is ok before you start using it for important stuff. Regards and best wishes, Justin Clift

Re: Please recommend postgresql.conf improvements for osm2pgsql loading Europe

2024-03-31 Thread Justin Clift
ace (depends on the storage you're using), you could potentially load things from that backup / snapshot (etc) instead of having to do the import all over again each time. Regards and best wishes, Justin Clift

Re: Please recommend postgresql.conf improvements for osm2pgsql loading Europe

2024-03-29 Thread Justin Clift
27;t seem to be optimised for loading into a database. (?) It kind of looks like they'd be stored into individual records, which probably means they'd be getting imported as individual INSERT statements rather than something that's optimised for bulk loading. :( Regards and best wishes, Justin Clift

Re: PostgreSQL as advanced job queuing system

2024-03-25 Thread Justin Clift
On 2024-03-25 23:44, Merlin Moncure wrote: On Mon, Mar 25, 2024 at 4:43 AM Dominique Devienne wrote: Hi. Anything you can share? OSS? Doesn't look like it... If it's not, a more details higher level architecture overview would be nice. let me float that, I would love to project-ize this.

Re: Safest pgupgrade jump distance

2024-02-12 Thread Justin Clift
On 2024-02-12 20:07, Dávid Suchan wrote: Hi, I was wondering what is the safest pg_upgrade version upgrade distance going from 9.6 version. Do I need to go version by version or I can go from 9.6 to 15? We have a very huge database(TBs) with one replication server, so we will first run the pgup

Re: building a singularity image from docker hub postgres image

2024-01-30 Thread Justin Clift
pure guess work though. :) Regards and best wishes, Justin Clift

Re: Moving to Postgresql database

2024-01-15 Thread Justin Clift
le-to-postgresql-migration-guide-tutorial-move-convert-database-oracle-alternative Regards and best wishes, Justin Clift

Re: Filled Postgres server as Docker image

2024-01-06 Thread Justin Clift
ot;myimage:latest", which you can then use as you need later on. Does that make sense? Regards and best wishes, Justin Clift

Re: Server process exited with exit code 4

2023-11-11 Thread Justin Clift
On 2023-11-09 11:41, yangsr3411 wrote: Finally, we used the Windows tool Gflags.exe and found that other software terminated the postgres process. Out of curiosity, what was the other software? :) Regards and best wishes, Justin Clift

Re: Server process exited with exit code 4

2023-10-29 Thread Justin Clift
that can show a log of any recent weirdness that occurred at a hardware level. If yours can, take a look for things like ECC errors or any other strange stuff. :) Regards and best wishes, Justin Clift

Re: Disk wait problem... may not be hardware...

2023-10-26 Thread Justin Clift
https://github.com/openzfs/zfs/discussions/14793 Note - that's not PostgreSQL specific or anything, but more of a "weird stuff showing up with NVMe drives" thing. Regards and best wishes, Justin Clift

Re: Driver Postgresql HP-Unix

2023-10-21 Thread Justin Clift
On 2023-10-21 21:13, Dave Cramer wrote: On Sat, 21 Oct 2023 at 05:50, Justin Clift wrote: On 2023-10-19 04:45, Abelardo Erazo Lopez wrote: > Hi, Everyone > > I have an Oracle database Oracle 19c and I need to access a PostgreSQL > database 15.4 that resides on a different server

Re: Driver Postgresql HP-Unix

2023-10-21 Thread Justin Clift
*sure* it's PostgreSQL 15.4, and not PostgreSQL 12.4? Asking because I'm not seeing version PG 15.4 in the list here, though PG 12.4 and 16 are: http://hpux.connect.org.uk/hppd/cgi-bin/search?term=postgresql Regards and best wishes, Justin Clift

Re: [EXTERNAL] Oracle FDW version

2023-08-22 Thread Justin Clift
using PostgreSQL, but are instead using a special proprietary spin-off called Greenplum. If that's the case, then you'll need to have a chat with the Greenplum support people. They'll know their product better than we do. :) Regards and best wishes, Justin Clift

Re: PG minor version in data directory?

2023-08-19 Thread Justin Clift
On 2023-08-19 19:14, Peter J. Holzer wrote: On 2023-08-19 14:22:25 +1000, Justin Clift wrote: Thanks, that's what I figured. I'll have to keep state in a PG_VERSION_MINOR there or something. :) Wouldn't it be better to ask whatever system you use to install the software

Re: PG minor version in data directory?

2023-08-18 Thread Justin Clift
On 2023-08-19 14:10, David G. Johnston wrote: On Fri, Aug 18, 2023 at 6:36 PM Justin Clift wrote: If the minor version is already tracked somewhere as well, that would be extremely useful for my use case. The data directory doesn't have a concept of "minor version". Onl

PG minor version in data directory?

2023-08-18 Thread Justin Clift
r version is already tracked somewhere as well, that would be extremely useful for my use case. Otherwise, I'll have to start manually adding info to track it. Regards and best wishes, Justin Clift

Re: Code of Conduct plan

2018-06-08 Thread Justin Clift
On 2018-06-08 09:46, Simon Riggs wrote: Would it not be better to consider arbitration as the first step in dispute resolution? This bit sounds like it'd need to be on a case-by-case basis. It's pretty easy to imagine scenarios where arbitration wouldn't be appropriate. Whether or not they c

Re: Microsoft buys GitHub, is this a threat to open-source

2018-06-07 Thread Justin Clift
On 2018-06-07 12:47, Vik Fearing wrote: On 07/06/18 13:46, Thiemo Kellner wrote: Zitat von Achilleas Mantzios : Who hasn't missed sourceforge ? or ... freshmeat while we'are at it :) I am sticking to sourceforge still. I never understood what people made leave it. For many people, this i

Re: Code of Conduct plan

2018-06-04 Thread Justin Clift
On 2018-06-04 22:26, Alvaro Herrera wrote: On 2018-Jun-05, Gavin Flower wrote: If we are all adults, then we don't need a CoC. "We're all adults" is wishful thinking. Some old people are just kids who aged but didn't actually mature. Also to point out... there is the occasional teen who do

Re: Microsoft buys GitHub, is this a threat to open-source

2018-06-04 Thread Justin Clift
On 4 Jun 2018, at 18:31, Rich Shepard wrote: > On Mon, 4 Jun 2018, Joshua D. Drake wrote: > >> No but it does show why using non open source platforms for open source >> projects is an inherently bad idea. > > Joshua, > > Sourceforge seems to be out of favor, too, so are there any open source

Re: Code of Conduct plan

2018-06-04 Thread Justin Clift
On 4 Jun 2018, at 18:24, Justin Clift wrote: > Adding a CoC will change the quantity-of-fules mix _slightly_, depending on > how in-your-face people > are with it. s/quantity-of-fules/quantity-of-rules/ Interesting typo though. :) -- "My grandfather once told me that there ar

Re: Code of Conduct plan

2018-06-04 Thread Justin Clift
On 4 Jun 2018, at 17:59, Joshua D. Drake wrote: > On 06/03/2018 04:08 PM, Gavin Flower wrote: >> I might possibly say that "I'm the master in this area" when talking to >> someone on a technical subject. In the sense that I'm better at that >> particular skill, but some hypersensitive American