Regarding for PostgreSQL Adminitration

Hello All, I want to learn PostgreSQL and looking for paid/free tutorial or suggest me any online book. Can anyone help me.

aartiyadav said:

Hello All, I want to learn PostgreSQL and looking for paid/free tutorial or suggest me any online book. Can anyone help me.

Try reading this book "Postgres: The First Experience". 
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:
aartiyadav said:

Hello All, I want to learn PostgreSQL and looking for paid/free tutorial or suggest me any online book. Can anyone help me.

Try reading this book "Postgres: The First Experience". 
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/
For books, I would propose the same book but for the course part, I would suggest you go through with these PostgreSQL tutorials.

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

Hi @Nganso

  1. ,

    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.

  2. Setup new host as one of the standby server for existing database using PG 9.6 binary.
  3. Cut-over to new host machine. but still PG 9.6
  4. Do In-place upgrade from old version (PG 9.6) to new version (PG12) using pg_upgrade hard links.

Regards,

Jobin