Re: Code of Conduct plan
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 could get their knickers >> in a twist (notice, that in this context, no gender is implied -- also in >> using that that expression "get their knickers in a twist" could offend some >> snowflake) claiming that I'm suggesting that whoever > > "snowflake", I find that term hilarious others find it highly offensive. > Which is correct? Like most things, it depends on context. ;) >> I'm talking to is my slave! I heard of an American university that doesn't >> want people to use the term master, like in an MSc, because of the history >> of slavery. > > The PostgreSQL project already has this problem, note we don't use the terms > Master and Slave in reference to replication anymore. > >> I've used the expressions "sacrifice a willing virgin" and "offering my >> first born to the gods" as ways to ensure success of resolving a technical >> issue. The people I say that to, know what I mean -- and they implicitly >> know that I'm not seriously suggesting such conduct. Yet, if I wrote that >> publicly, it is conceivable that someone might object! > > Yes and that is a problem. We need to have some simple barrier of acceptance > that we are all adults here (or should act like adults). Knowing your > audience is important. > >> Consider a past advertising campaign in Australia to sell government Bonds. >> They used two very common hand gestures that are very Australian. Bond >> sales dropped. On investigation, they found the bonds were mainly bought by >> old Greek people, who found the gestures obscene. The gestures? Thumbs up, >> and the okay gesture formed by touching the thumb with the next finger -- >> nothing sexually suggestive to most Australians, but traditional Greeks >> found them offensive. > > Using Australia as an example, my understanding is that the word c**t is part > of nomenclature but in the states the word is taboo and highly frowned upon. Yes. Us Aussie's often use the word "cunt". Again, depends on context. :) Personally... I don't think I've used it more than 5 times in total, in the years I've been in the UK. Those times I did, it was _definitely_ not in a politically correct fashion. Nor online. YMMV. >> Be very careful in attempting to codify 'correct' behaviour! > > Correct. I think one way to look at all of this is, "if you wouldn't say it > to your boss or a client don't say it here". That too has problems but > generally speaking I think it keeps the restrictions rational. Possibly a weird viewpoint, but I personally have a different way of looking at the CoC thing. From my observations of people so far, it seems like there are two main GROUPings (pun intended :>) of people: * Those who like and want rules for everything. "For without rules how will people know what to do?" * Those who don't like nor want rules for everything. "Stop trying to control me! Let me work out an optimal approach myself!" It's a scale thing, not black and white. Personally, I'm somewhere near the middle (it varies slightly over time). My point being, that when some threshold of "too many rules" is reached the people in the Community who _don't_ like excess rules will leave. Conversely, people who _need_ rules in order to feel comfortable will start to stick around. Neither group is intrinsically right nor wrong. They just operate internally differently, and have different needs. Adding a CoC will change the quantity-of-fules mix _slightly_, depending on how in-your-face people are with it. Our Community will naturally adjust it's makeup over time to reflect this change. Mentioning the above, as I hope we're going into this "eyes wide open". ;) + Justin -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
Re: Code of Conduct plan
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 are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
Re: Microsoft buys GitHub, is this a threat to open-source
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 > platforms that provide services that sourceforge and github do? Both GitLab and BitBucket are commonly suggested. Neither seems great, but when push comes to shove "they'll do". :) For people that are ok with standing up their own servers, there are more options. Gitea (Open Source GitHub clone) is pretty good: https://gitea.io It's also very efficient resource wise (unlike GitLab), so can run effectively on tiny hardware. Even Raspberry Pi level can do a decent job for small scale stuff. Naturally, anyone with team-sized needs would run it on appropriate hardware. ;) + Justin -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
Re: Code of Conduct plan
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 does meaningful stuff with Open Source. So, "we are all adults here" might not actually be 100% correct. :D + Justin
Re: Microsoft buys GitHub, is this a threat to open-source
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 is why sourceforge died: https://en.wikipedia.org/wiki/SourceForge#Project_hijackings_and_bundled_malware Yeah. The Wikipedia page mentions mentions 2015, however DICE (the new owners of SourceForge at the time) introduced it a few years earlier. This is one of the earlier calls to action about the problem: http://blog.gluster.org/how-far-the-once-mighty-sourceforge-has-fallen/ SourceForge were *really* pissed at me for writing that. As in, whinge to my employer about me, threaten to get law people involved, etc. They didn't get very far thankfully. :) Anyway, we seem to be fairly off topic now... + Justin
Re: Code of Conduct plan
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 come about in the PG Community or not is a different matter. My point being that arbitration isn't necessarily automatically the right direction. I'd probably leave it up to the CoC team/people to figure it out. :) + Justin
PG minor version in data directory?
Hiyas, Anyone know if there's a good way to tell what *minor* version of PostgreSQL a data directory has been run with? eg 15.3 vs 15.4 Am working on some "automatic upgrade" stuff, and I'm only aware of the major version being tracked in PGDATA/PG_VERSION. If the minor 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: PG minor version in data directory?
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". Only the installed libraries and binaries do. Thanks, that's what I figured. I'll have to keep state in a PG_VERSION_MINOR there or something. :) Regards and best wishes, Justin Clift
Re: PG minor version in data directory?
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 for the version? In the general sense, yes. :) For the very specific use case I'm working with (!), things are a bit different. It's for this, if that helps with context: * https://github.com/pgautoupgrade/docker-pgautoupgrade * https://hub.docker.com/r/pgautoupgrade/pgautoupgrade <-- docker repo It's a docker container that people use for running PostgreSQL, but also has the ability to (automatically) upgrade the data files from older versions. That's the piece I'm working on. Such a thing is useful for people that need a PG docker container, and whose needs are fairly simple. They can use point at this one, and they'll have a self-upgrading PG version that's fairly "fire and forget". Thus far (1 month in), it seems to work ok (for us) and some other people. Am obviously looking to improve its capabilities over time too. :) + Justin
Re: [EXTERNAL] Oracle FDW version
On 2023-08-23 16:10, Jethro Elmer Sanidad wrote: Hello, Can you confirm in this email that our current version of PostgreSQL (9.2.24) is not compatible with any of oracle_fdw versions released? And you are recommending an upgrade? Thanks! It seems more like you're not actually 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: Driver Postgresql HP-Unix
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. I see that one alternative is to use ODBC from Oracle. However, the server where the database resides is an HP-UX server and I understand that I need a PostgreSQL driver manager compatible with this operating system. Can you help me by indicating if there is one available, where to obtain it, and if it requires a license? Any idea which version of HP-UX is running on that PostgreSQL server? Also, are you *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: Driver Postgresql HP-Unix
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. I see that one > alternative is to use ODBC from Oracle. However, the server where the > database resides is an HP-UX server and I understand that I need a > PostgreSQL driver manager compatible with this operating system. Can > you help me by indicating if there is one available, where to obtain > it, and if it requires a license? Any idea which version of HP-UX is running on that PostgreSQL server? Also, are you *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 I do not believe we publish the binaries for HP-UX but you should be able to build it. HP-UX doesn't seem to be among the build farm these days either, though there was a machine running it up until about ~500 days ago: https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=anole&br=HEAD + Justin
Re: Disk wait problem... may not be hardware...
On 2023-10-27 12:03, p...@pfortin.com wrote: I can't think of a common hardware bus/other that would only affect PostgreSQL disk accesses. Which file system is PostgreSQL being run on? Asking because I remember seeing weirdness reported with *some* SSD drives when used with ZFS: 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: Server process exited with exit code 4
On 2023-10-30 14:02, yangsr3411 wrote: Has anyone encountered similar problem or may know a solution? Just to rule out hardware problems, does the server hardware have some way of showing things like ECC memory errors and similar? Most official server hardware (HPE, Dell, etc) have utilities 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: Server process exited with exit code 4
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: Filled Postgres server as Docker image
On 2024-01-05 20:31, Bernd Graf wrote: As it is not easy to write a Docker build to achieve my goal ... That kind of depends. If this is a test image that you don't need to update frequently, then you can probably take the approach of using an existing image, and extending it to have your data. It's pretty easy to do. As an example, here's one using that same concept: https://github.com/sqlitebrowser/dbhub.io/blob/e1cf6d5ecd32dfcc797a95884e78d8665087eba5/docker/Dockerfile That Dockerfile grabs an existing image (for Alpine Linux in this example), then extends it by running a bunch of commands to do stuff I need. The resulting image then gets tagged with a useful (to me) name "dbhub-build:latest" so I can stop and start it as needed. For your scenario, you could instead do something like this: FROM postgres:latest LABEL maintainer="Bernd Graf " # Load the PostgreSQL data RUN createdb -U postgres somedb RUN psql -U postgres somedb < yourdata.sql That will create a new Docker image based upon the "latest" Docker PostgreSQL release, and it will load a bunch of data into it with those last two RUN steps. Of course, you might need different commands in the RUN steps depending on how you've got your data prepared for loading. :) You build the image using docker like this: docker build --tag myimage /PATH/TO/THE/ABOVE/Dockerfile When it finishes building the image it'll tag it as "myimage:latest", which you can then use as you need later on. Does that make sense? Regards and best wishes, Justin Clift
Re: Moving to Postgresql database
On 2024-01-15 14:16, veem v wrote: Hello Experts, If some teams are well versed with the Oracle database architecture and its optimizers working and designing applications on top of this. Now moving same team to work on AWS aurora postgresql databases design/development projects. Is any key design/architectural changes should the app development team or the database design team, should really aware about, so as to take right decision on any new development project in AWS aurora postgresql database? Or Is there any list of differences(as compared to Oracle database) in key concepts like for example basic design concepts, Normalization, Partitioning, clustering, backup and recovery, Indexing strategy, isolation level, performance which one should definitely be aware of? Is this the kind of thing you're looking for? https://www.enterprisedb.com/blog/the-complete-oracle-to-postgresql-migration-guide-tutorial-move-convert-database-oracle-alternative Regards and best wishes, Justin Clift
Re: building a singularity image from docker hub postgres image
On 2024-01-30 15:52, Allan Kamau wrote: I am trying to build a singularity image from postgres docker image. I am issuing the command below. $ singularity build /local/data/some/postgres.16.1.sif docker://postgres/postgres:16.1 INFO:Starting build... INFO:Fetching OCI image... FATAL: While performing build: conveyor failed to get: GET https://index.docker.io/v2/postgres/postgres/manifests/16.1: UNAUTHORIZED: authentication required; [map[Action:pull Class: Name:postgres/postgres Type:repository]] What is the url I should use? Not personally familiar with Singularity, but this post looks like it should help: https://www.linuxwave.info/2022/04/running-postgresql-database-using.html The example command they have there is: singularity pull docker://postgres:14.2-alpine3.15 So the format of the url *seems* like it should be: docker://postgres:16.1 That just pure guess work though. :) Regards and best wishes, Justin Clift
Re: Safest pgupgrade jump distance
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 pgupgrade on the main server and then rsync to a standby replica. I'm not sure whether it's safe to do it from 9.6 to 15 at once, I have tested the process on 9,6 to 10 yet. Would that be a wise approach to such an upgrade of the db? Also, when upgrading a very big database with replication where none of the data can be allowed to be lost, is the pgupgrade into rsync approach the best one? Thanks. pgupgrade from 9.6 directly to 16 should work fine. That's part of the test suite for one of my side projects (pgautoupgrade in Docker). You'll probably want to use the "--link" option too, so it uses the existing data files rather than recreating them. It's *much* faster. :) I'm not sure how the rsync of things will figure into it though. If you're just rsyncing files when the database is turned off, it should be straight forward. As always though, make sure you have a backup (that's known to work) before you try it all out though. :) + Justin
Re: PostgreSQL as advanced job queuing system
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. Stay tuned Hopefully it get approved. More battle tested queue systems are welcome, especially those that have been used at non-trivial scales. :D + Justin
Re: Please recommend postgresql.conf improvements for osm2pgsql loading Europe
On 2024-03-30 05:53, Alexander Farber wrote: I use the following postgresql.conf in my Dockerfile ( the full version at https://stackoverflow.com/a/78243530/165071 ), when loading a 28 GByte large europe-latest.osm.pbf Is anybody please able to spot any improvements I could apply to the postgresql.conf config values at the top of my mail, that could reduce the loading time of almost 2 hours? Not specific conf file improvements, but for an initial data load have you done things like turning off fsync(), deferring index creating until after the data load finishes, and that kind of thing? You don't want fsync() off when you're using the database in production, but for long data load scenarios it seems like it'd be a decent fit. With .pbf files, from skimming over how they're described here: https://wiki.openstreetmap.org/wiki/PBF_Format ... they don'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: Please recommend postgresql.conf improvements for osm2pgsql loading Europe
On 2024-03-31 04:07, Alexander Farber wrote: Turning fsync = off has resulted in no noticable build time reduction for my Dockerfile with OSM Europe data, but still thank you for the suggestion! No worries. :) With this import you're doing, is it something that will be repeated a lot with the exact same data set, or is this a once off thing? If it's something that'll be repeated a lot (maybe part of some automated process?), then it might be worth making a backup / snapshot / something of the database after the import has completed. With a backup or snapshot in place (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: constant crashing hardware issue and thank you TAKE AWAY
On 2024-04-17 23:06, jack wrote: As a result of this I will be checking the RAM on all my machines once a month or the moment a machine starts to act strange. Once a month is overkill, and unlikely to be useful. :) With server or enterprise grade hardware, it'll support "ECC" memory. That has extra memory chips + supporting circuity on the memory board so it can detect + correct most errors which happen without them causing problems. For the errors that it can't *correct*, it'll still generate warnings to your system software to let you know (if you've configured it). If you do get such a warning - or if the system starts acting funny like you saw - that's when you'd want to run memtest on the system. --- The other time to run memtest on the system is when you first buy or receive a new server. You'd generally do a "burn in" 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: SSPI Feature Request
On 2024-04-19 11:53, Buoro, John wrote: SSPI Kerberos\NTLM authentication (Windows environment) currently only authenticates users, however, it does not authenticate a user against an LDAP \ Active Directory group. Can you please look at making this possible? Sounds like it'd be pretty useful. :) Is this something that Harvey Norman would be interested in sponsoring? ie. hiring a suitable PostgreSQL developer (not me!) to implement it There are quite a few skilled PostgreSQL developers around these days, so (in theory) it shouldn't be *too hard* find someone the right person. ? Regards and best wishes, Justin Clift
Re: Table data migration from single server to Flexi server
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: Planet Postgres and the curse of AI
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 and factually correct. Use of AI should be used for minor editing, not primary generation" Sounds pretty sensible. :) + Justin
Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
On 2024-08-27 11:50, David Rowley wrote: On Tue, 27 Aug 2024 at 13:40, Tom Lane wrote: Yeah, it looks like that condition on "table_name" is not getting pushed down to the scan level anymore. I'm not sure why not, but will look closer tomorrow. I was looking for the offending 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: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
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 of things with regression tests. Of course, that requires having a test that would catch a particular problem, which we don't seem to have for this particular case. A performance test would also require testing a particular scenario, so I don't see why that's better. A regression test is better suited as there's no middle ground between pass and fail. Yeah, that's the kind of thing I was thinking. Any idea who normally does those, and if it would be reasonable to add test(s) for the internal information tables? Regards and best wishes, Justin Clift
Re: Upgrade Ubuntu 22 -> 24 may break PostgreSQL
On 2024-09-01 02:54, Peter J. Holzer wrote: 'Tis the season again. Ubuntu 24.04.1 has just been released, so many Ubuntu LTS users will now be prompted to upgrade from 22.04 to 24.04. A word of warning to those who use Postgresql from the Ubuntu repo (not PGDG): As usual, a newer Ubuntu version comes with a newer Postgres version (16 instead of 14). Also as usual, I got a message during the upgrade that Postgres 14 is obsolete,. but the binaries have been left installed and I should upgrade to Postgres 16 manually ASAP. It'd *technically* be possible to automatically run an upgrade of the PostgreSQL repository (via scripting?) at launch time, though just blindly doing it for everyone would be a *major* change of behaviour. Some people would likely love it, while others would be horrified (etc). That being said, if we announce it ahead of time as a feature of a major release (ie PG 18 or something), and if we have a clear way to not automatically upgrade (a variable in postgresql.conf?), then we might be able to solve this problem ~permanently. We'd also need to figure out how to handle (say) rebuilding of indexes that need updating between major versions and stuff like that. Thoughts? Regards and best wishes, Justin Clift
Is anyone up for hosting the online PG game "Schemaverse"?
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 could be used to host it (for free)? Details in the forwarded message below. :) 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 for the front-end, which can (and has) run off a single virtual machine. I think the last one was 4 vCPUs and 16GB of memory but we’ve hosted off smaller too. The unique part of the setup tends to be its lacking security. All players are users on the database, so the pg_hba.conf needs to be flexible and the game needs enough permissions to create users. These two requirements have made most SaaS offerings non-compatible. Admittedly, the last time I investigated such offerings was years ago now, so it’s possible things have changed. If it’s possible that we can find schemaverse a new home, that would be wonderful. I still get the occasional inquiry asking about it, usually from students, and I’d love to have it back up for those looking to learn from it. Regardless though, thank you for reaching out! -Josh
Re: Upgrading PG11 to PG17 without dump/restore
On 2025-05-01 23:06, Durumdara wrote: The PG_Upgrade is not possible because of lesser space and too old debian. As a data point, pg_upgrade has an option to do an in-place upgrade which reuses the vast majority of the data files as they are on disk, rather than making a copy. It's useful 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
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 could be used to host it (for free)? I might be interested. Is it difficult to set up? Definitely more a question for Josh (CC'd) than me. Josh, are you ok to discuss this with Merlin (etc)? + Justin
Re: Is anyone up for hosting the online PG game "Schemaverse"?
On 2025-05-09 22:52, Merlin Moncure wrote: On Thu, May 8, 2025 at 7:52 PM Joshua McDougall wrote: You may or may not recall I was the one abusing advisory locks so no one could play the game but me :-). Your project is an important part of postgres history IMO. I have some hosting through 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: issue/bug management, project management, people management, product management all in one, preferably open source software ?
On 2025-05-23 03:52, Achilleas Mantzios wrote: Hi people I'd like to know if people here know of or use any integrated solution for all or some of the above. It would be nice if it supported LDAP / OAuth 2.0 , integrate with plain vanilla git (not github / gitlab) and be open, and active as a project. We are at a phase our business is expanding, the projects also are increasing in number and size, several of those are interconnected, either depending or prerequisite or even inter-meshed . I'd like to have a tool to manage all this, but also a tool to show to the stakeholders 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
