PostgreSQL

01 Nov 2024 16:51

Hi everyone,

I am looking for PostgreSQL DBA for a fully remote position. It is full time and needs to be worked on a b2b contract.

Salary is up to €120k + bonus + 30 days paid leave.

Support for Short-Medium Term Future Plans:

• Migration of PostgreSQL version 14 to version 16.
• Migration of on-premise PostgreSQL to AWS.
• Partitioning, purging, and/or migration of large historical tables (billions of rows)

I apologise if this is against channel rules.

@garyos96 for more details

PostgreSQL

01 Nov 2024 14:49

hello, I get out of memory error when creating posgis extension, but there is plenty of memory I think, pg10 postgis 2.4.4, 8 gb total ram, 2 gb shared buffer, swappines 0 , overcommit ratio 75 and overcommit memory 2, what to look you advice?

PostgreSQL

01 Nov 2024 04:19

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

31 Oct 2024 17:50

hello guys,

pls I wanna know how to export my explain query to plain text or json format, because I wanna have those and import it in explain.dalibo query tool...

I use /O query then export it, but I am unable to use it to the dalibo as I won't be able to copy them or have only the whole plan without the additional information it shows

PostgreSQL

30 Oct 2024 20:12

Please any one with complete postgreSQL course

PostgreSQL

30 Oct 2024 13:46

If you're gonna tutor him into doing everything, please do not do it here

PostgreSQL

30 Oct 2024 13:45

you will access ubuntu system in another device using this command.

PostgreSQL

30 Oct 2024 13:36

Anyone help me how can we public a database in ubuntu and access it on other devices

PostgreSQL

30 Oct 2024 11:48

Hello guys,

we have set the necessary environment needed with EDB in postgreSQL.

Now, I want to have a consistent and best way solution to migrate my free postgreSQL database to the EDB environment. Does this require a specific plan and compatibility? Please I need the most efficient plan to do this migration from postgreSQL to edb postgreSQL environment. Thanks in advance

PostgreSQL

29 Oct 2024 12:18

I want to get the load pattern on the database for a particular time period like how many insert , update, select query has executed in the database on each table for a specific time period

PostgreSQL

29 Oct 2024 07:38

Yes I have created a table with columns like inserted updated deleted fetched. Then I created a script for inserting data in this table using pg_stat_user_tables, and set this script in the cronjob every hour.
Then I executed the query to calculate the difference in 1 hour. It gives me the desired results but it is a very lengthy process as I have to set this for each table individually.

PostgreSQL

29 Oct 2024 04:54

Hi all, is there any provision in Postgresql to know the number of transactions in all tables in a database for a particular time. Means can we check how many insert/update/delete/select queries executed in each table in a database for a specific time period?

PostgreSQL

28 Oct 2024 19:33

Yes 6 months ago, I passed associated and professional for epas and postgres.

PostgreSQL

28 Oct 2024 17:55

You're talking about EDB's certification, aren't you?

PostgreSQL

28 Oct 2024 17:05

Can anyone confirm if someone has recently completed the PostgreSQL Associate Certification?

PostgreSQL

01 Nov 2024 16:40

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

01 Nov 2024 07:59

Evarikaina postgreSQL dba vds kavalantey Naku msg cheyandi

PostgreSQL

31 Oct 2024 18:43

Please read https://explain.dalibo.com/ at the end

PostgreSQL

31 Oct 2024 07:43

Definitive complete course:
https://www.postgresql.org/files/documentation/pdf/17/postgresql-17-A4.pdf

PostgreSQL

30 Oct 2024 13:46

I suggest @Death_X_02 you read some manual about basic system administration

PostgreSQL

30 Oct 2024 13:46

Actually I have rdp in which the database is stored locally and I want to access it via my windows

PostgreSQL

30 Oct 2024 13:45

do you have ubuntu system username and host and password?

PostgreSQL

30 Oct 2024 13:28

I reckon there's a bunch of documents, webinars etc. to be found at EDB for *that* path 😏

PostgreSQL

29 Oct 2024 12:57

better use pg-badger

PostgreSQL

29 Oct 2024 09:08

Why do you want this? What are you trying to achieve?

PostgreSQL

29 Oct 2024 07:09

You could store & reset the table statistics on a regular basis.
Or use pgBadger with full statement logging.
Or write a patch 😏

PostgreSQL

28 Oct 2024 21:02

Anyone here open to host the next #pgsqlphriday blogging event?
Details: https://www.pgsqlphriday.com/
Or do you have topic ideas?

PostgreSQL

28 Oct 2024 19:03

https://stackoverflow.com/questions/46099743/why-writes-in-a-table-prevent-vacuums-in-another

Is this true?

PostgreSQL

28 Oct 2024 17:54

If 4 months is recently, then me

PostgreSQL

28 Oct 2024 15:44

I will try with ora2pg