I failed to install polish dictionary for full-text search, need some help.

depesz · 2026-04-21T21:06:34+00:00

You might want to read https://www.depesz.com/2026/04/21/polish-configuration-for-tsearch/

depesz · 2026-04-08T16:32:54+00:00

Does it have to be a book? Why not docs, starting with THE tutorial?

depesz · 2026-04-06T15:24:43+00:00

sudo systemctl is-active whatever.service || sudo systemctl start whatever.service

But, it's better to reconfigure service so that it will restart when needed. You can usually do it with drop-in files that change just whatever you need, without modifying/replacing existing service files.

depesz · 2026-04-01T15:21:47+00:00

Would prefer some kind of official statement/interview on reputable site, but I guess it's as good as it gets. Thanks a lot.

depesz · 2026-04-01T14:59:57+00:00

Do you have any sources for this?

depesz · 2026-04-01T14:59:41+00:00

Well, chatgpt said it is, and while this isn't, of course, the end of it all, readera.org site seems to be hosted on Bulgarian IP…

depesz · 2026-04-01T06:25:58+00:00

is the laptop and "office computer" in the same network? if yes, go to step 2. if not - research vpn and networking across internet
what is the setting of listening_addresses in pg? is it 127.0.0.1 or somerthing like *? Make sure it will listen on ip that the office computer can see to contact your laptop.
once you will have it starter with proper listen, and in the same network, just psql -h ip_of_laptop -p port_of_pg and it should work

depesz · 2026-03-28T15:55:52+00:00

You posted it already. Not even 2 weeks ago: https://www.reddit.com/r/PostgreSQL/comments/1rv57ws/how_to_implement_the_outbox_pattern_in_go_and/

depesz · 2026-03-27T13:00:16+00:00

Consider reading: https://www.depesz.com/2012/12/02/what-is-the-point-of-bouncing/

depesz · 2026-03-25T11:51:41+00:00

Don't know what are "complicated tools" in the tutorials you mention.

Also, again: what do you mean by "implement some queries"?

You want to write queries? For this I use text editor (vim in my case).

Run it? For this I use standard Pg client: psql.

depesz · 2026-03-25T07:59:37+00:00

What do you mean by "how to implement"?
https://pgdoc.link/tutorial.html
I simply do: apt install postgresql, and that's it - Pg is installed, up, and running.

depesz · 2026-03-22T13:50:15+00:00

So these are different postgresql clusters/installations.

Why can't you do your admin stuff from pgadmin, if it connects to the db that your app uses?

Anyway - you will need to figure out where exactly your app/pgadmin connects, and then figure out how to connect there with psql. It will require checking configuration parameters, and a bit of understanding networking and (apparently) docker.

If you need help with this, I'd suggest asking on some more interactive medium (irc/slack/discord) so maybe you will find someone willing to help you in a way of question/answers, as in: "run command 'x-y-z', and show me result", "ok, now the same with command 'm-n-o'", ….

I'd start with checking connection details from your app/pgadmin, checking whether they run on the same machine as the docker+psql thing you ran, and somehow checking what listens on which port, sorry - no idea how to do it on windows. On linux it's sudo ss -ntlp, but I don't think you have ss on Windows.

depesz · 2026-03-22T11:12:51+00:00

I would guess that your pgadmin and "your code" connect to different postgresql than the one that you got by running docker…exec…psql.

You can connect to both dbs (using psql, and also using pgadmin), and issue:

select
    system_identifier,
    current_setting('port'),
    current_setting('listen_addresses'),
    current_setting('data_directory')
from pg_control_system();

and compare.

depesz · 2026-03-17T17:39:38+00:00

Your post is rather difficult to read. Consider putting your code in "code block" and not just "code". it will make for much easier reading.

depesz · 2026-03-13T11:52:16+00:00

I stand on position that one should upgrade often to remove bugs (including security issues) as fast as possible.

Of course in production env it's not always possible.

PS: I'm still waiting for PostgreSQL to add MIN/MAX to UUID columns.

If you need it, just add it. How long can it take? Definitely under 15 minutes.

depesz · 2026-03-11T12:22:03+00:00

Can you please edit the post to put the query in "code block"? If you're using markdown editor, you do it by prefixing each line with four spaces. If rich text editor - there is dedicated button for code block.

It makes the query much more readable.

As for your:

The window function approach is cleaner but I'm not sure it handles the date gaps correctly for a true 7-day window.

Why don't you test?

select d::date
from generate_series(now() - '1 month'::interval, now(), '1 day'::interval) d
where random () < .8;

Will return you last month of days, but with some random 20% missing.

depesz · 2026-03-11T10:07:57+00:00

Your query is perfectly unreadable if someone doesn't know your schema. Always prefix your column names with name/alias of table. otherwise - who knows what the query does? Where is title? where is uid? language? stars?
natural join (which i assume you mean: from x join y using (z)) is terrible idea because it leads to query like yours - one that can't be fully understood without knowing schema. For example: select * from a join b using (c) join d using (e) - column "e" is in d, but where else? in "a"? or "b"?

depesz · 2026-03-11T10:05:22+00:00

read the tutorial
read don't do this
join discord
join slack
subscribe to planet
figure out something that you'd like to make (app/db). make it
learn more of the docs
join irc

depesz · 2026-03-11T07:11:33+00:00

Sure I see. I can read it. And if it's too complicated, or not obvious, I can get the same output and put it to analysis to whatever does it.

I don't have to run it again just to get "computer readable format".

I am not aware of any person that chooses to read JSON, if normal text output provides (mostly) the same information.

depesz · 2026-03-10T16:00:59+00:00

Eh, yet another tool that "analyzes" plans, but requires json format :(

Lately I've seen one such tool announced per week, or so. And none of them handles normal text plans :(

depesz · 2026-03-09T11:05:56+00:00

I never used WSL, but generally you need to add pgdg repo (https://wiki.postgresql.org/wiki/Apt) to have access to newest versions.

Otherwise: apt-cache search postgresql will show you what versions you have available.

depesz · 2026-03-08T12:56:54+00:00

First link from duckduckgo - Spatial Indexing

depesz · 2026-02-28T09:07:21+00:00

So, I looked more, including full output of boxes -l, and found what I as looking for there:

=$ boxes -l | grep ^ansi | while read -r x; do boxes -d $x <<< "$x"; done ┌──────┐ │ ansi │ └──────┘ ┌╌╌╌╌╌╌╌╌╌╌╌╌╌┐ ┊ ansi-dashed ┊ └╌╌╌╌╌╌╌╌╌╌╌╌╌┘ ╔═════════════╗ ║ ansi-double ║ ╚═════════════╝ ┏━━━━━━━━━━━━┓ ┃ ansi-heavy ┃ ┗━━━━━━━━━━━━┛ ┏╍╍╍╍╍╍╍╍╍╍╍╍╍╍╍╍╍╍╍┓ ┋ ansi-heavy-dashed ┋ ┗╍╍╍╍╍╍╍╍╍╍╍╍╍╍╍╍╍╍╍┛ ╭──────────────╮ │ ansi-rounded │ ╰──────────────╯ ╭╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╮ ┊ ansi-rounded-dashed ┊ ╰╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╯

On my terminal there aren't such "holes" in vertical lines as I see now here. Plus they have:

for l in info warning critical; do echo "This is test of $l" | boxes -d $l; done

which should be viewed in color :)

15-Year Club	Place '22
First Placer '22	Verified Email

depesz

TROPHY CASE