2634
English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
PostgreSQL Person of the Week interview with: Vasilis Ventirozos
https://postgresql.life/post/vasilis_ventirozos/
For me, it doesn't matter much — whether it is just a database filling with the answers (either personal requireter's database or company seeking to grow it's social network data lake) or someone is looking for drops (btw, looks like carders do that more frequently than state agents).
It's not a job opportunity, therefore it's a scam.
This might just as well being Russia looking for new throwaway agents 🤔
Читать полностью…
@NickBluth do you agree with this? I would require for any job offer to include at least the stuff Ilya defined, Otherwise, it's just useless
Читать полностью…
/report Isn't it time to ban all the abstract recruiters?
I suppose that project type, expected skills, position tasks, current hardware/software stack, current work climate, company place/work jurisdiction, salary fork are bare minimum to any vacancy not to be a complete scam.
Anyone completed EDB postgres certification? Where we can get vouchers for exam?
Читать полностью…
Hello and welcome to this chat. Here we discuss PostgreSQL and provide best-effort voluntary support on Postgresql issues.
If you have any question, try asking kindly, including log files, error descriptions and perhaps what you're trying to do.
- 🚫 photos and screenshots
- 🚫 spam and offtopic
- ✅ questions with log files and clear explanation of what's gone wrong
⬇️ Press the button down here ⬇️
Hey guys!!
I am having issue with PG AWS RDS I'm currently using free tier configured with 20GB storage only. My database is not that large when I checked it using /l+ found it is only 27MB large.
But the storage space in AWS console is 90% full i.e. around 19 gigs are being used.
Transaction Logs are 2.4 G and I have only one day backup retention, I don't understand where the rest of the storage is getting filled.
I tried all the AWS suggested docs for storage full issue and support too but no luck there.
Thanks in advance
The documentation is very good on installation for both Debian-flavor and Red Hat-flavor systems.
Читать полностью…
Can u please give proper query to execute at db level to check dependent objects for role
Читать полностью…
One thing you could try. Log all of the queries, and scan them for references to the main table (ID) column. It's brute force. Also, you can scan the application code for references to the main table you are speaking of... And checking how it is referenced.
You have to do this for all of the views as well (luckily those are all available to you).
As you do this, you learn (quickly) that the FK references are easier to define if they are consistently named (we use <PK_table>_id) and LONG ago we decided every table would simply have an ID column EVEN IF there were a natural key, because it avoids multi field keys, and the extra thought process when joining.
select conrelid::regclass,confrelid::regclass from pg_constraint where contype = 'f'; should be a good start, yes
Hi friends, can anyone advise which tool is helpful to migrate from SQL server to postgresql
Читать полностью…
No, as a Russian agent, I can say that our recruitment is closed
Читать полностью…
LOL. Are you suggesting when your new PostgreSQL position relocates you and provides a "Uniform". It *might* be time to ask a few more questions?
Читать полностью…
Let's say I agree partly. Posting the *complete* software stack would probably lead to multi-screen posts nowadays. And "current work climate" is obviously always "awesome" anyway 🥳
However, the rest of the requirements sound reasonable, so let's make it
* project type
* expected skills
* position tasks
* how is the job Postgres related
* company place/work jurisdiction & are applications from other places accepted?
* salary / hourly rate range
Hello
Anybody looking for job opportunity ?
Ping for
"Experience guys"
Hello
Anybody looking for job opportunity ?
Ping for
"Experience guys"
Hello and welcome to this chat. Here we discuss PostgreSQL and provide best-effort voluntary support on Postgresql issues.
If you have any question, try asking kindly, including log files, error descriptions and perhaps what you're trying to do.
- 🚫 photos and screenshots
- 🚫 spam and offtopic
- ✅ questions with log files and clear explanation of what's gone wrong
⬇️ Press the button down here ⬇️
Ah, I see what you mean. Thanks for the insight! If there is a foreign key constraint, should I be querying the PostgreSQL catalog schema to find all the references? Otherwise, I guess I'll have to check column names and dig into the application code. Appreciate the heads-up:)
Читать полностью…
I'm happy to know I'm not the only one having to look at that kind of databases 😄
Читать полностью…