Re: Running concurrent txns and measuring the timings in Postgres
On 25/7/19 5:24 AM, Souvik Bhattacherjee wrote:
> I got this thing running and hopefully works as expected. The txns are
> stored in insert_txn1.sql, insert_txn2.sql, ...
> Please let me know if you find any issues with this.
> Script is attached.
>
Even if you're using the ancient Bash version 3 (AFAIK only macOS still
uses it out of the box), about half the lines are unnecessary:
#!/bin/bash
SECONDS=0
for i in {1..4}
do
psql -d mydb -f insert_txn${i}.sql &
done
wait
echo "Elapsed time: $SECONDS secs"
Read the bash man page to understand that SECONDS "magic", and why I
didn't bother with PIDs at all. I also fixed a variable-dereferencing
bug in your original script ("insert_txn[$i].sql" literally expands to
"insert_txn[1].sql", etc.)
Best Regards,
Adrian
Re: Backup & Restore
On 24/2/20 4:18 pm, Dor Ben Dov wrote: > > Hi All, > > > > What is your backup and restore solution in production when working > with Postgres ? > > (+ if you can say few words why you picked this X solution instead of > others) > This is the THIRD time you've asked the same question with minimal rephrasing, and without clarifying details: https://www.postgresql.org/message-id/AM0PR06MB4817A7035134FD88B2C1D033CC550%40AM0PR06MB4817.eurprd06.prod.outlook.com https://www.postgresql.org/message-id/AM0PR06MB4817DD9C64FE02410478DF65CC280%40AM0PR06MB4817.eurprd06.prod.outlook.com If you weren't satisfied with the answers you got the first two times, kindly be clear about what you're really looking for. Thanks much! -- Best Regards, Adrian
Re: OpenSSL@1.1 not getting linked with Homebrew - trying to install postgresql
On 12/4/22 18:33, cecile rougnaux wrote: My system is OS Mojave 10.14.6, I got homebrew from this command : /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)" when I try to install postgresql with the command brew install postgresql I have this error: Error: An exception occurred within a child process: RuntimeError: /usr/local/opt/openssl@1.1 not present or broken Please reinstall openssl@1.1. Sorry :( When I try to install openssl@1.1 I have this message: Note that the error message is literally asking you to: brew reinstall openssl@1.1 not: brew install openssl@1.1 and not: brew reinstall openssl Do the reinstall and see if the postgresql formula works now. If it still doesn't work, the Homebrew discussions forum is a more appropriate place to follow up: https://github.com/Homebrew/discussions/discussions Also: brew link openssl@1.1 and all the exports you said you added to your .zshrc should not be needed, so you should: brew unlink openssl@1.1 and revert all your additions. -- Best Regards, Adrian
Re: Error dydl : image not found when trying to install pg on Catalina
On 17/4/22 19:28, cecile rougnaux wrote: I upgraded my system to Catalina 10.15.7 and now I get an error with dyld : image not found when trying to install postgresql : [...] dyld: Library not loaded: /usr/local/opt/icu4c/lib/libicui18n.70.dylib Referenced from: /usr/local/Cellar/postgresql/14.2_1/bin/postgres Reason: image not found Your icu4c installation is likely broken somehow. Try: brew reinstall $(brew deps postgresql) postgresql to reinstall PG and all its dependencies. -- Best Regards, Adrian
Re: bottom / top posting
On 7/6/21 8:05 pm, Vijaykumar Jain wrote: I hear a lot of suggestions wrt bottom / top posting. To be pedantic, the preferred posting style seems in fact to be *inline trim-posting*, i.e. * your responses are immediately below the text you're replying to, so the context is immediately apparent * anything not relevant to your response is removed Pure bottom-posting seems to be acceptable too, but if you're responding to multiple quotes, inline posting is *much* friendlier to the reader. -- Best Regards, Adrian
Re: Even more OT: Ditto machines [was: bottom / top posting]
On 11/6/21 4:52 am, Dean Gibson (DB Administrator) wrote: Tom mentioned "old-timers." Remember "Ditto" machines? Remember the odor? They were in common use when I was in high school (1960). https://en.wikipedia.org/wiki/Mimeograph Was intimately acquainted with them during my military service. Had the "privilege" of cutting the majority of each day's stencils, because I was the fastest typist in the clerical pool...and because I was the only "freak" who actually found mental peace while literally cranking out daily orders. -- Best Regards, Adrian
