PostgreSQL

11 Jul 2025 11:24

Having seen my fair share of T-SQL, I'd really recommend to approach this as follows:
1) check if the SPROC you're looking at is just doing something you already have in Postgres (as a function, an aggregate, ...)
2) check if you can implement the SPROC functionality in proper, modern SQL
3) only if 1) and 2) don't apply: rewrite the SPROC in plpgsql (or another PL)

PostgreSQL

11 Jul 2025 03:53

Sorry it was an accidental

PostgreSQL

10 Jul 2025 19:17

One option is cloning the instance, if you want the exact same data and config.

PostgreSQL

10 Jul 2025 19:13

We need to copy dbs in seperate instance, if we create separate aurora postgresql cluster do we need to restore all dbs manually in the new cluster from the existing aurora postgresql instance ?

PostgreSQL

10 Jul 2025 10:54

is anyone familiar with pii tool for databases?

PostgreSQL

09 Jul 2025 19:18

I am a new bee in IT industry. Can some one help me any tutorials on postgreSql ?

PostgreSQL

09 Jul 2025 15:50

thankyou, increase --archive-get-queue-max would help I think

PostgreSQL

09 Jul 2025 15:21

hello all, db generate 15 wal in 30 sec but pgbackrest get 5 wals in 30 sec, hence stanby replica stays in archive recovery mode, where shuld I look in backrest conf

PostgreSQL

08 Jul 2025 01:49

Dbeaver already has this functionality:

Roll out your database, then Schemas, SchemaName, Views.
Then click by mouse right button on the your view -> select Generate Script and choose DDL.

PostgreSQL

07 Jul 2025 19:46

https://www.postgresql.org/docs/17/backup.html

PostgreSQL

07 Jul 2025 17:56

PostgreSQL Person of the Week interview with: Josef Machytka

https://postgresql.life/post/josef_machytka/

PostgreSQL

07 Jul 2025 09:44

i am on macbook and I dont have ssms 🥲

PostgreSQL

07 Jul 2025 09:25

Hi, is there any tool that can be used to migrate views from sqlserver to postgersql?

PostgreSQL

05 Jul 2025 14:22

Hello! I will now help you to drop your database in an effective way!

1. Take the server running the postgresql cluster (if it has handles, use them or you can ask the help of a friend if it's too heavy)
2. Make sure the server is powered on and running, if possible initiate activity on database and disable fsync
3. Drop your database from a height that's high enough to make the heads crash, but not enough so that the fall sensor of the drive is triggered
4. Turn the server back on and repeat the process until all the sectors of your database are unable to be read

PostgreSQL

05 Jul 2025 12:12

How to drop database in postgres

PostgreSQL

11 Jul 2025 11:16

Hi All, how to convert sql server stored procedure to Postgres? TIA

PostgreSQL

10 Jul 2025 19:26

This might help, pls check limitations & how it works before proceeding -
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Clone.html

PostgreSQL

10 Jul 2025 19:15

Or just add new node

PostgreSQL

10 Jul 2025 13:30

Is anyone interested sql, mongodb, Aws,Azure,CCNA, CCNP, ITIL, REDHAT, GMAT, Certifications in first attempt with 100% passing guarantee
Pay after exam. Ping me personally

PostgreSQL

10 Jul 2025 02:55

You're welcome.
You can start your flight from the beginning
Also on this web site you can find some tutorials

PostgreSQL

09 Jul 2025 16:30

Ah, ok, you're _fetching_ too slow. My bad.
Be aware that the replay is single threaded, your server may be unable to keep up with the x CPUs that do the writing...

PostgreSQL

09 Jul 2025 15:32

https://pgbackrest.org/configuration.html#section-archive/option-archive-async

PostgreSQL

08 Jul 2025 02:13

Also it works on the whole schema

PostgreSQL

08 Jul 2025 01:42

For the dumb way you can use your macbook as virtual host by installing some virtual machine software, like Oracle Virtual box for example. Then install windows and ssms inside. )

PostgreSQL

07 Jul 2025 18:50

How to backup in postgres

PostgreSQL

07 Jul 2025 09:44

i use dbeaver client currently. (just if it helps i use aws rds)

PostgreSQL

07 Jul 2025 09:42

Generate script in SSMS

PostgreSQL

07 Jul 2025 07:45

Hi i am Giving postgresql Dba offline interview suport in Hyderabad, call:8309555894

PostgreSQL

05 Jul 2025 12:13

DROP DATABASE database_name;

PostgreSQL

04 Jul 2025 23:52

You probably want to look at Savepoints: https://www.postgresql.org/docs/current/sql-savepoint.html