PostgreSQL

10 Oct 2024 14:46

Hello, can anyone help? During initialization initdb at the moment selecting default "max_connections" ... initdb freeze

PostgreSQL

10 Oct 2024 13:53

It should appear to them like ****

PostgreSQL

10 Oct 2024 13:29

Hello all, if we want to create more users on the server, do we need to increase the pv storage to maintain the logs?

PostgreSQL

10 Oct 2024 08:55

Hello, can anyone help? During initialization initdb at the moment selecting default "max_connections" ... initdb freeze

PostgreSQL

09 Oct 2024 19:32

Looking for one document

PostgreSQL

09 Oct 2024 12:14

https://www.enterprisedb.com/docs/supported-open-source/patroni/rhel8_quick_start

PostgreSQL

09 Oct 2024 10:42

Oracle scm and hcm vedious available.....Anyone interested ping me. ...

PostgreSQL

09 Oct 2024 09:20

Someone in another group told me. That's no problem, in theory. Because ACID only guaranteed between begin...commit/abort. So as long as we abort the transaction finally, we can do anything during the transaction.

PostgreSQL

09 Oct 2024 08:49

Yes. Maybe I misread your question... 🤔

PostgreSQL

09 Oct 2024 08:41

If your session is in SERIALIZABLE, it does have a consistent view. It does not force all other sessions into that mode as well, so other sessions may see stuff you don't (and obviously you may see stuff other sessions don't see etc.).

PostgreSQL

09 Oct 2024 08:32

Assuming you mean User Defined Functions: check if the PL (Procedural Language) your functions are written in is provided by RDS in their offering, then you're probably good to go.

PostgreSQL

09 Oct 2024 03:47

And I'm afraid the sentence causes some misleading, in fact:
In practical, NO transaction isolation level can ensure we get a view that consists with any serial execution of other transactions. Since isolation levels other than SERIALIZABLE is permitted.(So the sentence is likely unused.)
If my understanding correctly.

PostgreSQL

08 Oct 2024 23:32

In our postgres database we are using UDF function now we are going to move to RDS.. How can i manage UDF functions in RDS?

PostgreSQL

07 Oct 2024 19:09

PostgreSQL Person of the Week interview with: Yurii Rashkovskii

https://postgresql.life/post/yurii_rashkovskii/

PostgreSQL

07 Oct 2024 17:22

I have 2 replication slots

PostgreSQL

10 Oct 2024 14:00

1. do not login with "postgres"
2. i have no idea what you are using, pgadmin will hide the password as well as psql, assuming you're using interactive mode for password input

PostgreSQL

10 Oct 2024 13:52

User name is postgres and password is 1234.

My question is when someone login with above credentials, can we hide the password from them?

PostgreSQL

10 Oct 2024 13:07

hello Im trying to move arcgis data from pg cluster to another, both pg versions 12 and 3.1.x postgis, but when I try to import csv getting this errror

ERROR: ESRI: error making spatial references [20809]:
CONTEXT: COPY gdb_items, line 7, column shape: "400000000500000008001000E6100000240000000110000496D19D928419B689A383BD19B3BFD78C670000A6B0E4EA20F3BF..."

PostgreSQL

09 Oct 2024 19:36

Azure documentation is pretty good

PostgreSQL

09 Oct 2024 19:31

Anyone has done migration from single sever to flexible server in azure using dms service in Postgres

PostgreSQL

09 Oct 2024 12:08

Can anyone share the high availability setup documents

PostgreSQL

09 Oct 2024 09:21

But I don't think the PostgreSQL should implement like that.

PostgreSQL

09 Oct 2024 08:55

Ok, found the sentence you're discussing and I'm also not sure what it describes. I'll have to dwell on that a little bit...

PostgreSQL

09 Oct 2024 08:43

But since there's no RU isolation level, every snapshot should contains and only contains the data was committed.

PostgreSQL

09 Oct 2024 08:37

Intelltech , please read this discussion and rephrase your offer

PostgreSQL

09 Oct 2024 05:38

Greetings, we do have a full time / permanent position available for a MSSQL developer (6+ yrs) which is based either in Chennai or Bangalore or Trichy. If anyone is interested to explore this further, please feel free to ping / DM me. I can help you with more details.

PostgreSQL

09 Oct 2024 03:33

How to understand the paragraph of the document?

The Repeatable Read mode provides a rigorous guarantee that each transaction sees a completely stable view of the database. However, this view will not necessarily always be consistent with some serial (one at a time) execution of concurrent transactions of the same level. For example, even a read-only transaction at this level may see a control record updated to show that a batch has been completed but not see one of the detail records which is logically part of the batch because it read an earlier revision of the control record. Attempts to enforce business rules by transactions running at this isolation level are not likely to work correctly without careful use of explicit locks to block conflicting transactions.

PostgreSQL

08 Oct 2024 22:40

Any one providing online classes for postgresql

PostgreSQL

07 Oct 2024 18:47

hi guys.
im running postgresql on docker

  psql:
    image: postgres:16.3
    restart: always
    environment:
      TZ: Asia/Tehran
      POSTGRES_DB: CometDb
      POSTGRES_USER: comet
      POSTGRES_PASSWORD: 1381hadi
      PGDATA: /var/lib/postgresql/data/pgdata

    volumes:
      - ./assets/database/postgres:/var/lib/postgresql/data
      - ./assets/tables.sql:/docker-entrypoint-initdb.d/init.sql

    volumes:
      - ./assets/database/postgres:/var/lib/postgresql/data

PostgreSQL

07 Oct 2024 17:21

Checking between the old and new data folders, most files which shrunk were TOAST tables