Hi All,
this is a problem from slack channel; it looks like a deadlock. Create
database hangs infinitely showing a lock in pg_stat_activity and being
mutually locked by autovacuum workers. executing pg_reload_conf couple
times releasing the lock. Why sighup helps in this situation? is it a
problem
Hi Eugene,
> > # select '2022-01-06 18:00:00.000+03'::timestamptz(3);
> > timestamptz
> >
> > 2022-01-06 18:00:00+03
> Would it be more correct to output zero milliseconds if the column has
> precision defined?
Only significant fractional are printed, e.g. with millisec
On Fri, Jan 07, 2022 at 05:40:09PM -0500, Tom Lane wrote:
> Hm, you still have cast-away-const in md5_crypt_verify and
> plain_crypt_verify. Can we adjust their APIs to make them
> return const char * as well (and then their API spec is that
> the caller must never free the string, rather than bei
Fixed.
Turned out to be LD_LIBRARY_PATH had a /USR/local/lib. Changed it to
/usr/local/lib and everything's hunky-dory.
On Tue, Jan 4, 2022 at 6:15 PM Tom Lane wrote:
> "Theodore M Rolle, Jr." writes:
> > ldd /usr/local/pgsql/bin/psql
> > linux-vdso.so.1 (0xa2bef000)
> > libpq.so.5 => /
Michael Paquier writes:
> On Thu, Jan 06, 2022 at 11:40:04AM -0500, Tom Lane wrote:
>> Also, I wonder if this shouldn't be unified with the SSLerrmessage()
>> support found in be-secure-openssl.c and fe-secure-openssl.c.
> Guess so. HEAD could be poked at for this part. I recall looking at
> th
Hi All,
I have implemented Stream replication in one of my environments, and for some
reason even though all the health checks are showing that the replication is
working, when I run manual tests to see if changes are being replicated, the
changes are not replicated to the standby postgresql env
Hi,
>
> # select '2022-01-06 18:00:00.000+03'::timestamptz(3);
> timestamptz
>
> 2022-01-06 18:00:00+03
Would it be more correct to output zero milliseconds if the column has
precision defined?
Regards,
Eugene
> '1103003',
> '1020')
>
> and the ERROR I am getting is:
> ERROR: java.lang.ClassNotFoundException: batchprint.Batch
> SQL state: XX000
>
> My postgres version is 11.14.
>
>
> Could anyone suggest
Hi,
I have a function with below definition:
CREATE OR REPLACE FUNCTION onesam.batchprint_individual(
p1 character varying,
p2 character varying,
p3 character varying,
p4 boolean,
p5 boolean,
p6 character varying,
p7 integer,
p8 integer)
RETURNS integer
LANGUAGE 'javau'
COST 100
V
Hi,
I installed PostgreSQL cluster using Patroni and HAProxy on CentOS7.
OS: centos 7
DB:postgreSQL 12
patroni : patroni-1.6.5-1
But when the patroni started that error occured. Are there any suggestion ?
Regards
Dennis
[root@Centos7-04 ~]# sudo systemctl status
10 matches
Mail list logo
