The Database Galaxy

Hello Guys, In this post we are going see a utility provided by PostgreSQL to find information about database cluster.  If we want know information about PostgreSQL cluster like database block size, catalog information,  checkpoint information, WAL segment size, etc. we will use pg_controdata utility. the location of pg_controldata utility will be same as your postgresql installation then bin directory. to execute this utility we have to provide data directory location as parameter. The sample output is attached here. #############################!!! Happy Learning !!!################################

Hello Guys... In this post we are going to see PostgreSQL database major upgrade. The earlier version of PostgreSQL is 9.6.5 and we are going to upgrade it to 10.1 Prerequisite: A server with any flavour of UNIX having PostgreSQL 9.6.5 installed. Binaries of PostgreSQL 10.1 Access to special OS user using database is installed. Here we are using postgres user as special OS user. postgres used for below execution. Configuration Details: Old data directory:  /pg_data/pg_data_9.6.5/ New data directory:  /pg_data/pg_data_10.1/ Old installation directory:  /pghome/postgres_9.6.5/ New Installation directory:  /pghome/postgres_10.1/ Upgrade Procedure: backup database cluster. shutdown database cluster. Rename installation directory. It is good practise to rename installation directory instead of delete, if we have any trouble we can revert the changes. Install PostgreSQL 10.1 using source code. I am going to write post for Standard PostgreSQL Database Installation.