Changing Port Number of New Cluster

METHOD - 1 :
Stop the default running server and then start the new server 
  -bash-4.2$ /usr/pgsql-13/bin/pg_ctl -D /var/lib/pgsql/13/data stop
  waiting for server to shut down....... done
  server stopped
  -bash-4.2$ ./pg_ctl  -D /var/lib/pgsql/tesdb restart
  pg_ctl: PID file "/var/lib/pgsql/tesdb/postmaster.pid" does not exist
  Is server running?
  trying to start server anyway
  waiting for server to start....2023-11-23 12:33:20.576 IST [15321] LOG:  redirecting log output to logging collector process
  2023-11-23 12:33:20.576 IST [15321] HINT:  Future log output will appear in directory "log".
  done
  server started
  -bash-4.2$ psql 
  psql (13.13)
  Type "help" for help.

  postgres=# show port;
  port 
  ------
  5432
  (1 row)

  postgres=#
METHOD 2 :
Changing Port Number Of New Server

Step 7 : port number is to be changed in the postgresql.conf file

Step 8 : cd /var/lib/pgsql/tesdb

Step 9 : vi postgresql.conf and change the port number to 5433 
  #------------------------------------------------------------------------------
  # CONNECTIONS AND AUTHENTICATION
  #------------------------------------------------------------------------------

  # - Connection Settings -

  listen_addresses = '*'          # what IP address(es) to listen on;
                                          # comma-separated list of addresses;
                                          # defaults to 'localhost'; use '*' for all
                                          # (change requires restart)
  port = 5433                             # (change requires restart)


  Now start the new cluster , it starts without an issue .

  Connect to DB once the server is up

  -bash-4.2$ cd /usr/pgsql-13/bin
  -bash-4.2$ ./pg_ctl  -D /var/lib/pgsql/tesdb start
  waiting for server to start....2023-11-23 12:28:26.846 IST [14951] LOG:  redirecting log output to 
                                                                      logging collector process
  2023-11-23 12:28:26.846 IST [14951] HINT:  Future log output will appear in directory "log".
  done
  server started

  -bash-4.2$ psql -p 5433
  psql (13.13)
  Type "help" for help.
  postgres=# show port;
  port 
  ------
  5433
  (1 row)


(SQL - Constraints)