Upgrading from 9.6 to 12

[Kasun Kulathunga]

Hello,

We're currently in the beginning phases of a project to upgrade our
Postgres cluster from 9.6 to a newer version (most likely v12).

This is actually going to be a two part move since we're going to move from
a RHEL-backed cluster to an Ubuntu server-backed one.

I was wondering if there are any potential pitfalls we should look out for,
particularly considering we're jumping up 4 major version and tossing in an
OS change for good measure.

Best Regards,
Kasun Kulathunga

Re: POLL: Adding transaction status to default psql prompt

[Kasun Kulathunga]

On Thu, Feb 6, 2020, 20:29 Ken Tanzer  wrote:

Em qua, 5 de fev de 2020 às 23:55, Vik Fearing 
escreveu:


Please answer +1 if you want or don't mind seeing transaction status by
default in psql or -1 if you would prefer to keep the current default.


+1

I liked the idea just reading about it, but thought it would be good form
to at least try it out before voting.  If I read the patch right, people
can try this out by setting their prompt without having to change their
.psqlrc file:

\set PROMPT1 ''%/%R%x%# '

Having done so, I'm still a +1!

Cheers,
Ken


-- 
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ *
*https://demo.agency-software.org/client
*
ken.tan...@agency-software.org
(253) 245-3801

Subscribe to the mailing list
 to
learn more about AGENCY or
follow the discussion.


I've been using this setting for so long in .psqlrc that I forgot its not a
default thing!

+1 from me as well!

-Kasun