The logical replication dump of the table I thought was 'stuck' eventually
completed after 6+ hours. I guess the replication slot showing active as
false is to be expected. I never noticed it before.
So there never was an issue - apart from my ignorance. Sorry for the noise.
Cheers,
Steve
On We
Sorry, I should have added the publisher is on 13.1 and the subscriber
14.2. Both are AWS RDS instances. I checked the log files for the publisher
and subscriber and couldn't see any logical replication errors. The
publisher is a busy DB though so if there are any errors there, I may have
missed th
Hi,
I'm in the process of doing the initial syncing of a subscriber with a
publisher.
There is only one table that is still in a 'dumping' state. It is quite a
large table and in previous executions it took several hours.
I'm not sure if it encountered a problem and stopped or if it is still
goi
> t...@sss.pgh.pa.us wrote:
>
>> b...@yugabyte.com wrote:
>>
>> The DO block runs without error and reports "INFO: 42". This is an
>> unambiguous semantic error because "a" is declared "constant"… Is this a
>> known issue?
>
> It is, see
> https://git.postgresql.org/gitweb/?p=postgresql.git&
Bryn Llewellyn writes:
> The DO block runs without error and reports "INFO: 42". This is an
> unambiguous semantic error because "a" is declared "constant".
> Is this a known issue?
It is, see
https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=ccd10a9bf
I just did this using PG 14.2:
create procedure p(a out int)
language plpgsql
as $body$
begin
a := 42;
end;
$body$;
do $body$
declare
a constant int := 0;
begin
call p(a);
raise info '%', a::text;
end;
$body$;
The DO block runs without error and reports "INFO: 42". This is an unambi
On 5/3/22 10:26 AM, JORGE MALDONADO wrote:
I included the space in chcp 1252, it was a typo in the last message I sent.
This is what I just did as per your suggestion in a command prompt with
Lucida Console font.
C:\Users\JorgeMal>chcp
Active code page: 437
C:\Users\JorgeMal>cmd.exe /c chcp 1
I included the space in chcp 1252, it was a typo in the last message I sent.
This is what I just did as per your suggestion in a command prompt with
Lucida Console font.
C:\Users\JorgeMal>chcp
Active code page: 437
C:\Users\JorgeMal>cmd.exe /c chcp 1252
Active code page: 1252
C:\Users\JorgeMal>c
On 5/3/22 09:10, JORGE MALDONADO wrote:
Hi,
I tried the suggestion in the "*Notes for Windows Users*" which
recommends the following:
The first suggestion says that 1252 is the code page for German.
However, I used it because that is the code the DB was created with.
When I ran the *cmd
Hi,
I tried the suggestion in the "*Notes for Windows Users*" which recommends
the following:
*psql is built as a “console application”. Since the Windows console
windows use a different encoding than the rest of the system, you must take
special care when using 8-bit characters within psql. If
10 matches
Mail list logo
