Not the answer you need?
Register and ask your own question!
New here?
Check out the Percona Distribution for PostgreSQL!

Regarding for PostgreSQL Adminitration

aartiyadavaartiyadav Current User Role Contributor

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

Tagged:

Answers

  • daniil.bazhenovdaniil.bazhenov Percona Admin Role, API

    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/
  • vijaysinghvijaysingh Current User Role Beginner

    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.
  • NgansoNganso Current User Role Novice
    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
  • jobin.augustinejobin.augustine Percona Percona Staff Role

    Hi @Nganso ,

    Migration to a different host machine with an upgraded version is usually done in the following steps.

    1. 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

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.