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
. ? Regards and best wishes, Justin Clift

Re: constant crashing hardware issue and thank you TAKE AWAY

2024-04-17 Thread Justin Clift
ory, 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
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
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

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
-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
;, 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-30 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-27 Thread Justin Clift
://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 s

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-23 Thread Justin Clift
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 for the version

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". Only the

PG minor version in data directory?

2023-08-18 Thread Justin Clift
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

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

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

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

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