PostgreSQL

11 May 2025 11:20

I have a folder full of sql scripts that upgrade the schema and the software checks the version on startup and does on the fly upgrade

PostgreSQL

11 May 2025 11:12

is it bad just to run from jenkins (groovy) the .sql files for the particular version?

PostgreSQL

11 May 2025 11:04

Flyway but if you want to save on downtime in schema migrations then pgroll

https://github.com/xataio/pgroll

PostgreSQL

11 May 2025 11:01

No - I mean when there's new feature to deploy that needs new table/column/alter...

PostgreSQL

11 May 2025 10:57

flyway/liqubase were too complex and we switched to "goose" for a while. But anyways, we decided to use SQL Server + SSDT (Sql Server Database Projects) which takes a declarative approach compared to imperative approach of migration tools and we are very happy with it.

PostgreSQL

11 May 2025 07:53

Hi folks, does anybody have postgresql dba course recorded sessions? Please let me know if anyone has

PostgreSQL

11 May 2025 06:59

Hi! when using a vps (ubuntu 24, 2gb), should i deploy it in docker way or not (postgres v17)? this is a test instance and will be transitioned into prod in future

PostgreSQL

10 May 2025 22:51

REVOKE ALL ON SCHEMA public FROM PUBLIC

PostgreSQL

10 May 2025 22:16

there is pg_read_all_data

PostgreSQL

10 May 2025 22:13

My question is , I want to grant select permission or readonly permission to a user at database level. but at per my knowledge it is only possible at the schemma level

PostgreSQL

10 May 2025 20:52

I am not an expert on psql, but I would also just create a read only user and grant it rights to only read on the specified database.

PostgreSQL

10 May 2025 20:42

should i first create a role then assign a user to it? so that in future it will help to assign new user the same role

PostgreSQL

09 May 2025 21:31

I have a talk streaming at POSETTE next month about UUIDs

PostgreSQL

09 May 2025 20:00

Just be aware that UUIDv4s have bad interactions with B-trees. If you can, use UUIDv7s or another implementation of UUIDs that have serial high-order bits.

PostgreSQL

09 May 2025 15:54

Although i would recommend working with random UUID’s for row identifiers

PostgreSQL

11 May 2025 11:20

It's good whatever fits your workflow

PostgreSQL

11 May 2025 11:04

Not this kind of migration.
When you need to make changes to your database structure when CI/CD

PostgreSQL

11 May 2025 11:02

pg_dumpall
reliable method, but a long downtime is possible

PostgreSQL

11 May 2025 11:00

Are we talking about migrating from another database management system?

PostgreSQL

11 May 2025 10:50

How your team deal with CI\CD and data migration for postgresql?
Using flyway / liquibase? or some other method?

PostgreSQL

11 May 2025 07:22

Make test as similar as prod 😉 it won't make much sense to have two different setups for debugging in case of problems.

PostgreSQL

10 May 2025 22:51

Then give the privilege as you need

PostgreSQL

10 May 2025 22:17

it works at cluster level

PostgreSQL

10 May 2025 22:15

because there are lots of schema in my database , I am searching something which can help to grant select permission at database level

PostgreSQL

10 May 2025 20:52

I think that's the best choice and also most common tbh

PostgreSQL

10 May 2025 20:42

or is there any better choice to create a read only user;

PostgreSQL

10 May 2025 20:41

how I can create a read only user in postgresql

PostgreSQL

09 May 2025 20:01

yeah the id should be sequential so it works well with B-trees. Another option is ULID

PostgreSQL

09 May 2025 15:55

You can use the built in ‘gen_random_uuid()’

PostgreSQL

09 May 2025 13:03

Most of the time the FKs reference to the primary keys of other tables