sql (17.4)
Type "help" for help.
postgres=# \q
==>
-Original Message-
From: Adrian Klaver
Sent: Thursday, April 10, 2025 12:00 AM
To: Abraham, Danny ; David G. Johnston
; Francisco Olarte ;
pgsql-general@lists.postgresql.org
Subject: Re: [EXTERNAL] Re: Cannot connect l
10:34 PM
To: Abraham, Danny
Cc: Adrian Klaver ; Francisco Olarte
; pgsql-general@lists.postgresql.org
Subject: Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade
assumes it)
On Wed, Apr 9, 2025, 12:21 Abraham, Danny
mailto:danny_abra...@bmc.com>> wrote:
Thanks again.
Here
dba-tlv-x6y64k% pg_ctl reload
server signaled
dba-tlv-x6y64k% psql -Upostgres
Password for user postgres:
psql (17.4)
Type "help" for help.
ctrlmdb=#
>>>>>>>
PSQL should not have asked for the password.
Thanks
Danny
-Original Message-
From: Adrian Klaver
Se
dba-tlv-x6y64k% pg_ctl reload
server signaled
dba-tlv-x6y64k% psql -Upostgres
Password for user postgres:
psql (17.4)
Type "help" for help.
ctrlmdb=#
>>>>>>>
PSQL should not have asked for the password.
Thanks
Danny
-Original Message-
From: Adrian Klaver
Se
Failure eans going down the hba list and asking for the password.
Sent from Workspace ONE Boxer
On Apr 9, 2025 20:04, Francisco Olarte wrote:
On Wed, 9 Apr 2025 at 18:20, Abraham, Danny wrote:
> Asking for help with inability to connect local using trust
> Fail
> #local all
Thanks for the answers.
All the 3 lines are, of course, uncommented for the test.
I am using Linux, socket is in /tmp, i see the .s files , but local trust still
does not connect.
Sent from Workspace ONE Boxer
On Apr 9, 2025 20:04, Francisco Olarte wrote:
On Wed, 9 Apr 2025 at 18:20, Abraham
Hi,
Asking for help with inability to connect local using trust
Fail
#local all all trust
#local all dbauser peer
OK
#hostall all 127.0.0.1/32 trust
your opinion.
Thanks
Danny
Sent from Workspace ONE Boxer
On Mar 6, 2025 10:11, Laurenz Albe wrote:
[redirecting to pgsql-general]
On Thu, 2025-03-06 at 07:39 +, Abraham, Danny wrote:
> I have many customers using PG 15.3 happily, and I cannot just snap upgrade
> them all to 15.12.
Hi,
Change tcp_keepalives_idle in postgresql.conf from 0 to 300 , then pg_ctl
reload but it stays with the old 0 value.
Tried restart and it did not work. PG Log says it was changed.
Reset_cal marked OK, but no real change ( ins how)
-[ RECORD 1 ]---+-
Hi,
Is there a way to integrate " set local statement_timeout" in a stored
procedure?
Something like
create or replace procedure call_sp()
language plpgsql
as $$
begin
set local statement_timeout = 1;
call sp();
end; $$
Hi,
I have a database on Aurora@RDS.
It Used V11.9, and then upgraded automatically by AWS to V15.2 AWS states that
it relies on compatibility provided by the PG community.
We now experience problems with the data.
Has anyone met similar issues? Compatibility of data files?
Thanks
Danny
Right to the point ==> set client_min_messages=error; Solved it
Thanks
-Original Message-
From: Tom Lane
Sent: Monday, June 28, 2021 5:53 PM
To: Abraham, Danny
Cc: pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: WARNING: skipping "pg_database" --- only superuser ca
Hi,
Good old "analyze;" will run smoothly on 11.5...
But on 12.6 will skip and warn on any pg_catalog/information_schema table.
Pg_catalog is on Usage only on both databases (11.5 and 12.6).
Questions: 1. Has the behavior changed in 12.6? 2.How can I analyze on public
tables (No syntax lik
I speculate that I am in the good old problem .. of a very slow plan of NOT IN
(We used to convert it to NOT EXISTS in V8).
Is this planner issue still in V9? Has the planner fixed for it in V10?
Thanks
Danny
2021-04-09 08:00:08.692 IDTERROR: canceling statement due to statement timeout
2021-04-09 08:00:08.692 IDTCONTEXT: PL/pgSQL function
orhpans_active_clean_table(character varying,integer) line 42 at FETCH
PL/pgSQL function orhpans_active_removal() line 31 at assignment
PL/pgSQL fu
stmt := 'select count(*) from ' || table_name;
open C1 for execute stmt;
fetch C1 into rc;
close C1;
if (debug_level = 1) then
if rc > 0 then
perform diag_print(func_name,format('Counted %s records in table
%s',rc,table_name) );
else
perform diag_print
Has anybody faced a problem with reusing a ref cursor?
C1 refcursor;
stmt := 'select1 ' ;
open C1 for execute stmt;
fetch C1 into rc1;
close C1;
stmt := 'select2 ...' ;
open C1 for execute stmt;
fetch C1 into rc2;
close C1;
???
I am getting inconsistent errors:
Hi,
We have seen several times a situation where a PKEY is compromised and
duplicate values are created within a table.
This has happened so far on PG 928 on Linux and Windows, and also on PG955 on
AIX.
We ran massive test on PG10.4 but it has not recreated the problem.
Has anyone faced the s
Customer is using 10.4 , not 9.5.5.
Does the same argument apply for upgrading to 10.12 ?
Thanks
Danny
-Original Message-
From: Tom Lane
Sent: Sunday, July 19, 2020 6:04 PM
To: Abraham, Danny
Cc: pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: PG 9.5.5 cores on AIX 7.1
Slow machine, high stress.
I think/hope that PG is the victim of an overstressed machine.
Has anyone faced this issue in the past?
Thanks
Danny
Segmentation fault in _alloc_initial_pthread at 0x9521474
0x9521474 (_alloc_initial_pthread+0x1d4) e803 ld
r0,0x0(r3)
Hi,
PG 9.5.5 on AIX tends to compromise Primary Key and create duplicates
when in stress and many concurrent threads updating.
Is it BUG #11141 ( Duplicate primary key values corruption ). ?
Anyone aware of a resolution for this ?
B.T.W - Looks like it happens less on Linux.
Thanks
Danny
Will setting max_parallel_workers_per_gather to 0
(In fact, no parallel queries)
Solve this issue?
I can sustain the slowness.
We are on 11.5, and the fix is on 11.6.
-Original Message-
From: Tom Lane
Sent: Sunday, May 03, 2020 5:37 PM
To: Abraham, Danny
Cc: pgsql-gene
Is there a way to eliminate postmaster crash/core ?
A surge in short-term connections eventually crashes PG on "no free slots in
PMChildFlags array".
Happens on AIX 7.2
=>grep "2020-05-02 08:16" * | grep clients | wc -l
0
=>grep "2020-05-02 08:17" * | grep clients | wc -l
0
=>gre
Agree.
I suspect that this is a mal configured pgpool - the developer thinks that the
pool is reusing connections,
While it is, in fact, reopening them.
-Original Message-
From: Tom Lane
Sent: Thursday, April 02, 2020 7:40 PM
To: Abraham, Danny
Cc: pgsql-gene...@postgresql.org
:05:37.022 CDTFATAL: sorry, too many clients already
2020-04-02 11:05:37.022 CDTFATAL: sorry, too many clients already
-Original Message-
From: Tom Lane
Sent: Thursday, April 02, 2020 6:52 PM
To: Abraham, Danny
Cc: pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: too many clients
shared_buffers
2000MB
(1 row)
-Original Message-
From: Adrian Klaver
Sent: Thursday, April 02, 2020 6:37 PM
To: Abraham, Danny ; pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: too many clients already
On 4/2/20 8:35 AM, Abraham, Danny wrote:
> Big installation: max_
Big installation: max_connections is 1200, shared_buffers is 2GB
-Original Message-
From: Adrian Klaver
Sent: Thursday, April 02, 2020 6:30 PM
To: Abraham, Danny ; pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: too many clients already
On 4/2/20 8:22 AM, Abraham, Danny wrote
No pg-bouncer or connection pooling.
ps -elf | grep postgres | grep idle | wc -l ==>61
and BTW: Running, say 500 one command psql in parallel will have the same
affect..
-Original Message-
From: Rob Sargent
Sent: Thursday, April 02, 2020 6:10 PM
To: Abraham, Danny
Cc: pgsql-g
Hi,
Will appreciate a hint here.
Running on a big and stressed AIX platform and receiving lots of "CDTFATAL:
sorry, too many clients already"
and transient difficulty to log in.
Happens on all PG versions (Tested 9.5,10.4,11.5)
Big installation: max_connections is 1200, shared_buffers is 2GB
I assume that this magic does not exist.
Am I right ?
Thanks
Danny
I assume that this magic does not exist.
Am I right ?
20181501 is illegal. Working OK.
ctrlmdb=> select to_date('20181501','MMDD')
ctrlmdb-> \g
ERROR: date/time field value out of range: "20181501"
From: Ravi Krishna
Sent: Wednesday, October 23, 2019 5:28 PM
To: Abraham, Danny ; pgsql-gene...@postgre
Hi,
The function "to_date" does not fail illegal values.
Is this a known bug?
What is the recommended type checking?
ctrlmdb=> select to_date('2018100X','MMDD');
to_date
2018-10-01
(1 row)
column?
--
273 days
(1 row)
## Postgres compatible mode
postgres=# set edb_redwood_date=off;
SET
postgres=# select date('20191001') - date('20190101');
?column?
--
273
(1 row)
-Original Message-
From: Andrew Gierth
Sent: Saturday, October 12,
aturday, October 12, 2019 7:53 PM
To: Abraham, Danny
Cc: Adrian Klaver ; pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: day interval
>>>>> "Abraham" == Abraham, Danny writes:
Abraham> The problematic code is:
Abraham> select date(cm_curr_date) - date(CM_DATE)
ng lc_time, timezone and datestyle .. but nothing seems to work
Thanks
Danny
-Original Message-
From: Adrian Klaver
Sent: Saturday, October 12, 2019 7:27 PM
To: Abraham, Danny ; Andrew Gierth
Cc: pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: day interval
On 10/12/19 8:37 A
the bug in my server, and I do
not know how.
Thanks
Danny
-Original Message-
From: Andrew Gierth
Sent: Saturday, October 12, 2019 6:26 PM
To: Abraham, Danny
Cc: pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: day interval
>>>>> "Abraham" == Abraham, Danny
Hi
A question on day interval
select date('20191001') - date('20190923');
Will provide sometimes '8' - an integer , but sometimes '8 day' - a string
How can I control it to return integer always?
Thanks
Danny
Hi,
While under Code Page 932 (=Japanese) the old PSQL 9.5.5 - used to talk plain
English, like in \d
This behavior has changed in PSQL 10. We are now forced to run "chcp 1252"
before any PSQL activity.
Does anyone know about it? Any suggestions?
I tried \encoding WIN1252. Did not work.
Tha
39 matches
Mail list logo
