Dear All,
I am trying to follow instructions regarding in-place upgrade with
streaming replica servers. The documentation here:
https://www.postgresql.org/docs/13/pgupgrade.html#:~:text=Prepare%20for%20standby%20server%20upgrades
says that I should check 'Latest checkpoint location' in primary
Hi everyone, we're planning to upgrade the OS running Postgres from ubuntu
jammy to ubuntu noble. As part of the OS change, the glibc version will be
changed from glibc 2.35 to glibc 2.39..
Can someone confirm if changing the glibc between those versions will
require a full reindex of the Postgres
On 1/16/25 04:25, anlex N wrote:
I have searched all archives, but have no results. Please help me.
Consistency of what?
--
Adrian Klaver
adrian.kla...@aklaver.com
On Thu, 2025-01-16 at 15:25 +0300, anlex N wrote:
> I have searched all archives, but have no results. Please help me.
That's probably because the question doesn't make much sense.
A single PostgreSQL instance (=cluster) enforces consistency,
and it doesn't matter which data type you are using.
S
I have searched all archives, but have no results. Please help me.
On Thu, Jan 16, 2025 at 12:14:54PM +, Wiwwo Staff wrote:
> Hi all!
> In a scenario like this:
>
> > =# create table tab1(text1 text default 'from table');
> >
> > =# create procedure ins_tab1(p_text1 text default 'from proc') language
> sql as
> > -# $$
> > $# insert into tab1(text1) values (p
Hi all!
In a scenario like this:
> =# create table tab1(text1 text default 'from table');
>
> =# create procedure ins_tab1(p_text1 text default 'from proc') language
sql as
> -# $$
> $# insert into tab1(text1) values (p_text1);
> $# $$;
>
> =# call ins_tab1 (null);
>
> =# select * from tab1 ;
>
