reSQL grants privileges on some types of objects
to PUBLIC by default when the objects are created. ..."
Thanks Markus
--
Adrian Klaver
adrian.kla...@aklaver.com
to
the public internet. You may need to talk with the provider and see how
they suggest you punch a hole through to your Postgres server.
thank you very much!
Em qui., 6 de jun. de 2024 às 12:03, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> escreveu:
On 6/6/24 07:46, M
thanks a lot
--
Adrian Klaver
adrian.kla...@aklaver.com
tandby can always use the
archive to catch up provided it retains enough segments."
This is why it is good idea to go through the links I posted above.
Regards,
Koen De Groote
--
Adrian Klaver
adrian.kla...@aklaver.com
https://yum.postgresql.org/
Available PostgreSQL Releases
Click on Postgres version number to see what distro versions are supported.
Thanks
--
Bruno Vieira da Silva
--
Adrian Klaver
adrian.kla...@aklaver.com
If you have any questions, please either email to
pgsql-pkg-...@lists.postgresql.org, or create a ticket at our redmine. "
Thanks
--
Bruno Vieira da Silva
--
Adrian Klaver
adrian.kla...@aklaver.com
Output.Result = 1;
...
Or is it impossible, because of the PGSQL's philosophy (very typed)?
If it is not possible then I have one way I think.
It is a JSON data type for inputs and outputs.
Is that right?
Thanks for your any help, info!
Best regards
dd
--
Adrian Klaver
adrian.kla...@aklaver.com
remove rows which could cause a
recovery conflict even when the standby is disconnected."
When you set up logical replication you are 'asking' via the replication
slot that WAL records be kept on the publisher until the subscriber
retrieves them.
Regards,
Koen De Groote
--
Adrian Klaver
adrian.kla...@aklaver.com
"tar" so choose it.
You are assuming facts not in evidence, namely that the format is obsolete.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 6/4/24 08:25, Ron Johnson wrote:
On Tue, Jun 4, 2024 at 10:43 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 6/4/24 05:13, Ron Johnson wrote:
> It doesn't support compression nor restore reordering like the
custom
> format, so I'm having tro
On 6/4/24 05:13, Ron Johnson wrote:
It doesn't support compression nor restore reordering like the custom
format, so I'm having trouble seeing why it still exists (at least
without a doc warning that it's obsolete).
pg_dump -d test -U postgres -Ft | gzip --stdout > test.tgz
--
Adrian Kla
,
Timo
--
Adrian Klaver
adrian.kla...@aklaver.com
a choice via a configuration
parameter?
If anything is done it would have to be new syntax.
A much bigger task surely.
On 5/30/24 5:19 PM, Adrian Klaver wrote:
2) Use INSTEAD OF triggers:
Unfortunately the same functionality as in my example with the RULE is
not supported for triggers
) Use INSTEAD OF triggers:
https://www.postgresql.org/docs/current/sql-createtrigger.html
Cheers, John Lumby
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/29/24 11:18, José Mello Júnior wrote:
Again reply to list by using Reply All.
Ccing list.
For my projects in 32 bits, the language of PC-SOFT (wlanguage) use.
Are you talking about this?:
https://windev.com/pcsoft/index.html
Em qua., 29 de mai. de 2024, 15:09, Adrian Klaver
On 5/29/24 10:59 AM, José Mello Júnior wrote:
Reply to list also.
Ccing list.
Sorry, for windows
That is the OS, what I am after is what client on Windows do you need
the DLL for?
Em qua., 29 de mai. de 2024, 14:53, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> es
On 5/29/24 10:49 AM, José Mello Júnior wrote:
Where do i found this dll for acess postgresql 15?
Access Postgres using what client?
--
Adrian Klaver
adrian.kla...@aklaver.com
:
[root@staging-ha0001 ~]# ping 10.127.1.18
PING 10.127.1.18 (10.127.1.18) 56(84) bytes of data.
From 10.127.1.10 icmp_seq=1 Destination Host Unreachable
<...>
Where are ha0001 and ha0003 on the network relative to ha0002?
Also are they reachable for other services?
--
Adrian
additional nodes" means? Include configuration
changes.
3) The error messages.
4) Where the nodes are located?
I'm seeking assistance to address this issue. My setup consists of three
nodes, each hosting both PostgreSQL and Pgpool services."
Thanks
Vijay
--
Adrian Klaver
adrian.kla...@aklaver.com
ing on. I've asked them (their IT
department, not the user) to try to disable any anti-virus software.
That's a bit of a reach, but always a possibility if something behaves
weirdly on Windows.
hp
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/25/24 22:56, David HJ wrote:
anyone know how to describe from this mailing list?
See here:
https://lists.postgresql.org/unsubscribe/
--
Adrian Klaver
adrian.kla...@aklaver.com
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
101 - 200 of 4188 matches
Mail list logo