Page 1 of 1

Delete database

PostPosted: Thu Aug 04, 2016 11:55 am
by jdbruijn
On the database settings page there is a 'delete database' button.
But this button is not enabled for me? What must I do to enable this button?
The only way I can now remove a database is by shutting down the server, edit the properties file and then restart the server.

Servoy 7.4.7 with PostgreSQL database

Re: Delete database

PostPosted: Thu Aug 04, 2016 1:12 pm
by Peter de Groot
Hi,

Did you uncheck the "Enabled" checkbox,
delete_database.png
delete_database.png (27.37 KiB) Viewed 6649 times


Regards,

Peter

Re: Delete database

PostPosted: Thu Aug 04, 2016 1:32 pm
by jdbruijn
Yes I did uncheck that.
And I also changed the max connections to 0 and removed the clone setting.
Capture.JPG
Capture.JPG (43.84 KiB) Viewed 6645 times

But my database stays online and it does not show as not enabled as in your screenshot.

Re: Delete database

PostPosted: Fri Aug 05, 2016 5:30 am
by ROCLASI
Did you reboot Servoy server after you made those changes ?

Re: Delete database

PostPosted: Fri Aug 05, 2016 8:53 am
by jdbruijn
ROCLASI wrote:Did you reboot Servoy server after you made those changes ?

I was hoping I could do it without rebooting the server.
If a reboot is required then I could just edit the properties file to remove the old databases, so why include a delete button on the admin page??

Re: Delete database

PostPosted: Sat Aug 06, 2016 4:59 pm
by ROCLASI
Either case requires a reboot anyway. You can't add/remove connections without a reboot.
I suggest you file a feature request if you want it to behave differently.

Re: Delete database

PostPosted: Sun Aug 07, 2016 5:05 pm
by Bernd.N
The button <Delete Server> sounds also a bit scary.
In case you file a feature request, maybe you could also ask for renaming that button, like <Unlink Database Server> - at least that is how I currently understand that function :wink:

Re: Delete database

PostPosted: Thu Jun 01, 2017 3:23 pm
by Ruben79
I'd like to kick this topic since I'm seeing some strange behaviour in 7.4.8 regarding this. The goal is to remove/unlink a db server from servoy-admin.
The db servers get POSTed as part of an automated script, but at some point we'd like to disable and eventually remove them from the server.
Steps:
  1. Delete server button is greyed out. Set the db server to disabled.
  2. After restart, server is disabled. Delete server button is enabled, hit the button. Server is gone from db server list.
  3. After another restart, db server is back again, in disabled state.

How is it possible to delete a db server without having to shutdown the server and edit the db connections in servoy.properties and starting the server again?