Re: [SQL] Insane behaviour in 8.3.3
Thanx, well said, and especially after this incident we should very well consider seriously an upgrade. On Παρ 15 Ιουν 2012 19:59:05 Scott Marlowe wrote: > Well, I'd see about finding a way to upgrade to 8.3.19. 8.3.3 has > know data eating bugs. > > On Fri, Jun 15, 2012 at 9:32 AM, Achilleas Mantzios > > wrote: > > On Παρ 15 Ιουν 2012 18:03:26 Scott Marlowe wrote: > >> Not talking about going to something after 8.3.19, just updating to > >> the latest 8.3 version. On most systems it's a simple: > >> > >> sudo apt-get upgrade > >> > >> or similar and sit back and watch. > > > > Thanx, unfortunately we dont have TCP/IP connectivity to (most of) the > > ships, and AFAIK apt-get does not yet work over advanced > > UUCP/minicom/kermit or other equivalent hich-tech dial up connection. > > just joking :) > > > >> On Fri, Jun 15, 2012 at 2:24 AM, Achilleas Mantzios > >> > >> wrote: > >> > On Παρ 15 Ιουν 2012 10:28:20 Scott Marlowe wrote: > >> >> You do realize you're missing four years of bug fixes right? > >> > > >> > On Πεμ 14 Ιουν 2012 11:39:35 Achilleas Mantzios wrote: > >> >> Unfortunately the remote installations are neither physically > >> >> accessible nor by TCP/IP accesible (comms are done via UUCP and > >> >> administration via minicom, and the costs are just huge 5 USD/min > >> >> for 33Kbits/sec). So, i would exhaust all posibilities before > >> >> deciding to ship a new postgresql version there, and remotely > >> >> upgrade, physically travel to the ship or even trying to do a > >> >> backup/initdb/restore in the existing version. Any help would be > >> >> really really appreciated. > >> >> > >> >> Also, as you might have understood, upgrading, although generally a > >> >> good idea, does not apply so easily in our case. > >> > > >> > And i forgot to mention, minicom term emulation quality sucks, even > >> > giving simple shell commands is a PITA, upgrading the whole fleet > >> > would mean bast case scenario minimum 21K USD for the whole fleet + > >> > suspension of all other activities for two months. If physical travel > >> > was involved, the cost would be increased at even higher levels. > >> > > >> > > >> > - > >> > Achilleas Mantzios > >> > IT DEPT > > > > - > > Achilleas Mantzios > > IT DEPT > > > > -- > > Sent via pgsql-sql mailing list ([email protected]) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-sql - Achilleas Mantzios IT DEPT -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] Insane behaviour in 8.3.3
On Σαβ 16 Ιουν 2012 03:22:16 you wrote: > On Fri, Jun 15, 2012 at 3:06 AM, Achilleas Mantzios < > > [email protected]> wrote: > > On Παρ 15 Ιουν 2012 12:29:38 Samuel Gendler wrote: > > > On Fri, Jun 15, 2012 at 2:28 AM, Samuel Gendler > > > > > > wrote: > > > > On Fri, Jun 15, 2012 at 1:24 AM, Achilleas Mantzios < > > > > > > > > [email protected]> wrote: > > > >> And i forgot to mention, minicom term emulation quality sucks, even > > > >> giving simple > > > >> shell commands is a PITA, upgrading the whole fleet would mean bast > > > > case > > > > > >> scenario > > > >> minimum 21K USD for the whole fleet + suspension of all other > > > > activities > > > > > >> for two months. > > > >> If physical travel was involved, the cost would be increased at even > > > >> higher levels. > > > > > > > > And what is the cost of data corruption on large numbers of systems? > > > > And > > > > > > how much to fix that, especially if multiple systems fail at the same > > > > time? > > > > > > > > Some things aren't free. $21K in exchange for NOT having had to keep > > > > > > > > systems up to date for 4 years seems like a decent trade. > > > > > > Just call up an oracle sales rep and get a price quote for a single > > > baseline system. Put that next to the postgresql upgrade cost for your > > > whole fleet. > > : > > :) I know, I have used this argument sometimes successfully, sometimes > > :not. > > > > The problem with oracle is not the price. The problem is that it just > > cannot do > > what postgresql does, or what we have managed to do ourselves with > > postgresql. > > Our replication system is unique, built in-house, and no commercial > > alternative existed, > > exists, or (most probably) will exist. > > Just to be clear, I wasn't, in any way, sugggesting you actually use > Oracle. I was merely suggesting that if someone is up in arms about > upgrading multiple systems for a cost of $21K, you might show them the > price of a single oracle license as a point of comparison. > It's ok, you were pretty clear, I was just trying to enhance/enrich our position with more arguments ;) > > - > > Achilleas Mantzios > > IT DEPT > > > > -- > > Sent via pgsql-sql mailing list ([email protected]) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-sql - Achilleas Mantzios IT DEPT -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] Insane behaviour in 8.3.3
On Mon, Jun 18, 2012 at 11:36:14AM +0300, Achilleas Mantzios wrote: > > >> Not talking about going to something after 8.3.19, just updating to > > >> the latest 8.3 version. On most systems it's a simple: > > >> > > >> sudo apt-get upgrade > > >> > > >> or similar and sit back and watch. > > > > > > Thanx, unfortunately we dont have TCP/IP connectivity to (most of) the > > > ships, and AFAIK apt-get does not yet work over advanced > > > UUCP/minicom/kermit or other equivalent hich-tech dial up connection. > > > just joking :) You might consider shipping .debs over the dialup and either "dpkg -i"ing them or even setup a local repository on the ships from which to "apt-get upgrade". Karsten -- GPG key ID E4071346 @ gpg-keyserver.de E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] Insane behaviour in 8.3.3
On 2012-06-15, Achilleas Mantzios wrote: > On Παρ 15 Ιουν 2012 18:03:26 Scott Marlowe wrote: >> Not talking about going to something after 8.3.19, just updating to >> the latest 8.3 version. On most systems it's a simple: >> >> sudo apt-get upgrade >> >> or similar and sit back and watch. > > Thanx, unfortunately we dont have TCP/IP connectivity to (most of) the ships, > and AFAIK apt-get does not yet work > over advanced UUCP/minicom/kermit or other equivalent hich-tech dial up > connection. > just joking :) If you were serious I'd suggest writing a backend for it :) minicom terminal emulations sucks, use ckermit instead it does no terminal emulation at all, less is not more more, but in this case none is all. the worst bit about upgrades is when you hit some newly invalid characters in a UTF8 text column. -- ⚂⚃ 100% natural -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] Insane behaviour in 8.3.3
On 2012-06-15, Richard Huxton wrote: > On 15/06/12 16:32, Achilleas Mantzios wrote: >> On Παρ 15 Ιουν 2012 18:03:26 Scott Marlowe wrote: >>> Not talking about going to something after 8.3.19, just updating to >>> the latest 8.3 version. On most systems it's a simple: >>> >>> sudo apt-get upgrade >>> >>> or similar and sit back and watch. >> >> Thanx, unfortunately we dont have TCP/IP connectivity to (most of) the >> ships, and AFAIK apt-get does not yet work >> over advanced UUCP/minicom/kermit or other equivalent hich-tech dial up >> connection. >> just joking :) > > Can you run rsync over a serial connection? Never tried, but if you had > something that took the same options as ssh I daresay you could get it > working. probably possible. it may be possible to create a wrapper that makes its user interface behave like lszrz, then it can be launched over an existing serial connection but for uploading packages lszrz should be enough, -- ⚂⚃ 100% natural -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
