{"id":69245,"date":"2021-08-15T04:10:06","date_gmt":"2021-08-15T08:10:06","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/database-administration-random-39\/"},"modified":"2021-08-15T04:10:06","modified_gmt":"2021-08-15T08:10:06","slug":"database-administration-random-39","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=69245","title":{"rendered":"Database Administration : Random #39"},"content":{"rendered":"

Vacuum:<\/b>vacuum is a useful command to maintain PostGreSql database integrity. Also, it permanently removes deleted database records (by default PostGreSql does not delete permanently). It also rearranges page tables, segments for better performance. vacuum should be run regularly for optimized performance. You can also automate the execution. <\/p>\n

Syntax: vacuum [FULL|Analyze|Verbose|table name]
Example:
vacuum member verbose
vacuum full
vacuum analyze full<\/p>\n

vacuum also has linux command line command like
vacuumdb dbname
vacuum -a -f -v -z<\/p>\n

——–<\/p>\n

PostGreSql maintains a list of databases in the pg_database system table. Sometimes when it\/the table gets corrupted, a full vacuum on all databases may fix the issue. When the table gets corrupted many operations like pg_dump may not work and you may get error messages like missing entry in the pg_database table.<\/p>\n

———-<\/p>\n

Backup command:<\/b>
pg_dump options dbname > destination txt\/tar file <\/p>\n

Example: pg_dump -Ft -b mydb > db.tar <\/p>\n

Restore Command:
Example: pg_restore -d newdb db.tar <\/p>\n

————–<\/p>\n

Linux and PostGreSQL<\/b><\/p>\n

commands to access PostGreSql:
su – postgres
password:<\/p>\n

psql -l : list all databases<\/p>\n

——–<\/p>\n

From: http:\/\/sitestree.com\/?p=4805
Categories:39
Tags:
Post Data:2012-09-16 12:23:46<\/p>\n

    Shop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a>\n    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a> \n    In Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a>\n    <a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\">http:\/\/SitesTree.com<\/a>\n    8112223 Canada Inc.\/JustEtc: <a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\">http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a>\n    Shop Online: <a href='https:\/\/www.ShopForSoul.com'> https:\/\/www.ShopForSoul.com\/<\/a>\n    Medium: <a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"> https:\/\/medium.com\/@SayedAhmedCanada <\/a>\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
Vacuum:vacuum is a useful command to maintain PostGreSql database integrity. Also, it permanently removes deleted database records (by default PostGreSql does not delete permanently). It also rearranges page tables, segments for better performance. vacuum should be run regularly for optimized performance. You can also automate the execution. Syntax: vacuum [FULL|Analyze|Verbose|table name]Example: vacuum member verbosevacuum fullvacuum … <\/p>\n
Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-69245","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69412,"url":"http:\/\/bangla.sitestree.com\/?p=69412","url_meta":{"origin":69245,"position":0},"title":"Comparison: FireBird, MySQL, PostGreSQL #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"PosTGRESQL Provides better query responsetime than firebird and MySql. Firebird stands somewhere in the middle. A little longer response time than PostGreSql.http:\/\/benchw.sourceforge.net\/benchw_results_open3.html Several PostGreSQL versions are compared at:http:\/\/benchw.sourceforge.net\/benchw_results_postgres_history.html Several MySQL versions are compared at:http:\/\/benchw.sourceforge.net\/benchw_results_mysql_indexes.html A good comparison among these databases will be found at:http:\/\/www.geocities.com\/mailsoftware42\/db\/ Mentionable comments PostGreSQL Supports 400+GB DB.One\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69428,"url":"http:\/\/bangla.sitestree.com\/?p=69428","url_meta":{"origin":69245,"position":1},"title":"Tools to create ER diagrams from a database dynamically #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"Microsoft Visio, and dbVisualizer provide features to create ER diagrams from existing database tables.Why needed?ER diagram is very useful to understand the total database structure that helps a new programmer to work on the existing databases more efficiently.Visio:While creating Database diagrams, a menu item named database is displayed. Reverse Engineering\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69422,"url":"http:\/\/bangla.sitestree.com\/?p=69422","url_meta":{"origin":69245,"position":2},"title":"Speed: Firebird vs. PostGreSql #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"Please read.According to this article postgresql faster than firebird. But I also got information\/tests where firebird is faster than postgresql. http:\/\/archives.postgresql.org\/pgsql-advocacy\/2003-06\/msg00280.php However, Speed may not be the only factor to select a database product. We can improve raw speed in many alternate ways, hardware solutions, ram, faster storage, faster CPU.\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":70215,"url":"http:\/\/bangla.sitestree.com\/?p=70215","url_meta":{"origin":69245,"position":3},"title":"Must Read: Database Driven Software Development #106","author":"Author-Check- Article-or-Video","date":"August 29, 2021","format":false,"excerpt":"If you are developing database driven applications, you must need to know and clearly understand the following concepts. Yes, you also need to apply them in your design and implementation. If you do not follow proper database design strategies, many complexities will arise, adjusting new requirements may become cumbersome to\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":24463,"url":"http:\/\/bangla.sitestree.com\/?p=24463","url_meta":{"origin":69245,"position":4},"title":"Java Spring: Components to Deal with Database (SQL Aspect) #Root","author":"Author-Check- Article-or-Video","date":"April 10, 2021","format":false,"excerpt":"Java Spring: Components to Deal with Database (SQL Aspect) JPA: Java Persistence API including spring-data-jpa, spring-orm and Hibernate JOOQ: Persistence support using Java Object Oriented Querying MyBatis: Persistence support using MyBatis JDBC: JDBC databases H2: H2 database (with embedded support) HSQLDB: HSQLDB database (with embedded support) Apache Derby: Apache Derby\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69416,"url":"http:\/\/bangla.sitestree.com\/?p=69416","url_meta":{"origin":69245,"position":5},"title":"Important Links for Mysql, PostGreSQL, Firebird, EnterpriseDB, Ingres #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"Firebird and postgresql:http:\/\/www.linuxjournal.com\/node\/7010 Important comment: easy to migrate from oracle to firebird than to postgre or mysql. From interbase to firebird will be better as they are similar. http:\/\/forums.devshed.com\/firebird-sql-development-61\/mysql--vs--firebird-sql-62269.html : Firebird is far better choice than mysqlAs for Performance, MySQL will outperform Firebird on almost all tests on local machine......On\u2026","rel":"","context":"In "C# - Misc"","block_context":{"text":"C# - Misc","link":"http:\/\/bangla.sitestree.com\/?cat=1973"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69245","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69245"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69245\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69245"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}