Search Postgresql Archives

Re: Two started cluster on the same data directory and port

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 11/30/23 05:37, Loles wrote:
Hi!

I have this situation on a server that is giving me problems.

postgres@hostname:~$ pg_lsclusters
Ver Cluster  Port Status Owner    Data directory              Log file
14  main     5432 online postgres /var/lib/postgresql/14/main /var/log/postgresql/postgresql-14-main.log 14  main_old 5432 online postgres /var/lib/postgresql/14/main /var/log/postgresql/postgresql-14-main_old.log

How can I stop, even delete, the main_old cluster?

Assuming you are on  Debian/Ubuntu.

1) sudo pg_ctlcluster stop 14 main_old

    This will stop the server for this session

2) sudo vi  /etc/postgresql/14/main_old/start.conf

    Change auto to manual.
    This will keep the server from restarting on reboot.
    You can still start it using
	 sudo pg_ctlcluster start 14 main_old    	
    Though if you want to do that then:
        vi /etc/postgresql/14/main_old/postgresql.conf
     and change port to something other then 5432.

3) If you have determined you really don't need that server and have all the data safely backed up or moved to the other server, then(THIS IS NOT REVERSIBLE):

    sudo pg_dropcluster 14 main_old


Thanks!


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux