PostgreSQL

05 September 2024 19:01

Mostly are the same functionality

PostgreSQL

05 September 2024 12:16

I want to learn English with Russian buddies.

PostgreSQL

04 September 2024 14:35

Do you really need replication? Are you sure you cannot do with a mongodb fdw to query data?

https://github.com/EnterpriseDB/mongo_fdw

PostgreSQL

04 September 2024 10:14

You will need to use -f probably, and the recovered database must be treated with even more suspicion than usual: an immediate dump and restore is imperative

PostgreSQL

04 September 2024 10:14

Okay let me apply your solution

PostgreSQL

04 September 2024 10:02

Is that an answer or a question?

PostgreSQL

04 September 2024 09:45

https://www.postgresql.org/docs/current/app-pgresetwal.html

PostgreSQL

04 September 2024 09:44

You could try with pg_resetwal

PostgreSQL

04 September 2024 09:31

is OOMScoreAdjust specified by default in postgres service file?

PostgreSQL

04 September 2024 08:58

Folks!
Please join the annual "State of PostgreSQL" survey and spread the word too!
https://www.timescale.com/blog/the-2024-state-of-postgresql-survey-is-now-open/amp/
It is very valuable and gets better with each and every participant.

PostgreSQL

04 September 2024 08:48

Hi, Is there any document that proves that Postgresql is faster than Mongodb. Plz share.

PostgreSQL

03 September 2024 18:18

Does any running patroni as a HA between database nodes in postgreSQL? Pls DM me as I need assist in a little configuration related to it. Thanks.

PostgreSQL

03 September 2024 17:35

Hi team we are getting error while restoration of database table is already exist, trigger and constraints and index related error also getting

PostgreSQL

03 September 2024 17:16

Hi Bro
while connecting to PDB getting below error,

[postgres@lsp-saltl01 config]$ ora2pg -t SHOW_VERSION -c ora2pg.conf
FATAL: 12505 ... ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
Aborting export...

# Set Oracle database connection (datasource, user, password)
ORACLE_DSN dbi:Oracle:host=lsp-saltl01;sid=PDB1;port=1521
ORACLE_USER system
ORACLE_PWD system123

if I change configuration to CDB its working ,

# Set Oracle database connection (datasource, user, password)
ORACLE_DSN dbi:Oracle:host=lsp-saltl01;sid=cdb;port=1521
ORACLE_USER system
ORACLE_PWD system123

[postgres@lsp-saltl01 config]$ vi ora2pg.conf
[postgres@lsp-saltl01 config]$ ora2pg -t SHOW_VERSION -c ora2pg.conf
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
[postgres@lsp-saltl01 config]$

Please let me know how to connect PDB in 19c database,

PostgreSQL

03 September 2024 09:50

You may give several -c options in one psql call though.

PostgreSQL

05 September 2024 18:50

Hello guys,

I just want to understand the main difference between Replication slot and wal keep segment? Are they doing the same thing, or they differ in a specific functionality?

PostgreSQL

05 September 2024 12:15

Is there anyone from Russia?

PostgreSQL

04 September 2024 12:03

Hi,has anyone ever used bucardo to replicate from Postgres to mongo. I have an issue with updates. When an update takes place in Postgres,it can’t be replicated to mongo. My primary research has made me know that bucardo does not support the mongo upsert. Now I am required to write a customcode to perform the upsert operation when conflict occurs during the replication. I need guidance from anyone who has knowledge in this. I will appreciate.

PostgreSQL

04 September 2024 10:14

If the database was stopped or mostly idle, then probably transactions would be already applied and everything good, but if it was a busy database and you experienced corruption due to drive defects or similar then you should be cautious because if a wal file is corrupted and was not applied it will get skipped

PostgreSQL

04 September 2024 10:13

But it depends how you ended up with corruption of pg_control

PostgreSQL

04 September 2024 10:01

If we use pg_resetwal then loose some current committed transaction

PostgreSQL

04 September 2024 09:44

But backup the database and be very careful

PostgreSQL

04 September 2024 09:43

Hi everyone, is there a way to recover the database if there is no pg_control file?

PostgreSQL

04 September 2024 09:17

Faster in query write and read

PostgreSQL

04 September 2024 08:57

... faster in what?
Test with your own data! 🤷

PostgreSQL

03 September 2024 20:46

Well, pg_dump has an option that adds corresponding DROP ... commands. pg_restore as well, in case you used directory or custom format for your dump.
Otherwise, just drop or rename your DB :)

PostgreSQL

03 September 2024 17:39

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

03 September 2024 17:17

If it's non container it's working, but want to know how to connect pluggable database

PostgreSQL

03 September 2024 12:19

Hi All,
Can someone suggest can we migrate orcle pdb to postgreSQL??

PostgreSQL

03 September 2024 09:49

The man page says:

Each SQL command string passed to -c is sent to the server as a single request. Because of this, the server executes it as a single
           transaction even if the string contains multiple SQL commands, unless there are explicit BEGIN/COMMIT commands included in the string
           to divide it into multiple transactions. (See Section 55.2.2.1 for more details about how the server handles multi-query strings.)