Hello All, I want to learn PostgreSQL and looking for paid/free tutorial or suggest me any online book. Can anyone help me.
1 Like
aartiyadav said:Try reading this book "Postgres: The First Experience".Hello All, I want to learn PostgreSQL and looking for paid/free tutorial or suggest me any online book. Can anyone help me.
https://postgrespro.com/education/books/introbook
And of course, read the Percona blog about PostgreSQL. Even if it's not clear now, it may come in handy in the future.
https://www.percona.com/blog/category/postgresql/
daniil.bazhenov said:For books, I would propose the same book but for the course part, I would suggest you go through with these PostgreSQL tutorials.aartiyadav said:Try reading this book "Postgres: The First Experience".Hello All, I want to learn PostgreSQL and looking for paid/free tutorial or suggest me any online book. Can anyone help me.
https://postgrespro.com/education/books/introbook
And of course, read the Percona blog about PostgreSQL. Even if it's not clear now, it may come in handy in the future.
https://www.percona.com/blog/category/postgresql/
1 Like
Hello @ll,I have 2 differents servers A and B each of them has databses on postgres 9.6
I will like to migrate those databses from A and B to server C with postgres 12
1. I want to ask if pg_upgrade can be used to perform migration databses from Server A and B to Server C ?it not please propose me an option with average downtime.
Thank you very much for your answers
Nganso
1 Like
Hi @Nganso
- ,
Migration to a different host machine with an upgraded version is usually done in the following steps.
Install both old (PG 9.6) and new (PG 12) binaries on the new host machine.
- Setup new host as one of the standby server for existing database using PG 9.6 binary.
- Cut-over to new host machine. but still PG 9.6
- Do In-place upgrade from old version (PG 9.6) to new version (PG12) using pg_upgrade hard links.
Regards,
Jobin
1 Like