Re: [dspace-tech] Database space used
Hi Sarah If you also need the size of the assetstore directory, this should do it: du -sh /assetstore/ But check your dspace.cfg that that is the correct directory. Sean On Wed, 23 Mar 2022 at 13:55, Mark H. Wood wrote: > On Tue, Mar 22, 2022 at 08:05:13AM -0400, Sarah Butash wrote: > > I've been asked to report the amount of space used for our DSpace data. > I > > can report the size of the volume allocated for the database, but this > > doesn't give me the actual data used space. We are on DSpace 5.10 on a > > linux server. > > > https://makandracards.com/makandra/37935-postgresql-show-size-of-all-databases > > gives a query that will show you the sizes of *all* databases in the > cluster. It shouldn't be too hard to alter it to select just the > database you want, and to report in other units. > > -- > Mark H. Wood > Lead Technology Analyst > > University Library > Indiana University - Purdue University Indianapolis > 755 W. Michigan Street > Indianapolis, IN 46202 > 317-274-0749 > www.ulib.iupui.edu > > -- > All messages to this mailing list should adhere to the Code of Conduct: > https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx > --- > You received this message because you are subscribed to the Google Groups > "DSpace Technical Support" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to dspace-tech+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/dspace-tech/YjsKsHViqcr3VYaG%40IUPUI.Edu > . > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/CA%2BxAuhPHnkvV00H-29XZ8_HASWn29y2rWivLWN9pM%2BN5YOeSgQ%40mail.gmail.com.
Re: [dspace-tech] Database space used
On Tue, Mar 22, 2022 at 08:05:13AM -0400, Sarah Butash wrote: > I've been asked to report the amount of space used for our DSpace data. I > can report the size of the volume allocated for the database, but this > doesn't give me the actual data used space. We are on DSpace 5.10 on a > linux server. https://makandracards.com/makandra/37935-postgresql-show-size-of-all-databases gives a query that will show you the sizes of *all* databases in the cluster. It shouldn't be too hard to alter it to select just the database you want, and to report in other units. -- Mark H. Wood Lead Technology Analyst University Library Indiana University - Purdue University Indianapolis 755 W. Michigan Street Indianapolis, IN 46202 317-274-0749 www.ulib.iupui.edu -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/YjsKsHViqcr3VYaG%40IUPUI.Edu. signature.asc Description: PGP signature
Re: [dspace-tech] Database space used
Hi Sarah,
Am 22.03.22 um 13:05 schrieb Sarah Butash:
Hello DSpace Community,
I've been asked to report the amount of space used for our DSpace data.
I can report the size of the volume allocated for the database, but this
doesn't give me the actual data used space. We are on DSpace 5.10 on a
linux server.
If you have any helpful hints, it would be great if you could share.
log into the database via psql and do this query, assuming the name of
your database is 'dspace':
select pg_size_pretty(pg_database_size('dspace'));
Michael
--
All messages to this mailing list should adhere to the Code of Conduct:
https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/dspace-tech/9eb72c97-e186-6939-bed8-814b10765b06%40bibliothek.uni-kassel.de.
smime.p7s
Description: S/MIME Cryptographic Signature
[dspace-tech] Database space used
Hello DSpace Community, I've been asked to report the amount of space used for our DSpace data. I can report the size of the volume allocated for the database, but this doesn't give me the actual data used space. We are on DSpace 5.10 on a linux server. If you have any helpful hints, it would be great if you could share. Have a great day! Sarah -- Sarah Butash she / her Library Systems Analyst, OU Libraries Kresge Library, Room 227 100 Library Drive, Rochester, MI 48309-4479 Phone: 248-370-2368 -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/CAGdTMArMtDStwDiW7x7KyouDWkV6d71DKh7YWja7PrZnybU92A%40mail.gmail.com.
