able for each column?
It doesn't matter much if you use one or two columns.
But the word "collection" makes me worry. Perhaps this article can give
you some ideas:
https://www.cybertec-postgresql.com/en/json-postgresql-how-to-use-it-right/
<https://www.cybertec-postgresql.c
tore or pg_upgrade
or other heavy lifting. There have been exceptions, but they are rare.
Thank you so much for your time.
Phil Horder
Database Mechanic
Thales
Land & Air Systems
--
Adrian Klaver
adrian.kla...@aklaver.com
stats entry to prove it.
It would be a good idea to upgrade to 15.7 in any case to get all the
other bug/security fixes.
Phil Horder
Database Mechanic
Thales
Land & Air Systems
--
Adrian Klaver
adrian.kla...@aklaver.com
process.
Phil Horder
Database Mechanic
--
Adrian Klaver
adrian.kla...@aklaver.com
received from the postgres command line.
This only happens at login time; executing SET ROLE or SET SESSION
AUTHORIZATION does not cause new configuration values to be set.
Settings set for all databases are overridden by database-specific
settings attached to a role. Settings for specific databases or specific
roles override settings for all roles.
--
Adrian Klaver
adrian.kla...@aklaver.com
rocess that runs shortly after the drop/create lfm cycle?
Phil Horder
Database Mechanic
--
Adrian Klaver
adrian.kla...@aklaver.com
ater Avenue, Green Park, Reading, Berks RG2 6GF. Registered
Number: 868273
Please consider the environment before printing a hard copy of this e-mail.
--
Adrian Klaver
adrian.kla...@aklaver.com
ater Avenue, Green Park, Reading, Berks RG2 6GF. Registered
Number: 868273
Please consider the environment before printing a hard copy of this e-mail.
--
Adrian Klaver
adrian.kla...@aklaver.com
hat's going on? How is it that we're breaking this important function that
we shouldn't be able to have any effect on?
Thanks for looking,
Phil Horder
Database Mechanic
Thales
Land & Air Systems
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/18/24 08:04, Rich Shepard wrote:
On Sat, 18 May 2024, Adrian Klaver wrote:
... LEFT JOIN companies as c ON c.company_nbr = p.company_nbr;
Adrian,
Tried that:
bustrac-# LEFT JOIN companies as c ON c.company_nbr = p.company_nbr;
ERROR: table name "c" specified more than o
c.company_nbr = p.company_nbr;
^
and that didn't work either.
The query needs to be:
SELECT p.lname, p.fname, p.job_title, p.company_nbr, p.email, c.company_name
FROM people as p
LEFT JOIN companies as c ON c.company_nbr = p.company_nbr;
Only reference companies as c once.
Thanks,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
tf8/UTF-8 doesn't matter?
but TBH, I doubt it's worth worrying about.
But couldn't there be an issue, if for example the client's locale and
the server's locale aren't exactly the same? I'm thinking maybe the
client library has to perform unneeded translation of the stream of data
to/from the database?
--
Adrian Klaver
adrian.kla...@aklaver.com
this with this result:
ERROR: missing FROM-clause entry for table "c"
LINE 3: LEFT JOIN companies ON c.company_nbr = p.company_nbr;
... LEFT JOIN companies as c ON c.company_nbr = p.company_nbr;
Thanks for the suggestion.
Regards,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
e is omitted the password will
be valid for all time.
Regards
A.Rama Krishnan
--
Adrian Klaver
adrian.kla...@aklaver.com
for help.
```
Regards
A.Rama Krishnan
On Tue, May 14, 2024 at 8:57 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 5/14/24 00:57, Rama Krishnan wrote:
> Hi team,
>
> I have a question about the "valid until" parameter in the
if an autovacuum action is skipped due to a
conflicting lock or a concurrently dropped relation.
Thanks for your time.
Phil Horder
Database Mechanic
Thales
Land & Air Systems
--
Adrian Klaver
adrian.kla...@aklaver.com
Park, Reading, Berks RG2 6GF. Registered
Number: 868273
Please consider the environment before printing a hard copy of this e-mail.
--
Adrian Klaver
adrian.kla...@aklaver.com
ered
Office: 350 Longwater Avenue, Green Park, Reading, Berks RG2 6GF. Registered
Number: 868273
Please consider the environment before printing a hard copy of this e-mail.
--
Adrian Klaver
adrian.kla...@aklaver.com
Thales UK Limited. A company registered in England and Wales. Registered
Office: 350 Longwater Avenue, Green Park, Reading, Berks RG2 6GF. Registered
Number: 868273
Please consider the environment before printing a hard copy of this e-mail.
--
Adrian Klaver
adrian.kla...@aklaver.com
e sets a date and time after which the role's
password is no longer valid. If this clause is omitted the password will
be valid for all time.
"
When did the user log in?
What is the TimeZone setting in the database?
Thanks
Ram
--
Adrian Klaver
adrian.kla...@aklaver.com
s an experiment, I'm just pounding the server with a single connection
doing nothing but SET TIMEZONEs repeatedly. So far, no break, but it is
*very* intermittent."
May not induce the error unless there are parallel workers involved.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/13/24 11:02 AM, Christophe Pettus wrote:
On May 13, 2024, at 10:58, Adrian Klaver wrote:
You sure the timezone file did not get changed under the connection?
Yes (at least, nothing happened on the system that would indicate that). The
system wasn't touched during the execution
On 5/13/24 10:50 AM, Christophe Pettus wrote:
On May 13, 2024, at 10:48, Adrian Klaver wrote:
Yes:
https://www.postgresql.org/message-id/5DF49366-10D1-42A4-99BF-F9A7DC3AB0F4%40mailbox.org
Answer:
https://www.postgresql.org/message-id/1273542.1712326418%40sss.pgh.pa.us
Thanks
) filter (where visited > 0) from framework_seenchoice
",,,"","client backend",,0
It's not (easily) repeatable, and the system was not touched while the process
was running (no installing new binaries, etc.). Does this look familiar to
anyone?
Yes:
https://www.post
the old values as the data change in
session #1 has not committed and therefore the new values are not seen
by other sessions.
Daniel McKenzie
Software Developer
--
Adrian Klaver
adrian.kla...@aklaver.com
t a hiccup so we are
surprised to learn that we have this massive race condition and it just
I would not say "...perhaps 1 in 50 times" is massive.
so happens that the hardware is fast enough to process the transaction
before the .NET application can react to replication slot changes
nsaction is truly committed (that is, it is
guaranteed not to be lost if the server crashes). ...
"
Daniel McKenzie
Software Developer
--
Adrian Klaver
adrian.kla...@aklaver.com
off". We cannot reproduce the issue with synchronous_commit set to
"off".
What is running on the EC2 instance?:
1) The Postgres server.
2) The replication receiver.
3) Both.
We need help to understand this unexpected behaviour.
We are using Postgres 14.10.
Thanks,
Dani
be done by background housekeeping processes
though (a/k/a autovacuum).
I believe Oracle, for one, actually does use UNDO. I don't know
what they do about failure-to-UNDO.
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/7/24 08:24, Adrian Klaver wrote:
On 5/7/24 02:38, HORDER Philip wrote:
Thanks for your time Adrian
1) What is the exact pg_restore command you are using?
2) From earlier post: '... only analyzes tables in the new db at the
point of reload, then shuts off again.' Provide
8273
Please consider the environment before printing a hard copy of this e-mail.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/6/24 07:42, Adrian Klaver wrote:
On 5/6/24 04:05, Matthias Apitz wrote:
I see three different versions of OpenSSL:
OPENSSL_1_1_1d -- From error messsage
OpenSSL 1.1.1l-fips -- SuSE 15 version
OpenSSL 1.1.1t -- Your built version?
Are you sure you pointing
EVP_KDF_CTX_free
EVP_KDF_derive
I have a complete different OpenSSL 3.0.x environment: all OpenSSL
consumers use /usr/local/sisis-pap.sp01/lib/libssl.so.3, also
PostgreSQL and pg_tde have been compiled against this; and this
runs fine with 'pg_tde'.
What the avove error means?
Thanks
ir choice more power to them, making \d more
accessible for them is a win and snake case people won’t notice or care.
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/3/24 17:35, Bruce Momjian wrote:
On Fri, May 3, 2024 at 05:29:34PM -0700, Adrian Klaver wrote:
From here:
https://www.enterprisedb.com/
#1 IN POSTGRES
THE MOST ADMIRED, DESIRED, & USED DATABASE.
is not helpful.
Though I would say the bigger issue is here:
https://www.postgresql
ttps://www.postgresql.org/download/
Where you have
Packages and Installers
and then further down
3rd party distributions
It tends to imply that the 'Packages and Installers' are not third
party, when they are to some degree or another.
--
Adrian Klaver
adrian.kla...@aklaver.com
I'd really appreciate some direction on this. Thanks.
AJ ONeal
--
Adrian Klaver
adrian.kla...@aklaver.com
properly cased name.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
--
Adrian Klaver
adrian.kla...@aklaver.com
lass where relname ilike
'%some_idIds%';
Best guess there are hidden characters.
owner is "cron_user". \dt shows cron_user is the owner of the table.
--
Adrian Klaver
adrian.kla...@aklaver.com
Did you wait to see if activity after the pg_restore crossed the
autovacuum thresholds?
--
Adrian Klaver
adrian.kla...@aklaver.com
to, with one set of users (SU)
We have another database, let’s call it LFM, which contains reference
data for some COTS software. I don't know what's in it, we just get
given updates for it in pg_backup binary files, about 2MB each.
Do you mean pg_basebackup, pg_dump or something else?
--
Adrian
kends_y2024w04
db1 schema1 subpartitions backends_y2024w05
The partitioning must be the problem somehow.
--
Adrian Klaver
adrian.kla...@aklaver.com
ables have dead tuples
You have something against providing actual numbers?
The point is there is really nothing to be gained by doing VACUUM FULL
if the dead tuples are some small percentage of the tables.
--
Adrian Klaver
adrian.kla...@aklaver.com
tables, which take up
the most space)
By the way, excuse me if I make a few mistakes (especially when
replying), this is the first time I've used Postgres community support
directly
Le lun. 29 avr. 2024 à 16:37, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> a écrit :
On 4/29/
How much current free space do you have available on the disk?
Did you VACUUM FULL a table at a time or all of them at once?
What are the individual tables sizes?
Le lun. 29 avr. 2024 à 16:19, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> a écrit :
On 4/29/24 06:45,
ve the
database the ability to recycle the vacuumed tuple space.
--
Adrian Klaver
adrian.kla...@aklaver.com
or. However, I'm reaching out to seek clarity on why this
disparity is occurring and to explore potential strategies for
mitigating it (as I want the behaviour to be consistent to regress test
file).
I would say your best option is to file an issue here:
https://github.com/citusdata/postgresql-
On 4/25/24 00:46, Kashif Zeeshan wrote:
I worked with both CentOS/RHEL 7/8.
What does the above mean relative to the original question?
--
Adrian Klaver
adrian.kla...@aklaver.com
are taking pg_basebackup backup.
Backup File size=613G
Backup Running Duration: 8 Hours
--
Thanks & Regards,
Jayakumar.S
+91-9840864439.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/22/24 14:54, Atul Kumar wrote:
I mean, Once I change the hostname then how will the socket read the new
hostname ? Does it require a postgres service restart ?
The host name of the machine?
On Tue, Apr 23, 2024 at 3:19 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>&
ns
what you are really after.
Sorry. Got distracted by the answer.
https://dba.stackexchange.com/questions/338870/when-to-rerun-cluster
<https://dba.stackexchange.com/questions/338870/when-to-rerun-cluster>
--
Adrian Klaver
adrian.kla...@aklaver.com
n using sockets.
* Using a socket name makes parameterizing the hostname easier in
scripts.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/22/24 13:59, Ron Johnson wrote:
On Mon, Apr 22, 2024 at 4:21 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
[snip]
Which gets us back to your comment upstream:
"What the VACUUM docs "should" do, it seems, is suggest CLUSTER on the
PK,
the "host".
Regards.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/22/24 12:51, Ron Johnson wrote:
On Mon, Apr 22, 2024 at 3:14 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
1) If they are already in enough of a PK order that the CLUSTER time vs
VACUUM FULL time would not be material as there is not much or any
comment. I keep on wanting to believe that ALTER
TABLE supports GENERATED expressions, when it only supports GENERATED
IDENTITY:)
--
Adrian Klaver
adrian.kla...@aklaver.com
eleted based on CREATED_ON? I understand the correlation
between CREATED_ON and the PK just not sure why that would necessarily
translate to an on disk order by PK?
--
Adrian Klaver
adrian.kla...@aklaver.com
urrent/sql-createtable.html
GENERATED ALWAYS AS ( generation_expr ) STORED
So:
generated always as (DATE_PART('year', evtdate)::integer) STORED
--
Adrian Klaver
adrian.kla...@aklaver.com
at you want to clean out. Given
the temporary nature of the effects of a CLUSTER under a change load I
don't see why it would be the way to go to clean up a changing table.
That's because the data is already roughly in PK order.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/21/24 14:21, Tom Lane wrote:
Adrian Klaver writes:
On 4/21/24 11:20, yudhi s wrote:
So in this case i was wondering if "event trigger" can cause any
additional threat and thus there is no such privilege like "create
trigger" exist in postgres and so it should b
So in this case i was wondering if "event trigger" can cause any
additional threat and thus there is no such privilege like "create
trigger" exist in postgres and so it should be treated cautiously?
An event trigger runs as a superuser and executes a function that in
turn
On 4/21/24 02:35, Lok P wrote:
On Sat, Apr 20, 2024 at 10:02 PM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
Have you tried?:
https://www.postgresql.org/docs/current/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT
<https://www.postgresql.org/docs/curren
threat and if any option to
get this logging enabled (which will help us debug performance issues)
at same time addressing the threat too?
I should have added to previous post, if you have access to the database
the security wall has already been breached.
Regards
Lok
--
Adrian Klaver
(which will help us debug performance issues)
at same time addressing the threat too?
Regards
Lok
--
Adrian Klaver
adrian.kla...@aklaver.com
https://www.postgresql.org/docs/11/sql-copy.html
"where option can be one of:
FORMAT format_name
OIDS [ boolean ]
"
And Postgres 11 is ~6 months past EOL.
--
Adrian Klaver
adrian.kla...@aklaver.com
. (Refreshing it from the MySQL server will result in one
that has records that have been added or updated rather than an exact
copy of the one on the production serve
Use postgres_fdw to connect the test bed to the production server?
Mike Nolan
htf...@gmail.com
--
Adrian Klaver
adrian.kla
o the specified capabilities and
information."
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/16/24 12:39, veem v wrote:
On Sat, 13 Apr 2024 at 21:44, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 4/13/24 00:03, veem v wrote:
> Thank you Adrian.
>
> So it seems the heavy DML tables will see an impact if having
triggers
em' answer. And there is a difference
between dumping data into a table and then doing an UPGRADE where the
data strings are manipulated by functions.
Anyway, I hope I answered your questions.
Thanks for your help.
On Sunday, April 14th, 2024 at 4:28 PM, Adrian Klaver
wrote:
On 4/14/24 13:18,
that someone else can take over, so everything needs to
be as simple as possible.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/14/24 12:22, jack wrote:
Here is an excerpt of /var/log/postgresql/postgresql-16-main.log
Where and how are the CSV files being produced?
What is the database locale?
--
Adrian Klaver
adrian.kla...@aklaver.com
dified) - 1) WHERE LENGTH(category_modified)>1 AND
category_modified LIKE '%-';
Is the above all being done in one script/transaction?
Again what are the table definitions for the tables being copied into
and/or modified?
--
Adrian Klaver
adrian.kla...@aklaver.com
d into.
3) Sample of the data being copied.
4) The error message(s) generated.
5) Database locale
Any help would be greatly appreciated.
Thank you
--
Adrian Klaver
adrian.kla...@aklaver.com
be different in Postgres?
What type of triggers where there in Oracle, per row, per statement or a
mix?
On Thu, 11 Apr 2024 at 22:00, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 4/11/24 07:31, veem v wrote:
> Hi, We used to use Oracle database in which
updating('create_timestamp') THEN
:new.create_userid := :old.create_userid;
:new.create_timestamp := :old.create_timestamp;
END IF;
:NEW.update_timestamp := systimestamp;
:NEW.update_userid := sys_context('USERENV','SESSION_USER');
END IF;
END;
/
Regards
Veem
-
On 4/10/24 1:31 PM, Tom Lane wrote:
Adrian Klaver writes:
On 4/10/24 12:38, Adnan Dautovic wrote:
By the way, the row count of pg_timezone_names is 385, but I do
not know how that compares to a more standard installation.
On my instance of Postgres 16.2, 1196.
You're probably using
regards,
Adnan Dautovic
--
Adrian Klaver
adrian.kla...@aklaver.com
and inexpensively!
So, recommendation and possibly some consensus would be very much
appreciated.
And apologies if I have taken up too much of your time or have placed
this in the wrong forum.
John
--
Adrian Klaver
adrian.kla...@aklaver.com
15:00-07
1 | 2024-04-01 09:45:00-07
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/9/24 9:16 AM, Lok P wrote:
On Tue, Apr 9, 2024 at 9:26 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 4/9/24 08:43, Lok P wrote:
> Hi All,
> It's version 15.4 of postgresql database. Every "date/time" data
type
ount of transactions from a table-
transaction_tab and share it with another person/customer who is in the
EST timezone, so basically the transaction has to be shown or displayed
the EST timezone.
What is the datatype for the create_timestamp?
What does SHOW timezone; return on the server?
On 4/9/24 08:12, Thiemo Kellner wrote:
Thanks for taking this up.
Am 09.04.2024 um 17:09 schrieb Adrian Klaver:
On 4/9/24 07:59, Thiemo Kellner wrote:
[Code: 0, SQL State: 0A000] ERROR: References to other databases are
not implemented: pg_catalog.pg_roles.rolname
Position: 298 [Script
cute V_SQL_STATEMENT;
commit;
return;
end;
$body$;
--
Adrian Klaver
adrian.kla...@aklaver.com
hat PostgreSQL version are you using? The feature was introduced
in v11.
How exactly is the publication defined? Perhaps TRUNCATE is excluded.
Yours,
Laurenz Albe
--
Adrian Klaver
adrian.kla...@aklaver.com
should reach out to their tech support.
Thanks!
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/6/24 13:04, yudhi s wrote:
On Sat, Apr 6, 2024 at 10:25 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
Your original problem description was:
"Then subsequently these rows will be inserted/updated based on the
delta number of rows that got in
hard rule, then yes up to some point just
replacing the data in mass would be the simplest/fastest method. You
could cut a step out by doing something like TRUNCATE target_tab and
then COPY target_tab FROM 'source.csv' bypassing the INSERT INTO source_tab.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/5/24 02:39, Adnan Dautovic wrote:
Dear Adrian,
Adrian Klaver wrote:
Define 'read-only', especially as it applies to the privileges on the
public schema.
I am not quite sure which information you are looking for
exactly. According to this [1], I ran the following query:
WITH "
On 4/4/24 13:42, yudhi s wrote:
On Thu, Apr 4, 2024 at 9:04 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 4/3/24 22:24, yudhi s wrote:
>
> On Thu, Apr 4, 2024 at 10:16 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>
&g
On 4/3/24 22:24, yudhi s wrote:
On Thu, Apr 4, 2024 at 10:16 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 4/3/24 20:54, yudhi s wrote:
> On Thu, Apr 4, 2024 at 2:41 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>
> <mailto:adri
or me?
Kind regards,
Adnan Dautovic
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/3/24 20:54, yudhi s wrote:
On Thu, Apr 4, 2024 at 2:41 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 4/3/24 13:38, yudhi s wrote:
> Hi All,
> It's postgresql database version 15.4. We have a requirement in
which
> we will be ini
records faster in the target database, while making the
system online to the users?
Regards
Yudhi
--
Adrian Klaver
adrian.kla...@aklaver.com
'pandora distrib'?
--
Adrian Klaver
adrian.kla...@aklaver.com
log 1' create_date.
Read:
https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
--
Adrian Klaver
adrian.kla...@aklaver.com
ds,
Venkat
Internal Use - Confidential
-Original Message-----
From: Adrian Klaver
Sent: Wednesday, March 27, 2024 9:32 PM
To: Bandi, Venkataramana - Dell Team ; Greg Sabino
Mullane
Cc: pgsql-general@lists.postgresql.org; Kishore, Nanda - Dell Team
; Alampalli, Kishore
Subject:
out with an access denied message. So I wanted to understand the
cause of this and how we should fix it , such that anybody logging in
through that role can see/fetch the data from the cron and partman
schema tables.
grant select on cron.job to ;
grant select on cron.job_run_details to ;
grant
want to stay with DBeaver post the actual complete error
message here.
Thanks,
Arun
--
Adrian Klaver
adrian.kla...@aklaver.com
.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/28/24 07:25, Daniel Gustafsson wrote:
On 28 Mar 2024, at 15:22, Adrian Klaver wrote:
On 3/28/24 04:56, 김명준 wrote:
Hello,
I am deeply fascinated by the powerful features and flexibility of PostgreSQL
and wish to share it with more Korean speakers. I am interested in contributing
1 - 100 of 4067 matches
Mail list logo