No, they are not symbolic links. I have thought about moving the main_old directory somewhere else and it doesn't change anything because the cluster main_old is linked to the main data directory. In fact, neither the log nor any main_old data file changes, they are all from 2020. It's a strange case
El jue., 30 nov. 2023 16:23, Adrian Klaver <adrian.kla...@aklaver.com> escribió: > 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.kla...@aklaver.com > >
