Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

pgAdmin 4 1

Status
Not open for further replies.
alan24

alan24

Programmer
Apr 28, 2004
312
GB
Anybody use this for backups and would you recommend it?
 
Sort by date Sort by votes
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
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
You can run VACUUM to reclaim unused storage space.

"Trying is the first step to failure..." - Homer
 
Upvote 0 Downvote
Can it be done during working hours and is it as simple as right click, maintenance, vacuum, full?
 
Upvote 0 Downvote
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
Status
Not open for further replies.

Similar threads

EmersonLRibeiro
  • Locked
  • Question
pgAdmin 4 with pgAgent
Replies
0
Views
46
EmersonLRibeiro
EmersonLRibeiro
MrAnderson1960
  • Locked
  • Question
PgAdmin III
Replies
13
Views
123
Alfalis
Alfalis
IPOCraft
  • Locked
  • Question
IPOCC Dialer 488 Not Acceptable Here
Replies
1
Views
162
Alfalis
Alfalis
makemetrend
  • Locked
  • Question
HTTP Status 404 - /webUI
Replies
8
Views
111
makemetrend
makemetrend

Part and Inventory Search

Sponsor

Back
Top