of last change. We've not regretted it
and moderate hardware deals well with the overhead (500+ table database, 80+
concurrent users, 18 million audit records a month).
--
Tim Clarke MSc, BSc (Hons), MBCS
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
[https://i0.wp.com/w
That’s excellent Chris, thanks very much for doing that. Concise, informative
and targeted. Is there a mailing list for updates?
--
Tim Clarke BSc (Hons), MBCS
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
From: Chris Travers
Sent: Thursday, March 9, 2023 3:24 AM
To: pgsql
be every millisecond.
[cid:part1.48305BC8.064CE40A@minerva.info]
Regards
Francois
It appears that you have a process running on your Postgres server that is
repeatedly trying to connect to the database. Is this running on a server or a
workstation? Check your users, cron jobs?
Tim Clarke
gt;
> FWIW, we’re not a Web dev shop.
>
> Cheers
> Philip
We have a a great amount of our business logic in triggers; makes for
light, multiple and consistent front-ends. It's worked very well for
many years and continues to grow.
Tim Clarke
Telephone: Witham: +44(0)1376 50
the server emitted
> into the log file in a case like this? I looked through the server
> documentation and don't see an option that would clearly alter this
> behavior.
>
> Thank you,
>
> Alan
Raise info?
Tim Clarke MBCS
IT Director
Direct: +44 (0)1376 504510 |
One cron job running every 5 minutes should do?
Tim Clarke MBCS
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt:
+49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1 647 503 284
same effect with a
well-crafted query that targetted only those that might possibly expire.
Then you'd have only one cron job to manage.
Tim Clarke MBCS
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 |
ch would make the
necessary expiry tests and set the status accordingly. Maybe run the
cron once an hour or once a day depending on the granularity of your needs?
Tim Clarke MBCS
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
Telephone: Witham: +44(0)1376 503500 | London: +4
lane
That nailed it Tom, thanks.
Tim Clarke MBCS
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt:
+49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1 647 503 2848
Web: https://
uentially. I’m not sure it works
> well when I need to add a cron job for each newly joined member.
>
> —
>
> I’m not aware any other solutions. But the problem seems banal, and I believe
> it has been solved for a long time. Would really appreciate it if someone
> could at lea
w" on a user with the
mygroup role selecting from schema2.usingview? The same user can select from
schema1.matview without issue?
I must be tired and I can't see why that should fail.... :(
--
Tim Clarke
Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankf
David
We've had excellent results with
https://www.postgresql.org/docs/13/fuzzystrmatch.html
and you may find
https://www.postgresql.org/docs/13/unaccent.html
very useful in this area too
Tim Clarke MBCS
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
Telephone: Witham:
good implementation. The biggest failure
it has is that you must know exactly how many output columns you will have in
the result prior to running it
Tim Clarke MBCS
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20
by default).
Remove any "#" (hash or pound) symbol from the beginning of the line then
restart Postgres.
Tim Clarke MBCS
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt:
+49 (0)69 719
the “execute” stuff comes from.
David J.
Given that PostgreSQL isn't throwing the error, I'd suggest the rollback is
from a decision in the front-end application layer.
Tim Clarke MBCS
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
Telephone: W
that it
would need either a desktop change per user or a translation table. You can
find all the changes though and do them all at once which saves your "next day,
next day" issue?
Tim Clarke
Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Fr
;
> If performance is important or you don't want to depend on third-party
> modules,
> post the code to PL/Python or PL/Perl. If the code is just glue around some
> SQL,
> PL/pgSQL might be the best choice.
>
> Yours,
> Laurenz Albe
+1 for PL/Java, we've been us
oal, I'm all ears :-)
Thanks in advance for any replies/ideas !
How many users do you have to identify? Have them log in to your application
and thence to PG then you can pick up the PG CURRENT_USER var?
Tim Clarke
Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853
Why would you shun the ease of command line batch control?
Tim Clarke MBCS
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 10/07/2020 17:36, rwest wrote:
Oh sorry, should have specified that.
We're running on a Windows platform.
We're trying to avoid runnin
On 02/06/2020 19:43, Stephen Frost wrote:
>> But require a new port, and Enterprises have Processes that must be followed.
> Sure they do. Automate them.
>
> :)
>
> Thanks,
>
> Stephen
+1 for automation, isoX != slow
Tim Clarke MBCS
IT Director
Direct: +44 (0)1376 5
Postgres.
This has given Postgres a big, fat black eye with our end users.
--
Angular momentum makes the world go 'round.
But that's nothing to do with Postgres; it takes two weeks because you have
broken procedures imho
Tim Clarke
Telephone: Witham: +44(0)1376 503500 | Lo
Kafka.
Tim Clarke MBCS
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 08/05/2020 17:26, David Gauthier wrote:
psql (9.6.0, server 11.3) on linux
Looking for ideas. I want a trigger to...
1) compose an html report based on DB content
2) email the report to a dist list (dl = val
Arden
Your first argument is a JDBC connection string (see here
https://jdbc.postgresql.org/documentation/80/connect.html). To provide
the details when using the command line psql command, use the -h, -p and
-U parameters (https://www.postgresql.org/docs/12/app-psql.html)
Tim Clarke
IT Director
There's always a good time to re-examine that :D
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 02/03/2020 15:52, Ron wrote:
> LOL. Double LOL, even. We -- and a huge number of other
> organizations -- are completely wrapped in the Windows environm
Not at all, we found that Linux "expertise" is 1/10 the cost of Windows
expertise. Time to plan for getting rid of the site license.
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 02/03/2020 15:32, Ron wrote:
> Your comment assumes that OP does *n
But why even bother paying for MS licenses? Postgres runs like a train
on Linux. Save your money.
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 02/03/2020 15:01, Roberto Della Pasqua wrote:
>
> Well,
>
> on Windows you should try ReiserFS over a nv
my computers and put Linux on them and just use a different
client.
Jason L. Amerson
+1
Libreoffice has a quick and easy database front end. Not great but functional
and effort free.
--
Tim Clarke
Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt:
+49 (0)69
Select data source" dialog
5) You should then see the list of tables etc from your Postgres database
Troubleshooting; make sure you have an ODBC 32 or 64 bit version
matching the 32 or 64 bit MS Access installed.
If you use any security at the MS Access level you will need to set up a
simul
The ODBC drivers are generally very useful.
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 23/11/2019 12:23, Jason L. Amerson wrote:
>
> Thanks
>
> Jason L. Amerson
>
> *From:* Daniel Baktiar
> *Sent:* Saturday, November 23, 2019 07:
uess.
Pretty sure if you run through Oracle's back catalogue you'll find a
similar data corruption for an entirely unrelated reason. Just guessing
but chances are
Tim Clarke
Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt:
+49 (0)69 7191 6000 | Hong Ko
and auditing enforced by the database. In this
> scenario, would it make sense to have a user account on the database
> to mirror the user account from the web app? Is that an unusual practice?
Not at all, we're doing it
Tim Clarke
Telephone: Witham: +44(0)1376 503500 | Lond
y from it.
Sharing code has challenges and it is horribly aggressive with caching
unless you use un-bound forms and write all the CRUD interface code
yourself.
Tim Clarke
Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt:
+49 (0)69 7191 6000 | Hong Kong: +852 58
All excellent solutions, may I add Lucee to the list. We call it "the
best web development system no-one knows about".
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 07/08/2019 21:38, Rich Shepard wrote:
> On Wed, 7 Aug 2019, Igor Korot wrote:
&
specific program that is good at its job is the unix way and
better for it imho. If you have a good scheduler why re-write another
one into every application?
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20
erify correct hostname.
>
> 4) Check to see if there is a firewall blocking the Postgres server port.
>
>>
>> Thanks
>> Mahesh Ravilla
>>
>
Looks like that (dns?) symbol azure_server_name points to a broken IP
address?
Tim Clarke
IT Director
Direct: +4
I've been enjoying dbeaver for this
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 24/06/2019 23:38, Adrian Klaver wrote:
> On 6/24/19 3:25 PM, David Gauthier wrote:
>> Hi:
>>
>> I've been poking around
>
There's nothing really "in" a sequence, it just generates numbers for
you, generally for unintelligent primary keys. Those statements
perfectly create new sequences which will start from 1.
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 24/06/2
alidHeapAttributeNumber offset, so that seems like a possible
> problem.
>
> However, I can't quite reproduce this. There are various other checks
> that prevent this scenario, but it's plausible that with a bit of
> whacking around you could hit this error message.
>
Prom
a test setup not your live servers).
> Presumably there's something in the subscription-alteration logic
> that needs work, but I don't think we have enough detail here for
> somebody else to reproduce the error without a lot of guesswork.
>
> regards, tom lane
I'll do wha
3) Add primary key on slave.
4) Refresh subscription on slave; error starts being reported.
I've cleared it by dropping the slave database, re-creating from the
live schema then fully replicating. Its all running happily now.
Tim Clarke
Main: +44 (0)1376 503500 | Fax: +44 (0)1376 503550
Web:
Dang. I just replicated ~380 tables. One was missing an index so I
paused replication, added a unique key on publisher and subscriber,
re-enabled replication and refreshed the subscription.
The table has only 7 columns, I added a primary key with a default value
from a new sequence.
Tim Clarke
I'm getting this message every 5 seconds on a single-master,
single-slave replication of PG10.7->PG10.7 both on Centos. Its over the
'net but otherwise seems to perform excellently. Any ideas what's
causing it and how to fix?
--
Tim Clarke
IT Director
Direct: +44 (0)1376 50451
On 28/03/2019 11:10, Andy Anderson wrote:
Would this also select characters with diacritical marks? For example,
eid | ename
-+---
1 | aaa
2 | AAA
3 | áäâ
4 | āåȧ
— Andy
For that you need https://www.postgresql.org/docs/10/unaccent.html
Tim Clarke
Main: +44 (0)1376
we'd need to come up with some
major engineering patches.
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 11/03/2019 19:20, Gavin Flower wrote:
> On 12/03/2019 05:35, Michael Nolan wrote:
> [...]
>> MySQL is better at isolating users from each o
submit changes (transaction)
Is there any after-market tool for PG that does something like this ?
Have a look here https://www.postgresql.org/download/product-categories/
under "Administration/Development". I'm using pgAdmin right now.
Tim Clarke
and
wb.fid = f.id), 0)) as score
FROM
rating.cy, rating.d, f
WHERE
d.cid = f.cid AND f.cid = cy.cid AND f.ye = cy.ye
GROUP BY
1, 2
LIMIT 1;
Tim Clarke
> road or implementing something myself, I ask. Maybe this design is no
> good at all.
>
> Kind regards
>
> Thiemo
>
>
Why not just call your "do a scheduled run" code from cron?
Tim Clarke
2
LIMIT 1;
I've trimmed it down to even just one row and it still causes the
warning "pg_dump: [archiver] WARNING: archive items not in correct
section order"
It yields this data:
id | ytext | score
---+--+---
5 | 1996 | 0
--
Tim Clarke
On 27/08/18 15:22, Tom Lane wrote:
> Tim Clarke writes:
>> Last night for the first time our pg_dump backup threw this error for
>> the first time. Repeated runs this morning consistently throw it too.
> That's not supposed to happen. Can you create a test case, by any cha
rhel6
@pgdg10
--
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
Main: +44 (0)1376 503500 | Fax: +44 (0)1376 503550
Web: https://www.manifest.co.uk/
Minerva Analytics Ltd
9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | En
ther psql or
pgAdmin; they execute it against the current database.
Tim Clarke
On 03/08/18 09:53, Ze Victor Harry wrote:
> hello again I have a small problem here can someone tell me briefly
> how to do it? I am getting this error
>
>
> When I give ant fresh_install
Ah thanks, I stand corected! :)
Tim Clarke
On 16/07/18 15:04, Josef Šimánek wrote:
> It is licensed under MIT - https://github.com/Microsoft/vscode.
>
> 2018-07-16 13:09 GMT+02:00 Tim Clarke :
>> -1 for VSC not being open source
>>
>> Tim Clarke
>>
>>
-1 for VSC not being open source
Tim Clarke
On 16/07/18 11:47, Dmitry Igrishin wrote:
>
>
> пн, 16 июл. 2018 г. в 13:41, Tim Clarke
> <mailto:tim.cla...@minerva-analytics.info>>:
>
> +1 for not re-inventing the wheel - building on Netbeans or the
> Eclips
+1 for not re-inventing the wheel - building on Netbeans or the Eclipse
project would save you heaps of time and effort and provide
cross-platform out of the box. I use Eclipse all the time.
Tim Clarke
On 15/07/18 20:41, Chuck Davis wrote:
> If you decide to proceed on this project there&#
eatures like Code Completion, Object Explorer and
>> Data
>> Editor which help users create, develop and execute queries as well
>> as edit
>> and adjust the code to their requirements in a convenient and
>> user-friendly
>> interface./
>
> (snip...)
>
n error safeguards.
>
> Olegs
How about execution limits, Olegs?
Tim Clarke
smime.p7s
Description: S/MIME Cryptographic Signature
> Almost all languages have a "module" to interact with Postgres databases.
> The best one is IMHO the one you know the best.
>
> P.S.
> The differences between a local Unix socket and a TCP one are rather
> subtle from your point of view.
>
+1 for pgadmin - indeed why bother with anything else for one flat
table? How many rows of data do you envisage?
--
Tim Clarke
smime.p7s
Description: S/MIME Cryptographic Signature
PG10 is happily in production - in active use here :)
Tim Clarke
IT Director
Manifest
Tel: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420 |
Main: +44 (0)1376 503500 | Fax: +44 (0)1376 503550
Blog: https://blog.manifest.co.uk/ <https://www.manifest.co.uk/> | Web:
https://www.manifest.co.
58 matches
Mail list logo
