pgAdmin 4 1

• Jun 11, 2020

• #2

janni78

IS-IT--Management

Aug 25, 2005

5,125

SE

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

 

Upvote 0 Downvote

• Jun 22, 2020

• Thread starter
• #3

alan24

Programmer

Apr 28, 2004

312

GB

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.

 

Upvote 0 Downvote

• Jun 22, 2020

• #4

janni78

IS-IT--Management

Aug 25, 2005

5,125

SE

You can run VACUUM to reclaim unused storage space.

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

 

Upvote 0 Downvote

• Jun 22, 2020

• Thread starter
• #5

alan24

Programmer

Apr 28, 2004

312

GB

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

 

Upvote 0 Downvote

• Jun 22, 2020

1
• #6

janni78

IS-IT--Management

Aug 25, 2005

5,125

SE

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

 

Upvote 0 Downvote

• Jun 22, 2020

• Thread starter
• #7

alan24

Programmer

Apr 28, 2004

312

GB

Thanks again Janni

 

Upvote 0 Downvote