I have a question. I have the default cluster(which comes during initial installtion) running on 5432. Later I created one more cluster using the same port and it got created. I even tried shutting down and starting up. They are not complaining anything about conflicting port. Please see below. C:\Program Files\PostgreSQL\11\bin>pg_ctl -D "D:\Postgres\cluster1" start waiting for server to start....2019-05-12 19:36:54.112 IST [38620] LOG: listening on IPv6 address "::1", port 5432 2019-05-12 19:36:54.112 IST [38620] LOG: listening on IPv4 address "127.0.0.1", port 5432 2019-05-12 19:36:54.166 IST [10636] LOG: database system was shut down at 2019-05-12 19:36:38 IST 2019-05-12 19:36:54.226 IST [38620] LOG: database system is ready to accept connections done server started C:\Program Files\PostgreSQL\11\bin>pg_ctl -D "C:\Program Files\PostgreSQL\11\data" start waiting for server to start....2019-05-12 19:37:51.056 IST [39584] LOG: listening on IPv6 address "::", port 5432 2019-05-12 19:37:51.057 IST [39584] LOG: listening on IPv4 address "0.0.0.0", port 5432 2019-05-12 19:37:51.100 IST [39584] LOG: redirecting log output to logging collector process 2019-05-12 19:37:51.100 IST [39584] HINT: Future log output will appear in directory "log". done server started
A rare technically video with so much clarity , truly world class presentation.
I also would like to see videos on PostGress high availability
I have a question.
I have the default cluster(which comes during initial installtion) running on 5432.
Later I created one more cluster using the same port and it got created. I even tried shutting down and starting up. They are not complaining anything about conflicting port. Please see below.
C:\Program Files\PostgreSQL\11\bin>pg_ctl -D "D:\Postgres\cluster1" start
waiting for server to start....2019-05-12 19:36:54.112 IST [38620] LOG: listening on IPv6 address "::1", port 5432
2019-05-12 19:36:54.112 IST [38620] LOG: listening on IPv4 address "127.0.0.1", port 5432
2019-05-12 19:36:54.166 IST [10636] LOG: database system was shut down at 2019-05-12 19:36:38 IST
2019-05-12 19:36:54.226 IST [38620] LOG: database system is ready to accept connections
done
server started
C:\Program Files\PostgreSQL\11\bin>pg_ctl -D "C:\Program Files\PostgreSQL\11\data" start
waiting for server to start....2019-05-12 19:37:51.056 IST [39584] LOG: listening on IPv6 address "::", port 5432
2019-05-12 19:37:51.057 IST [39584] LOG: listening on IPv4 address "0.0.0.0", port 5432
2019-05-12 19:37:51.100 IST [39584] LOG: redirecting log output to logging collector process
2019-05-12 19:37:51.100 IST [39584] HINT: Future log output will appear in directory "log".
done
server started
ip address is different for both clusters. hence not getting the conflict error.
sir while starting you gave d:\clu..is it where binaries kept?
Hi anna plz give me your ph no . i learn postgressql. i want postgresql material anna. and full videos anna