pgAdmin 4 1

[alan24]

Anybody use this for backups and would you recommend it?

 

[janni78]

I used it when for other DBs in PostgreSQL, it calls the same commands as the IPOCC backup would.

"Trying is the first step to failure..." - Homer

 

[alan24]

Thanks for getting back to me Janni.
Changing direction slightly, are there any commands or tools pgAdmin that cleans or shrinks a database?
I particular the c3k database, it is currently 100GB.
I have used Email Configuration, Documents tab to delete 1000's of emails, but the database doesn't seem to get smaller.

 

[janni78]

You can run VACUUM to reclaim unused storage space.

"Trying is the first step to failure..." - Homer

 

[alan24]

Can it be done during working hours and is it as simple as right click, maintenance, vacuum, full?

 

[janni78]

Yeah, you can run it during work hours, depends on how much resources you have on the server as it will probably take a while if the database is 100GB.

"Trying is the first step to failure..." - Homer

 

[alan24]

Thanks again Janni