PostgreSQL

06 Jan 2025 11:31

Ah yes. I usually use rsync + manual backup for initial setup so i am not affected by these issues

PostgreSQL

06 Jan 2025 11:28

Couldn't you just do with a replication slot if you're really lucky, or am i missing something?

PostgreSQL

06 Jan 2025 11:15

Oh, where can I see the graph when version support ends?

PostgreSQL

05 Jan 2025 23:37

Thanks for your help 🙏🏼

PostgreSQL

05 Jan 2025 23:34

No. The default is to stream wal during the copy, using a second connection. I see you have nothing that overrides that setting so i have no idea what could be wrong

PostgreSQL

05 Jan 2025 23:22

Replace the integer of the column of the second table with the string of the first table that has a identical integer column of the second table with a second column with the string of the products. FIRST TABLE: (ID) 1 | (PRODUCT) iPhone | ---- second table | (ID) 1| ... to be replaced with iPhone.

PostgreSQL

05 Jan 2025 23:09

Do you need to edit the original table, or just get the data?

PostgreSQL

05 Jan 2025 23:08

Okay, i see i can't send images in this chat.

PostgreSQL

05 Jan 2025 23:06

Hello, after some internet search, as a beginner i can't figure out how to solve an easy excercise: i have to tables. I have to replace the id of the column of the second table (example: 1, 2 ...) with the corresponding product name (example: iphone 15 ...) that i should get from the first table (that has a identical column with an id). Any tips? Thank you - here are the tables:

PostgreSQL

05 Jan 2025 23:01

I have tried 4 times to get my slave ready.
Last time i saw the log :

requested WAL segment has already been removed

PostgreSQL

05 Jan 2025 22:56

BTW, you should have all the wal files already streamed by pg_basebackup

PostgreSQL

05 Jan 2025 22:51

You provided me with a great experience.

Do you have any links where I can learn about the parameters I need to calculate the value I’m looking for?

PostgreSQL

05 Jan 2025 22:48

It really depends on your amount of generated wals

PostgreSQL

05 Jan 2025 22:34

Not if archive_cleanup_command is set to call pg_archivecleanup

PostgreSQL

05 Jan 2025 22:29

(you should set it up anyway, along with streaming replication, for better reliability and recovery speed in case the secondary falls behind)

PostgreSQL

06 Jan 2025 11:29

Yes you could, but OP has just proven that that doesn't help with the initial setup. Also you don't get PITR...

PostgreSQL

06 Jan 2025 11:22

https://www.postgresql.org/support/versioning/
(you'll have to make a graph yourself, I'm afraid ;-)

PostgreSQL

06 Jan 2025 11:02

IMNSHO, a replication setup without a WAL archive is pretty much useless anyway. You should first set up a WAL archive, then your problem goes away real quick.
You should also combine that with a major upgrade real soon, 11 is EOL for > 1 year now!

PostgreSQL

05 Jan 2025 23:35

I don't know what happens when e.g. you reach the maximum amount of connections so that the second replication cannot be opened

PostgreSQL

05 Jan 2025 23:28

Do you have any other idea based on my command?

PostgreSQL

05 Jan 2025 23:13

Thank you. I just need to replace in the second table the number with the corresponding name of the product of the first table. FIRST TABLE: column ID=1 column PRODUCT=iPhone --- SECOND TABLE: column ID=1 --- I have to change the ID=1 of the second table with ID=iPhone. Is it clear? Thanks

PostgreSQL

05 Jan 2025 23:09

You need to use a join

PostgreSQL

05 Jan 2025 23:06

pg_basebackup -h masterhost -p masterport -D /data -U replicauser --checkpoint=fast -vP -R -W

PostgreSQL

05 Jan 2025 23:02

Send the full pg_basebackup command please

PostgreSQL

05 Jan 2025 22:57

Are you sure the standby is not ready and the error in the log is just the database looking for the newest file? (standby keeps trying to read current_wal+1 and obviously fails when it is up to date with the primary)

PostgreSQL

05 Jan 2025 22:53

Look at the folder and count the files generated in the past hour :)

PostgreSQL

05 Jan 2025 22:49

On my inactive server I get a new wal file every 30 minutes, on my busy one it goes anything from 3 minutes from 20 seconds

PostgreSQL

05 Jan 2025 22:47

It is a good idea and I will test your solution.

And what would you recommend if i want to set wal_keep_size , wal_keep_segment and wal_max_size?

to handle a lag of 3 hours

PostgreSQL

05 Jan 2025 22:32

Wouldn't it cause my master disk to become full?

PostgreSQL

05 Jan 2025 22:29

Setup archive_command to keep the wal files :)