PostgreSQL

10 October 2024 22:56

ur initialization by postgres user?

PostgreSQL

10 October 2024 19:36

Tried to strace the process?

PostgreSQL

10 October 2024 19:30

Nothing else happens. I waited 40 minutes.

PostgreSQL

10 October 2024 19:27

Doing nothing at all. I'll send it now.

PostgreSQL

10 October 2024 15:28

"Freeze" like in "doing nothing at all"? Is the process in state "D" maybe?

PostgreSQL

10 October 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 October 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 October 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 October 2024 19:36

Azure documentation is pretty good

PostgreSQL

09 October 2024 19:31

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

PostgreSQL

09 October 2024 12:08

Can anyone share the high availability setup documents

PostgreSQL

09 October 2024 09:21

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

PostgreSQL

09 October 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 October 2024 08:43

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

PostgreSQL

09 October 2024 08:37

Intelltech , please read this discussion and rephrase your offer

PostgreSQL

10 October 2024 19:45

strace: Unexpected wait status 0x1f

...

PostgreSQL

10 October 2024 19:34

At the same time, there are no errors. This makes the solution of the problem even more difficult

PostgreSQL

10 October 2024 19:29

The files belonging to this database system will be owned by user "u0_a428".
This user must also own the server process.

The database cluster will be initialized with locale "C.UTF-8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... mmap
selecting default "max_connections"

PostgreSQL

10 October 2024 19:11

Is there anyone working on cassandra ? need to understand backups a little bit since i cant find anything in documentation

PostgreSQL

10 October 2024 14:46

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

PostgreSQL

10 October 2024 13:53

It should appear to them like ****

PostgreSQL

10 October 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 October 2024 08:55

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

PostgreSQL

09 October 2024 19:32

Looking for one document

PostgreSQL

09 October 2024 12:14

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

PostgreSQL

09 October 2024 10:42

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

PostgreSQL

09 October 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 October 2024 08:49

Yes. Maybe I misread your question... 🤔

PostgreSQL

09 October 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 October 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.