PostgreSQL

30 Sep 2024 16:28

No, as a Russian agent, I can say that our recruitment is closed

PostgreSQL

30 Sep 2024 14:39

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?

PostgreSQL

30 Sep 2024 14:15

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

PostgreSQL

30 Sep 2024 12:28

Reported to admins.​​​

PostgreSQL

30 Sep 2024 10:33

Reported S H [7505889847] to admins.​​​

PostgreSQL

30 Sep 2024 07:38

Hello

Anybody looking for job opportunity ?
Ping for

"Experience guys"

PostgreSQL

29 Sep 2024 17:07

Hello

Anybody looking for job opportunity ?
Ping for

"Experience guys"

PostgreSQL

29 Sep 2024 12:48

Please let us know Postgres RDS activity

PostgreSQL

28 Sep 2024 18:43

https://pgbackrest.org/user-guide-index.html

PostgreSQL

28 Sep 2024 17:56

Any install guide for pgbackrest

PostgreSQL

27 Sep 2024 16:21

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 ⬇️

PostgreSQL

27 Sep 2024 13:57

Ask a sysadmin to fix it.

PostgreSQL

27 Sep 2024 11:29

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:)

PostgreSQL

27 Sep 2024 11:26

I'm happy to know I'm not the only one having to look at that kind of databases 😄

PostgreSQL

27 Sep 2024 11:19

Got it, thanks for the clarification! What I meant was, if a table has a primary key like id and that ID is used in other tables (either as a foreign key or in some other way), is there a way to find all the places where that specific ID is being referenced across different tables?

PostgreSQL

30 Sep 2024 14:40

That'd be a little bit too obvious. eh?

PostgreSQL

30 Sep 2024 14:17

This might just as well being Russia looking for new throwaway agents 🤔

PostgreSQL

30 Sep 2024 14:09

@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

PostgreSQL

30 Sep 2024 10:50

Yeah that would be a good idea

PostgreSQL

30 Sep 2024 10:33

/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.

PostgreSQL

30 Sep 2024 06:58

Anyone completed EDB postgres certification? Where we can get vouchers for exam?

PostgreSQL

29 Sep 2024 15:48

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 ⬇️

PostgreSQL

29 Sep 2024 12:39

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

PostgreSQL

28 Sep 2024 18:06

The documentation is very good on installation for both Debian-flavor and Red Hat-flavor systems.

PostgreSQL

27 Sep 2024 22:45

Can u please give proper query to execute at db level to check dependent objects for role

PostgreSQL

27 Sep 2024 14:09

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.

PostgreSQL

27 Sep 2024 11:39

select conrelid::regclass,confrelid::regclass from pg_constraint where contype = 'f'; should be a good start, yes

PostgreSQL

27 Sep 2024 11:27

Scm modules and hcm vedious available. .....

PostgreSQL

27 Sep 2024 11:22

If you didn't define FK constraints, looking and guessing is the way forward... good luck, I once had a client who asked me to do that, in a schema with > 1.000 tables. Luckily, the column names were usually a good hint, but that's not necessarily the case. Then the application code is probably the best place to look.

PostgreSQL

27 Sep 2024 11:17

The pgadmin 4 server could not be contacted


How can i fix this error
Can anyone help?