I have a Server Registration in pgAdmin3 where I would like to change the username/pwd. As this is not editabel in pgAdmin3 (Version 1.10.5), I created another Server Registration with the correct username/pwd.
Can I now savely Delete/Drop the “old” Server Registration without harm to the database (PostgreSQL V8.4.1)?
Thanks, I was looking for just that - and yes, somewhat obvious to disconnect the server registration first
In the mean time I have created another server registration (with the desired username/pwd). Can I savely delete the former server registration? I assume so, as each server registration just points to the server data. So in practice I can create and delete server registrations as I like to (not that it makes normally a lot of sense tough, just for my understanding).
jberkus:
That is incorrect. You can change any of the properties of the server registration you want.
Disconnect from that server.
Right-click (alternate-click) on the server icon in question.
One option is “Edit”
Change username/password.
Right-clicking is also the way to drop a server registration.
I’m sorry, but where is the “Edit” option?? I cannot find that option in the context by a right-click on a server in pgAdmin! Please have a look at the attached screenshot.
Interesting, I see that too.
Not that I change my password all the time but I thought this was possible in older versions, perhaps I am mistaken.
Anyway, it seems you have to remove the connection and create a new one if you want to change the password.